Question

14.5 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, b₁ and b₂, in this problem.

                c.   Explain why the regression coefficient, b₀, 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

Answer 1