A consumer organization wants to develop a regression model to predict gasoline mileage (as measured by miles
Fantastic news! We've Found the answer you've been seeking!
Question:
A consumer organization wants to develop a regression model to predict gasoline mileage (as measured by miles per gallon) based on the horsepower of the car’s engine and the weight of the car, in pounds. A sample of 50 recent car models was selected, with the results recorded in the file auto.xls.
a. State the multiple regression equation.
b. Interpret the meaning of the slopes, b1, and b2, in this problem.
c. Explain why the regression coefficient, b0, has no practical meaning in the context of this problem.
d. Predict the mean miles per gallon for cars that have 60 horsepower and weigh 2,000 pounds.
Show how to get all answers in Excel format
MPG | Horsepower | Weight |
43.1 | 48 | 1985 |
19.9 | 110 | 3365 |
19.2 | 105 | 3535 |
17.7 | 165 | 3445 |
18.1 | 139 | 3205 |
20.3 | 103 | 2830 |
21.5 | 115 | 3245 |
16.9 | 155 | 4360 |
15.5 | 142 | 4054 |
18.5 | 150 | 3940 |
27.2 | 71 | 3190 |
41.5 | 76 | 2144 |
46.6 | 65 | 2110 |
23.7 | 100 | 2420 |
27.2 | 84 | 2490 |
39.1 | 58 | 1755 |
28.0 | 88 | 2605 |
24.0 | 92 | 2865 |
20.2 | 139 | 3570 |
20.5 | 95 | 3155 |
28.0 | 90 | 2678 |
34.7 | 63 | 2215 |
36.1 | 66 | 1800 |
35.7 | 80 | 1915 |
20.2 | 85 | 2965 |
23.9 | 90 | 3420 |
29.9 | 65 | 2380 |
30.4 | 67 | 3250 |
36.0 | 74 | 1980 |
22.6 | 110 | 2800 |
36.4 | 67 | 2950 |
27.5 | 95 | 2560 |
33.7 | 75 | 2210 |
44.6 | 67 | 1850 |
32.9 | 100 | 2615 |
38.0 | 67 | 1965 |
24.2 | 120 | 2930 |
38.1 | 60 | 1968 |
39.4 | 70 | 2070 |
25.4 | 116 | 2900 |
31.3 | 75 | 2542 |
34.1 | 68 | 1985 |
34.0 | 88 | 2395 |
31.0 | 82 | 2720 |
27.4 | 80 | 2670 |
22.3 | 88 | 2890 |
28.0 | 79 | 2625 |
17.6 | 85 | 3465 |
34.4 | 65 | 3465 |
20.6 | 105 | 3380 |
Related Book For
Stats Data and Models
ISBN: 978-0321986498
4th edition
Authors: Richard D. De Veaux, Paul D. Velleman, David E. Bock
Posted Date: