16 Nov 2021
Problem 85b
Page 685
Section: BRINGING IT TOGETHER: HOMEWORK
Chapter 12: LINEAR REGRESSION AND CORRELATION
Textbook ExpertVerified Tutor
16 Nov 2021
Given information
Given : Table is
- To Draw a scatter plot of the data.
Step-by-step explanation
Step 1.
Let us draw a scatter plot :
While creating scatterplot, consider "size" as an independent variable on axis and consider "sales price" as a dependent variable on axis. The scatterplot is made in Excel using below steps.
1. Select the given data and Go to Insert in the menu bar.
2. Select "Scatter" from the heading "Charts".
3. Select "Scatter with only Markers".
4. Click on the displayed chart and on the right hand side of the chart, a plus sign can be seen. Click on it and select chart elements written as Axis, Axis Title, Data label, Chart Title. Label them as shown in scatterplot below.
Unlock all Textbook Solutions
Already have an account? Log in