Question

A sample of 20 Automobiles was taken and the miles per gallon (MPG), horsepower (HP), and total weight were recorded. Develop a linear regression model to predict MPG…

MPG	Horsepower	Weight
44	67	1844
44	50	1998
40	62	1752
37	69	1980
37	66	1797
34	63	2199
35	90	2404
32	99	2611
30	63	3236
28	91	2606
26	94	2580
26	88	2507
25	124	2922
22	97	2434
20	114	3248
21	102	2812
18	114	3382
18	142	3197
16	153	4380
16	139	4036

1)Using HP as the independent variable. What is the regression equation?

2) Is your model a good predicting equation? How do you know?

3) Using Total Weight as the independent variable, what is the regression equation?

4)Is this a good predicting model? How do you know?

5) Using MPG and Total weight as independent variables, what is the regression equation?

6) Is the model in part e a good predicting equation? How do you know?   

7)  Predict MPG using the model in part e with HP = 100 and weight = 3 thousand pounds.

Answer 1

Note: Analysis is done by using Excel (data analysis function)

Question 1 and 2

The above result shows that model is significant with Horsepower is significantly contributing by p value is less than 0.05 and model is good fit R- squared 77.02%

Question 3 & 4

The above result shows that model is significant with weight is significantly contributing by p value is less than 0.05 and model is good fit R- squared 73.26%

Question 5 &6

The above result shows that model is significant with Horsepower is significantly contributing by p value is less than 0.05, weight significantly contributing at p value less than 0.1 and model is good fit R- squared 81.63% also Adjusted R squared is 79.46%

Question 7

Predicted MPG = 57.68586149 - 0.165665619 * 100 - 0.005046012 * 3 = 41.10416