Revised mpg Ratings

1. Using Excel, draw a scatterplot using "Old" as your independent variable (x) and "New" as your dependent variable (y).
2. What does the scatter plot tell you about the relationship between "Old" and "New" mpgs?
   1. Week positive linear correlation
   2. Strong positive linear correlation
   3. Weak negative linear correlation
   4. Strong negative linear correlation
   5. No linear correlation
3. Using Excel, find the linear correlation coefficient, r. What does the value of r tell us?
4. Using Excel, find the linear regression equation. Write the equation in y = mx + b form.
5. Using the linear regression equation found in part D, predict the "New" mpg for an "Old" mpg of 19 mpg.