Question

Please show all work and explain. Thank you.

How do horsepower and weight affect the mileage of family cars? Data from a sample of 12 2012 family cars are given below (Data extracted from “Top 2012 Cars,” Consumer Reports, April 2012, pp. 40–73.) 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).

Car	MPG	Horsepower	Weight
Audi A3	25	200	3305
Chrysler 200	21	173	3590
Dodge Avenger	21	173	3440
Ford Fusion	24	240	3365
Honda Accord	25	177	3285
Kia Optima	25	200	3260
Mazda6	24	170	3185
Mitsubishi Galant	23	160	3430
Nissan Altima	26	175	3155
Suburu Legacy	25	170	3390
Toyota Camry	27	173	3155
Volkswagen Passat	25	170	3270

Use Excel to find the multiple regression results. Include Excel results.

a. State the multiple regression equation for this problem.

b. Interpret the meaning of the slopes, b₁ and b₂, in this problem.

Answer 1