Write a minimum 4 page report explaining the results from your analysis of the ROI of Business Majors and Engineering Majors. Use your results from each week’s assignment to make this report.
feliciafeci
BobGleaminBudgetWK7.xlsxBusiness Major
| School Type | Cost | 30 Year ROI | Annual ROI | |||||||||
| Private | $222,700.00 | $1,786,000.00 | 7.70% | SUMMARY OUTPUT | ||||||||
| Private | $176,400.00 | $1,758,000.00 | 8.40% | |||||||||
| Private | $212,200.00 | $1,714,000.00 | 7.80% | Regression Statistics | ||||||||
| Public | $125,100.00 | $1,535,000.00 | 9.10% | Multiple R | 0.9787209512 | |||||||
| Private | $212,700.00 | $1,529,000.00 | 7.40% | R Square | 0.9578947004 | |||||||
| Public | $92,910.00 | $1,501,000.00 | 10.10% | Adjusted R Square | 0.955417918 | |||||||
| Private | $214,900.00 | $1,485,000.00 | 7.30% | Standard Error | 0.0023845146 | |||||||
| Private | $217,800.00 | $1,483,000.00 | 7.20% | Observations | 19 | |||||||
| Private | $225,600.00 | $1,444,000.00 | 7.00% | |||||||||
| Private | $217,300.00 | $1,442,000.00 | 7.10% | ANOVA | ||||||||
| Private | $226,500.00 | $1,441,000.00 | 7.00% | df | SS | MS | F | Significance F | ||||
| Private | $215,500.00 | $1,438,000.00 | 7.20% | Regression | 1 | 0.0021990237 | 0.0021990237 | 386.7496502319 | 0 | |||
| Private | $223,500.00 | $1,428,000.00 | 7.00% | Residual | 17 | 0.0000966605 | 0.0000056859 | |||||
| Private | $226,600.00 | $1,414,000.00 | 7.00% | Total | 18 | 0.0022956842 | ||||||
| Private | $189,300.00 | $1,397,000.00 | 7.50% | |||||||||
| Public | $89,700.00 | $1,382,000.00 | 9.90% | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Public | $87,030.00 | $1,376,000.00 | 10.00% | Intercept | 0.1185746794 | 0.002121554 | 55.8904834691 | 1.03615220115437E-20 | 0.1140985917 | 0.1230507671 | 0.1140985917 | 0.1230507671 |
| Private | $218,200.00 | $1,343,000.00 | 6.90% | 222700 | -0.0000002158 | 0.000000011 | -19.6659515466 | 0 | -0.0000002389 | -0.0000001926 | -0.0000002389 | -0.0000001926 |
| Private | $229,900.00 | $1,339,000.00 | 6.70% | |||||||||
| Private | $148,800.00 | $1,321,000.00 | 8.10% | |||||||||
| Best College ROI by Majo 2013: Payscale.com | ||||||||||||
| RESIDUAL OUTPUT | ||||||||||||
| Observation | Predicted 0.077 | Residuals | ||||||||||
| 1 | 0.0805154177 | 0.0034845823 | ||||||||||
| 2 | 0.0727913725 | 0.0052086275 | ||||||||||
| 3 | 0.0915836724 | -0.0005836724 | ||||||||||
| 4 | 0.0726834948 | 0.0013165052 | ||||||||||
| 5 | 0.0985288404 | 0.0024711596 | ||||||||||
| 6 | 0.0722088328 | 0.0007911672 | ||||||||||
| 7 | 0.071583142 | 0.000416858 | ||||||||||
| 8 | 0.0699002495 | 0.0000997505 | ||||||||||
| 9 | 0.0716910197 | -0.0006910197 | ||||||||||
| 10 | 0.0697060696 | 0.0002939304 | ||||||||||
| 11 | 0.0720793795 | -0.0000793795 | ||||||||||
| 12 | 0.0703533359 | -0.0003533359 | ||||||||||
| 13 | 0.069684494 | 0.000315506 | ||||||||||
| 14 | 0.0777321724 | -0.0027321724 | ||||||||||
| 15 | 0.0992214154 | -0.0002214154 | ||||||||||
| 16 | 0.0997974824 | 0.0002025176 | ||||||||||
| 17 | 0.0714968398 | -0.0024968398 | ||||||||||
| 18 | 0.068972501 | -0.001972501 | ||||||||||
| 19 | 0.0864702682 | -0.0054702682 |
222700 Line Fit Plot
176400 212200 125100 212700 92910 214900 217800 225600 217300 226500 215500 223500 226600 189300 89700 87030 218200 229900 148800 8.4000000000000005E-2 7.8E-2 9.0999999999999998E-2 7.3999999999999996E-2 0.10100000000000001 7.2999999999999995E-2 7.1999999999999995E-2 7.0000000000000007E-2 7.0999999999999994E-2 7.0000000000000007E-2 7.1999999999999995E-2 7.0000000000000007E-2 7.0000000000000007E-2 7.4999999999999997E-2 9.9000000000000005E-2 0.1 6.9000000000000006E-2 6.7000000000000004E-2 8.1000000000000003E-2 Predicted 0.077 176400 212200 125100 212700 92910 214900 217800 225600 217300 226500 215 500 223500 226600 189300 89700 87030 218200 229900 148800 8.051541770169697E-2 7.2791372523244413E-2 9.1583672384786791E-2 7.2683494797288389E-2 9.8528840381836708E-2 7.2208832803081796E-2 7.1583141992536764E-2 6.9900249467622522E-2 7.1691019718492802E-2 6.970606956090164E-2 7.2079379531934551E-2 7.0353335916637894E-2 6.9684494015710446E-2 7.7732172372031103E-2 9.9221415382474504E-2 9.9797482439079765E-2 7.1496839811771934E-2 6.8972501024400557E-2 8.6470268174470427E-2222700
0.077
Engineering Major
| School Type | Cost | 30 Year ROI | Annual ROI | |||||||||
| Private | $221,700.00 | $2,412,000.00 | 8.70% | SUMMARY OUTPUT | ||||||||
| Private | $213,000.00 | $2,064,000.00 | 8.30% | |||||||||
| Private | $230,100.00 | $1,949,000.00 | 7.90% | Regression Statistics | ||||||||
| Private | $222,600.00 | $1,947,000.00 | 8.00% | Multiple R | 0.9837243039 | |||||||
| Private | $225,800.00 | $1,938,000.00 | 8.00% | R Square | 0.9677135062 | |||||||
| Public | $87,660.00 | $1,937,000.00 | 11.20% | Adjusted R Square | 0.9658143007 | |||||||
| Private | $224,900.00 | $1,915,000.00 | 7.90% | Standard Error | 0.002766586 | |||||||
| Private | $221,600.00 | $1,878,000.00 | 7.90% | Observations | 19 | |||||||
| Public | $125,100.00 | $1,854,000.00 | 9.80% | |||||||||
| Private | $215,700.00 | $1,794,000.00 | 7.90% | ANOVA | ||||||||
| Public | $92,530.00 | $1,761,000.00 | 10.60% | df | SS | MS | F | Significance F | ||||
| Private | $217,800.00 | $1,752,000.00 | 7.70% | Regression | 1 | 0.0038999873 | 0.0038999873 | 509.5359594271 | 0 | |||
| Public | $89,700.00 | $1,727,000.00 | 10.70% | Residual | 17 | 0.000130118 | 0.000007654 | |||||
| Private | $229,600.00 | $1,716,000.00 | 7.50% | Total | 18 | 0.0040301053 | ||||||
| Public | $101,500.00 | $1,703,000.00 | 10.20% | |||||||||
| Public | $115,500.00 | $1,694,000.00 | 9.70% | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Public | $104,500.00 | $1,690,000.00 | 10.10% | Intercept | 0.1273128662 | 0.0017012144 | 74.8364599809 | 7.3896489481079E-23 | 0.1237236175 | 0.1309021149 | 0.1237236175 | 0.1309021149 |
| Public | $69,980.00 | $1,685,000.00 | 11.50% | 221700 | -0.0000002204 | 0.0000000098 | -22.5729032122 | 0 | -0.000000241 | -0.0000001998 | -0.000000241 | -0.0000001998 |
| Private | $219,400.00 | $1,676,000.00 | 7.60% | |||||||||
| Public | $64,930.00 | $1,668,000.00 | 11.70% | |||||||||
| RESIDUAL OUTPUT | ||||||||||||
| Observation | Predicted 0.087 | Residuals | ||||||||||
| 1 | 0.0803747597 | 0.0026252403 | ||||||||||
| 2 | 0.0766064891 | 0.0023935109 | ||||||||||
| 3 | 0.0782592394 | 0.0017407606 | ||||||||||
| 4 | 0.0775540659 | 0.0024459341 | ||||||||||
| 5 | 0.1079955215 | 0.0040044785 | ||||||||||
| 6 | 0.077752396 | 0.001247604 | ||||||||||
| 7 | 0.0784796061 | 0.0005203939 | ||||||||||
| 8 | 0.0997449923 | -0.0017449923 | ||||||||||
| 9 | 0.0797797696 | -0.0007797696 | ||||||||||
| 10 | 0.1069223357 | -0.0009223357 | ||||||||||
| 11 | 0.0793169995 | -0.0023169995 | ||||||||||
| 12 | 0.1075459734 | -0.0005459734 | ||||||||||
| 13 | 0.0767166725 | -0.0017166725 | ||||||||||
| 14 | 0.1049456464 | -0.0029456464 | ||||||||||
| 15 | 0.1018605126 | -0.0048605126 | ||||||||||
| 16 | 0.1042845463 | -0.0032845463 | ||||||||||
| 17 | 0.1118916047 | 0.0031083953 | ||||||||||
| 18 | 0.0789644128 | -0.0029644128 | ||||||||||
| 19 | 0.1130044565 | 0.0039955435 |
