Scatterplot a) Make an XY scatter plot linked to the following data on this sheet

Subject:MathPrice:3.87 Bought7

Share With

Scatterplot a) Make an XY scatter plot linked to the following data on this sheet.

X                                  Y

6.981	12.266
3.982	8.455
2.084	5.951
9.113	14.395
2.280	7.435
6.567	11.332
1.897	7.011
7.186	12.716
4.094	9.214
1.257	7.499
7.199	10.473
2.136	6.124
3.032	8.832
3.735	9.295
8.612	34.622
0.338	7.155
5.348	10.475
9.208	13.650
7.570	13.910
8.646	11.895
1.953	7.387
3.475	7.871
3.962	10.482
8.084	11.727
4.866	8.688

b) The scatterplot reveals an outlier. Copy the data to a new sheet or a new area on this sheet, and remove the outlier. You should now have 24 rows of data above. Make a new scatterplot from the revised data.

c) Right click on the points, Add Trendline, Display Equation on chart, Display R-Squared value on chart

d) Read the intercept directly from the chart equation label. The elevation of the line above the origin with 3 decimal places =

e) Read the slope directly from the chart equation label. The slope of the line with 3 decimal places =

f) So, when X increases by 1, the change in Y =

g) Read R2 directly from the chart equation label. The amount of the variation in Y explained by X in percent is =