Question: 1 - 3 ) Construct an ( x , y ) scatterplot to visually display the relationship using living area as the independent variable and
Construct an xy scatterplot to visually display the relationship using living area as the independent variable and sale price as the dependent variable. Follow
steps in the instructions document. Place the graph in cell C
In cell C insert a Scatter Chart for the Price versus Living Area data from the Data worksheet.
Select the Scatter chart from the provided chart options in the Charts group of the Insert tab of the Ribbon.
Then choose Select Data in the Design tab on the Ribbon. Delete any series created automatically using the Remove button and add new series using the Add button. Select the range of data on the Data worksheet. Note that Price should stand for the Y values and Living Area is the X values. Do not add the series name.
Go to the Add Chart Elements dropdown list in the Design tab of the Ribbon. Delete the legend. Above the chart, add the title Predicted sales price, y for given living area, x as the chart title. On the Ribbon, select design Style
HOW DO YOU SELECT DATA FROM OTHER PAGE AND PUT IT INTO SCATTER CHART
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
