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