3. Scatterplot a) X 6.981 3.982 2.084 9.113 2.280 6.567 1.897 7.186 4.094 1.257 7.199 2.136 3.032 3.735 8.612 0.338 5.348 9.208 7.570 8.646 1.953 3.475 3.962 8.084 4.866 Make an XY scatter plot linked to the following data on this sheet. Y 12.266 8.455 5.951 14.395 7.435 11.332 7.011 12.716 9.214 7.499 10.473 6.124 8.832 9.295 34.622 7.155 10.475 13.650 13.910 11.895 7.387 7.871 10.482 11.727 8.688 b) The scatterplot reveals an outlier. Copy the data to a new sheet or a new area on this sheet, and remove th 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 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 i y ea on this sheet, and remove the outlier. You should now have 24 rows of data above. Make a new scatterplot from the revised data. R-Squared value on chart the line above the origin with 3 decimal places = e with 3 decimal places = n in Y explained by X in percent is = m the revised data