Question
Compute Using: The data to the left, Microsoft Excel functions, or Data Analysis Toolpak, Regression A consumer organization wants to develop a regression model to
Compute Using: The data to the left, Microsoft Excel functions, or Data Analysis Toolpak, Regression
A consumer organization wants to develop a regression model to predict mileage (as measured by miles
per gallon) based on the horsepower of the car's engine and the weight of the car (in pounds). Data were
collected from a sample of 50 rental car models.
1. Determine the regression coefficient, b0, b1, and b2 (be sure to indicate the units for b0, b1, and b2!!). State the multiple regression equation.
2. Interpret the meaning of b1, and b2.
3. Explain why the regression coefficient b0 has no practical meaning in the context of this problem.
4. Predict the miles per gallon for cars that have 60 horsepower and weight 2,000 pounds.
5. If you were consulting for this organization and were provided these data to make a preliminary
analysis, what would be your recommended next steps for the organization?
Auto Data | ||
MPG | Horsepower | Weight |
43.1 | 48.0 | 1985 |
19.9 | 110.0 | 3365 |
19.2 | 105.0 | 3535 |
17.7 | 165.0 | 3445 |
18.1 | 139.0 | 3205 |
20.3 | 103.0 | 2830 |
21.5 | 115.0 | 3245 |
16.9 | 155.0 | 4360 |
15.5 | 142.0 | 4054 |
18.5 | 150.0 | 3940 |
27.2 | 71.0 | 3190 |
41.5 | 76.0 | 2144 |
46.6 | 65.0 | 2110 |
23.7 | 100.0 | 2420 |
27.2 | 84.0 | 2490 |
39.1 | 58.0 | 1755 |
28.0 | 88.0 | 2605 |
24.0 | 92.0 | 2865 |
20.2 | 139.0 | 3570 |
20.5 | 95.0 | 3155 |
28.0 | 90.0 | 2678 |
34.7 | 63.0 | 2215 |
36.1 | 66.0 | 1800 |
35.7 | 80.0 | 1915 |
20.2 | 85.0 | 2965 |
23.9 | 90.0 | 3420 |
29.9 | 65.0 | 2380 |
30.4 | 67.0 | 3250 |
36.0 | 74.0 | 1980 |
22.6 | 110.0 | 2800 |
36.4 | 67.0 | 2950 |
27.5 | 95.0 | 2560 |
33.7 | 75.0 | 2210 |
44.6 | 67.0 | 1850 |
32.9 | 100.0 | 2615 |
38.0 | 67.0 | 1965 |
24.2 | 120.0 | 2930 |
38.1 | 60.0 | 1968 |
39.4 | 70.0 | 2070 |
25.4 | 116.0 | 2900 |
31.3 | 75.0 | 2542 |
34.1 | 68.0 | 1985 |
34.0 | 88.0 | 2395 |
31.0 | 82.0 | 2720 |
27.4 | 80.0 | 2670 |
22.3 | 88.0 | 2890 |
28.0 | 79.0 | 2625 |
17.6 | 85.0 | 3465 |
34.4 | 65.0 | 3465 |
20.6 | 105.0 | 3380 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started