Car Weight (in lbs) Car MPG
3250 28
3675 23
3840 19
3935 20
2140 43
4010 22
2565 34
3450 22
2900 28
3345 25
3545 24
3050 31
2540 34
2410 36
2865 30
3810 22
The values in Column A show the weight in pounds of 16 different cars made in 2017. The numbers in Column B are the corresponding gas mileage for each of the cars. Produce a graph with the regression model and R-squared value for this data set. Then answer the following questions.
a. What is the regression model/equation?
b. What is the associated R-squared value?
c. What does the graph tell us about the general relationship between these two variables?
d. A close friend of yours knows that you have just finished your second stats class in that awesome business program at UIW. She is planning to purchase a relatively new (2017) car but is concerned about getting good gas mileage. During the discussion, she tells you the car is a bit heavy at 4,453 pounds. Using this regression equation, tell your friend what her expected gas mileage will be.
e. Your friend winces when you give her the answer from Part D. Then she asks "Are you sure?? That MPG sounds so low!" What is your response?