Regression analysis of the predicted mpg based on weight and horsepower. 1) Are
ID: 3051448 • Letter: R
Question
Regression analysis of the predicted mpg based on weight and horsepower.
1) Are horsepower and weight, taken together, have a significant relationship with mileage? Explain your answer with statistical evidence.
2)Does each variable, individually have a significant relationship with the mileage, and should be included in the model? Explain your answer with statistical evidence.
Weight MPG 13.1 Regression Analysis 19.9 3366 3535 110 105 165 139 bz, b1, J Intercepts ba, b, 60 Standard Error R Square, Standard Error F, Residual or Regression S5, Residual 55 Cakealotions -1.CO69 00014 07494 70 2813 2451.974 D1175 58.1571 0.0375 26582 4,1755 ANJA 819.8581 AN/A AN/A 17.7 Regression Statistics Multiple R 0.8657 R Square 0749 Adjusted R Square 0.7388 Standard Error 41766 Observations 3445 181 3205 2890 3245 4360 103 21.5 18.9 15.6 4064 ANOVA Confidence level t Critical Value Half Width 60 Half Width 62 Half Width hz 95% 20117 S477 D.0657 D0028 18.5 27.2 150 3940 Regressian 2451.9737 70.2813 12259R69 17.4440 41.5 Residual Total 2110 49 3271.8418 466 237 2420 8 8 8 8 272 2490 38.1 1755 Interest Coefficients Standard Error 58.1571 2.6592 -0.1175 0.0326 -0.0069 00014 21.8780 -36003 P-value Lower 95% 0.0000 52.8094 00008 -0 1832 00000 -0.0097 Upper 95% 63.50B -0.0519 -0.0041 Lower 95% Uuper 95% 52 8094 63.50B -0.1832 -0.0519 -0.0097 -0.0041 28.0 2005 2005 24.0 Weight -4 9035 202 3570 20.5 2B.O 34.7 2678 Correlation 1.7418735IE 2215 " weicht ys 1,1175x458. 1571 y=-0.00600x-. 1574 1HCO 35.7 202 8 8 8 8 8 2965 Descriptive Summary Descriptive Summary 3120 23.9 28.9 30.4 2380 Horsepower 90.84 Weight 2756.52 3250 36.0 22.6 25.4 1995 175S 4350 MPG(?) HP(60) WT(2000) MPG - 58.1508-0.1175 x (HP) - 0.0069 x (WT) 58.1571 -7.06152799- 51.105 27.5 2605 33.7 44.6 1980 2000 2960 2560 2 1950 2615 1965 2930 1968 2070 Mean Median Mode Minimum Maximum Range Variance Standard Deviation Coeff. of Variation Skewness Kurtosis Count Standard Error 37.3056 Median Made Minimum Maximum Range Variance Standard Deviation Coeff. of Variation Skewness Kurtosis Count Standard Error 329 38.0 743.0351 27.2587 30.01% 1.0262 0.5206 50 3.8SSO 403289.7549 635.0510 23.04% 0 3509 -0.4571 24.2 38.1 39.4 26.4 2900 89 ACS8 31.3 2542 1EES 2335 2770 2670 Ga83%82%8B3 a 8 2890 ENNREE a 2625 3165 3465 3380Explanation / Answer
1)
ho: horsepower and weight, taken together, don't have a significant relationship with mileage. model is not significant.
h1: horsepower and weight, taken together, have a significant relationship with mileage. model is significant.
with F = 70.28 and p-value < 0.05, I reject ho and conclude that horsepower and weight, taken together, have a significant relationship with mileage. model is significant.
2)
hypothesis 1
ho1: horsepower DONT has a significant relationship with mileage
h11: horsepower has a significant relationship with mileage
with t= -3.60 and p-value<0.05, i reject Ho and conclude that horsepower has a significant relationship with mileage
hypothesis 2
ho1: weight DONT has a significant relationship with mileage
h11: weight has a significant relationship with mileage
with t= -4.90 and p-value<0.05, i reject Ho and conclude that weight has a significant relationship with mileage