In: Math
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 for this problem. Include Excel results with your submission. a. State the multiple regression equation for this problem. b. Interpret the meaning of the slopes, b1 and b2, in this problem. c. Does the regression coefficient, b0, has a practical meaning in the context of this problem. d. Predict the miles per gallon for cars that have 190 horsepower and weigh 3,500 pounds. e. Compute the coefficient of multiple determination, r2, and interpret its meaning. f. Compute the adjusted r2.