A sample of twenty automobiles was taken, and the miles per gallon (MPG), horsepower and total weight were recorded. Develop a linear regression model to predict MPG using horsepower as the only independent variable.
MPG HORSEPOWER WEIGHT
44 67 1,844
44 50 1,998
40 62 1,752
37 69 1,980
37 66 1,797
34 63 2,199
35 90 2,404
32 99 2,611
30 63 3,236
28 91 2,606
26 94 2,580
26 88 2,507
25 124 2,922
22 97 2,434
20 114 3,248
21 102 2,812
18 114 3,382
18 142 3,197
16 153 4,380
16 139 4,036
State the linear equation,
Explain the overall statistical significance of the model,
Explain the statistical significance for each independent variable in the model
Interpret the Adjusted R2,
Is this a good predictive equation(s)? Which variables should be excluded (if any) and why? Explain.