In cell C$6$ insert a Scatter Chart for the Price versus Living Area data from the Data worksheet.

Inserting Chart

Select the Scatter chart from the provided chart options in the Charts group of the Insert tab of the Ribbon.

Selecting Data Series

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.

Note: Do not include the titles of the columns to the range of data.

Edit Chart Elements

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 $1.$

Chart Size and Position

Go to the Format tab on the Ribbon. Set the chart height and width, and then drag it to position the entire chart so that it fits within cell C$6.$

Add the trendline to the data on the chart.

Adding Linear Trendline

Select any point on the chart and right click on it$.$ Select Add Trendline. In the Trendline Options window select Linear with automatic trendline name.

Trendline Options

In theTrendline Options window check the "Display equation on chart" and "Display R$-$squared value on chart" boxes. You can grab the added equation and R$-$squared value and drag it to

any place on the chart so that it is more visible to read.

Use the regression model of Data Analysis for the data.

Adding Regression Model

Go to the Data worksheet. Select the Data Analysis in the Analysis group of the Data tab of the Ribbon $($note you should add this Add$-$in in case you do not have in the Data tab already$).$

Select Regression and click OK$.$ Select the cells in the Price column as the Input Y Range and the cells in the Living Area column as the Input X Range. Choose cell J$1$ on the Data worksheet

as the output range. Do not check any additional boxes in the regression model menu.

Note: Do not include the titles of the columns to the range of data.

On the $14-21$ worksheet, identify the value of the correlation coefficient, $r,$ between living area and selling price to four decimal places in cell D$9.$

Interpret the value of the correlation coefficient, $r,$ in terms of direction and strength of the linear model. Choose the correct answers from the drop$-$down menus in cells D$11$ and D$12.$

In cells E$20$ and G$20$ complete the least squares equation. Round the y$-$intercept to the nearest integer and the slope to two decimal places.

Identify the value of the $y-$intercept, $b_0$ in cell D$22.$ Keep the same number of decimal places as the value in the equation above.

Interpret the $y-$intercept, $b_0,$ in terms of the data. Choose the correct answers from the drop$-$down menus in cells D$24$ and H$24.$

In cell D$26$ decide whether the interpretation of the y$-$intercept is a meaningful estimate in the context of this problem.

Identify the value of the slope, $b_1,$ in cell D$28.$ Keep the same number of decimal places as the value in the equation above.

Interpret the slope, $b_{1,}$ in terms of the data. Choose the correct answers from the drop$-$down menu in cell D$30.$ Round the amount in cell G$30$ to the nearest cent.

Identify the value of $R^2$ in cell $D32.$ Round the percent to two decimal places.

Calculate the expected sale price of a $1500$ square foot house in cell D$37$ using the value$($s$)$ found in step $6$ for the least squares regression equation. Round the value to the nearest dollar.

Calculate the expected price increase for an additional $200$ square feet in cell D$40$ using the value$($s$)$ found in step $6$ for the least squares regression equation. Round the value to the nearest

dollar.