9.5 Practice

For this exercise, you will switch the explanatory and response variables. That means changing the roles of x and y values for the same data set. Following the guidelines above, use Excel to:

1. Construct the scatter plot.
2. Calculate the correlation coefficient.
3. Determine the regression line’s slope and y-intercept.
4. Draw the regression line in the scatter plot.