Details of this Paper

A sample of 20 automobiles was taken, and the...

Description

Solution


Question

A sample of 20 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. Develop another model with weight as the independent variable. Which of these two models is better? Explain. Problem 4-27 Data Independent Independent MPG HORSEPOWER WEIGHT MPG 44 67 1,844 44 44 50 1,998 44 40 62 1,752 40 37 69 1,980 37 37 66 1,797 37 34 63 2,199 34 35 90 2,404 35 32 99 2,611 32 30 63 3,236 30 28 91 2,606 28 26 94 2,580 26 26 88 2,507 26 25 124 2,922 25 22 97 2,434 22 20 114 3,248 20 21 102 2,812 21 18 114 3,382 18 18 142 3,197 18 16 153 4,380 16 16 139 4,036 16 SUMMARY OUTPUT Regression Statistics Multiple R 0.903472205 R Square 0.816262026 Adjusted R Square 0.794645794 Standard Error 4.123181571 Observations 20 ANOVA df SS MS F Significance F Regression 2 1283.939354 641.9696768 37.76153106 5.56789E-07 Residual 17 289.0106465 17.00062626 Total 19 1572.95 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 57.68586149 3.651217677 15.79907488 1.35504E-11 49.98246563 65.38925735 49.98246563 65.38925735 HORSEPOWER -0.165665619 0.059546235 -2.782134216 0.012776532 -0.291297193 -0.040034045 -0.291297193 -0.040034045 WEIGHT -0.005046012 0.002444125 -2.064547898 0.054568174 -0.010202664 0.00011064 -0.010202664 0.00011064 57.51514986 iv) Chapter 4, pp. 143-144 ? Complete Problem 4-27. Refer to the file provided for this problem. Ignore the questions in the text. Instead, respond to the following questions: (1) State the linear equation, (2) Explain the overall statistical significance of the model, (3) Explain the statistical significance for each independent variable in the model (4) Interpret the Adjusted R2, (5) Is this a good predictive equation(s)? Which variables should be excluded (if any) and why? Explain.

 

Paper#11633 | Written in 18-Jul-2015

Price : $25
SiteLock