5-6 Page Applied Decision Method Paper...Effecs on Gas mileage a Staistical Model. Please be familiar with regression models

profilepepperkitty9
copy_of_project_revised-2.xlsx
Home>Business & Finance homework help>Management homework help>5-6 Page Applied Decision Method Paper...Effecs on Gas mileage a Staistical Model. Please be familiar with regression models

Year

MPG YEAR WEIGHT X3 (FWD) HORSE POWER
20 1975 2790 1 88 SUMMARY OUTPUT
23 1980 2645 1 86
25.1 1985 2825 1 98 Regression Statistics
24 1990 3082 1 123 Multiple R 0.5908404227
24.2 1995 3155 1 144 R Square 0.3490924051
23.4 2000 3313 1 158 Adjusted R Square 0.3084106804
24.7 2005 3337 1 165 Standard Error 3.2222511972
27.7 2010 3351 1 165 Observations 18
31.1 2015 3350 1 169
13.2 1975 4146 0 140 ANOVA
19 1980 3296 0 107 df SS MS F Significance F
20.1 1985 3576 0 135 Regression 1 89.0963333333 89.0963333333 8.5810620826 0.0098236038
19.9 1990 3724 0 159 Residual 16 166.1264444444 10.3829027778
20.5 1995 3784 0 194 Total 17 255.2227777778
20.4 2000 3699 0 228
19.7 2005 3955 0 258 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
20.8 2010 4004 0 292 Intercept -321.5661111111 117.3682851994 -2.739804118 0.0145354518 -570.3757608658 -72.7564613565 -570.3757608658 -72.7564613565
23.5 2015 3972 0 323 YEAR 0.1723333333 0.0588299889 2.9293449921 0.0098236038 0.0476193281 0.2970473385 0.0476193281 0.2970473385

Weight

MPG YEAR WEIGHT X3 (FWD) HORSE POWER
20 1975 2790 1 88 SUMMARY OUTPUT
23 1980 2645 1 86
25.1 1985 2825 1 98 Regression Statistics
24 1990 3082 1 123 Multiple R 0.4503044249
24.2 1995 3155 1 144 R Square 0.2027740751
23.4 2000 3313 1 158 Adjusted R Square 0.1529474547
24.7 2005 3337 1 165 Standard Error 3.5660746546
27.7 2010 3351 1 165 Observations 18
31.1 2015 3350 1 169
13.2 1975 4146 0 140 ANOVA
19 1980 3296 0 107 df SS MS F Significance F
20.1 1985 3576 0 135 Regression 1 51.7525626975 51.7525626975 4.0695931974 0.0607597996
19.9 1990 3724 0 159 Residual 16 203.4702150803 12.7168884425
20.5 1995 3784 0 194 Total 17 255.2227777778
20.4 2000 3699 0 228
19.7 2005 3955 0 258 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
20.8 2010 4004 0 292 Intercept 35.7687481518 6.759301901 5.2917814111 0.0000730157 21.4396682328 50.0978280708 21.4396682328 50.0978280708
23.5 2015 3972 0 323 WEIGHT -0.0039277703 0.0019470207 -2.0173232754 0.0607597996 -0.0080552698 0.0001997293 -0.0080552698 0.0001997293

FWD,RWD

MPG YEAR WEIGHT X3 (FWD) HORSE POWER
20 1975 2790 1 88 SUMMARY OUTPUT
23 1980 2645 1 86
25.1 1985 2825 1 98 Regression Statistics
24 1990 3082 1 123 Multiple R 0.6801503992
24.2 1995 3155 1 144 R Square 0.4626045655
23.4 2000 3313 1 158 Adjusted R Square 0.4290173509
24.7 2005 3337 1 165 Standard Error 2.9278357574
27.7 2010 3351 1 165 Observations 18
31.1 2015 3350 1 169
13.2 1975 4146 0 140 ANOVA
19 1980 3296 0 107 df SS MS F Significance F
20.1 1985 3576 0 135 Regression 1 118.0672222222 118.0672222222 13.7732339598 0.0018968419
19.9 1990 3724 0 159 Residual 16 137.1555555556 8.5722222222
20.5 1995 3784 0 194 Total 17 255.2227777778
20.4 2000 3699 0 228
19.7 2005 3955 0 258 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
20.8 2010 4004 0 292 Intercept 19.6777777778 0.9759452525 20.1627885664 0 17.6088662653 21.7466892902 17.6088662653 21.7466892902
23.5 2015 3972 0 323 X3 (FWD) 5.1222222222 1.3801950122 3.7112307877 0.0018968419 2.196339502 8.0481049425 2.196339502 8.0481049425

Horsepower

MPG YEAR WEIGHT X3 (FWD) HORSE POWER
20 1975 2790 1 88 SUMMARY OUTPUT
23 1980 2645 1 86
25.1 1985 2825 1 98 Regression Statistics
24 1990 3082 1 123 Multiple R 0.0136797471
24.2 1995 3155 1 144 R Square 0.0001871355
23.4 2000 3313 1 158 Adjusted R Square -0.0623011686
24.7 2005 3337 1 165 Standard Error 3.9935496158
27.7 2010 3351 1 165 Observations 18
31.1 2015 3350 1 169
13.2 1975 4146 0 140 ANOVA
19 1980 3296 0 107 df SS MS F Significance F
20.1 1985 3576 0 135 Regression 1 0.0477612374 0.0477612374 0.0029947281 0.9570357677
19.9 1990 3724 0 159 Residual 16 255.1750165404 15.9484385338
20.5 1995 3784 0 194 Total 17 255.2227777778
20.4 2000 3699 0 228
19.7 2005 3955 0 258 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
20.8 2010 4004 0 292 Intercept 22.3705362269 2.5832540184 8.6598282893 0.0000001954 16.8942823441 27.8467901097 16.8942823441 27.8467901097
23.5 2015 3972 0 323 HORSE POWER -0.0007815475 0.0142815942 -0.0547241092 0.9570357677 -0.0310571748 0.0294940797 -0.0310571748 0.0294940797

Multiple

MPG YEAR WEIGHT X3 (FWD) HORSE POWER
20 1975 2790 1 88 SUMMARY OUTPUT
23 1980 2645 1 86
25.1 1985 2825 1 98 Regression Statistics
24 1990 3082 1 123 Multiple R 0.9717128179
24.2 1995 3155 1 144 R Square 0.9442258005
23.4 2000 3313 1 158 Adjusted R Square 0.9270645083
24.7 2005 3337 1 165 Standard Error 1.0464168213
27.7 2010 3351 1 165 Observations 18
31.1 2015 3350 1 169
13.2 1975 4146 0 140 ANOVA
19 1980 3296 0 107 df SS MS F Significance F
20.1 1985 3576 0 135 Regression 4 240.9879316467 60.2469829117 55.0206704477 0.0000000507
19.9 1990 3724 0 159 Residual 13 14.2348461311 1.0949881639
20.5 1995 3784 0 194 Total 17 255.2227777778
20.4 2000 3699 0 228
19.7 2005 3955 0 258 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
20.8 2010 4004 0 292 Intercept -701.185162405 88.5282748364 -7.9204656783 0.0000024942 -892.4388725722 -509.9314522378 -892.4388725722 -509.9314522378
23.5 2015 3972 0 323 YEAR 0.3744492648 0.0457580189 8.1832490478 0.0000017436 0.2755950749 0.4733034546 0.2755950749 0.4733034546
WEIGHT -0.0049934488 0.0013301777 -3.7539712513 0.0024092022 -0.007867123 -0.0021197746 -0.007867123 -0.0021197746
X3 (FWD) -0.8918440424 1.1923271706 -0.7479860095 0.4677848752 -3.4677102901 1.6840222053 -3.4677102901 1.6840222053
HORSE POWER -0.0353561268 0.0105819997 -3.3411574141 0.0053102374 -0.0582171472 -0.0124951063 -0.0582171472 -0.0124951063