Reference no: EM131743232

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 R2directly from the chart equation label. The amount of the variation in Y explained by X in percent is =