BUSINESS STATISTICS FINAL PAPER
ylang
ROI_by_Major7.xlsxBusiness Major Regression
| SUMMARY OUTPUT | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.9700650885 | |||||||
| R Square | 0.941026276 | |||||||
| Adjusted R Square | 0.937749958 | |||||||
| Standard Error | 0.0027434208 | |||||||
| Observations | 20 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 1 | 0.0021617256 | 0.0021617256 | 287.2206776244 | 0 | |||
| Residual | 18 | 0.0001354744 | 0.0000075264 | |||||
| Total | 19 | 0.0022972 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | 0.1180399 | 0.0024295 | 48.5862138 | 0.0000000 | 0.1129357 | 0.1231441 | 0.1129357 | 0.1231441 |
| Cost | -0.0000002 | 0.0000000 | -16.9475862 | 0.0000000 | -0.0000002 | -0.0000002 | -0.0000002 | -0.0000002 |
| x | 160000 | |||||||
| Y(hat) | 8.42% |
Engineering Major Regression
| SUMMARY OUTPUT | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.9754311699 | |||||||
| R Square | 0.9514659673 | |||||||
| Adjusted R Square | 0.9487696321 | |||||||
| Standard Error | 0.0033049537 | |||||||
| Observations | 20 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 1 | 0.0038543411 | 0.0038543411 | 352.8737764731 | 0 | |||
| Residual | 18 | 0.0001966089 | 0.0000109227 | |||||
| Total | 19 | 0.00405095 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | 0.1267820 | 0.0020208 | 62.7371918 | 0.0000000 | 0.1225364 | 0.1310276 | 0.1225364 | 0.1310276 |
| Cost | -0.0000002 | 0.0000000 | -18.7849348 | 0.0000000 | -0.0000002 | -0.0000002 | -0.0000002 | -0.0000002 |
| x | 160000 | |||||||
| Y(hat) | 9.25% |
Business Major
| Business Major | Engineering Major | |||||||
| School Type | Cost | 30 Year ROI | Annual ROI | School Type | Cost | 30 Year ROI | Annual ROI | |
| Private | $222,700.00 | $1,786,000.00 | 7.70% | Private | $221,700.00 | $2,412,000.00 | 8.70% | |
| Private | $176,400.00 | $1,758,000.00 | 8.40% | Private | $213,000.00 | $2,064,000.00 | 8.30% | |
| Private | $212,200.00 | $1,714,000.00 | 7.80% | Private | $230,100.00 | $1,949,000.00 | 7.90% | |
| Public | $125,100.00 | $1,535,000.00 | 9.10% | Private | $222,600.00 | $1,947,000.00 | 8.00% | |
| Private | $212,700.00 | $1,529,000.00 | 7.40% | Private | $225,800.00 | $1,938,000.00 | 8.00% | |
| Public | $92,910.00 | $1,501,000.00 | 10.10% | Public | $87,660.00 | $1,937,000.00 | 11.20% | |
| Private | $214,900.00 | $1,485,000.00 | 7.30% | Private | $224,900.00 | $1,915,000.00 | 7.90% | |
| Private | $217,800.00 | $1,483,000.00 | 7.20% | Private | $221,600.00 | $1,878,000.00 | 7.90% | |
| Private | $225,600.00 | $1,444,000.00 | 7.00% | Public | $125,100.00 | $1,854,000.00 | 9.80% | |
| Private | $217,300.00 | $1,442,000.00 | 7.10% | Private | $215,700.00 | $1,794,000.00 | 7.90% | |
| Private | $226,500.00 | $1,441,000.00 | 7.00% | Public | $92,530.00 | $1,761,000.00 | 10.60% | |
| Private | $215,500.00 | $1,438,000.00 | 7.20% | Private | $217,800.00 | $1,752,000.00 | 7.70% | |
| Private | $223,500.00 | $1,428,000.00 | 7.00% | Public | $89,700.00 | $1,727,000.00 | 10.70% | |
| Private | $226,600.00 | $1,414,000.00 | 7.00% | Private | $229,600.00 | $1,716,000.00 | 7.50% | |
| Private | $189,300.00 | $1,397,000.00 | 7.50% | Public | $101,500.00 | $1,703,000.00 | 10.20% | |
| Public | $89,700.00 | $1,382,000.00 | 9.90% | Public | $115,500.00 | $1,694,000.00 | 9.70% | |
| Public | $87,030.00 | $1,376,000.00 | 10.00% | Public | $104,500.00 | $1,690,000.00 | 10.10% | |
| Private | $218,200.00 | $1,343,000.00 | 6.90% | Public | $69,980.00 | $1,685,000.00 | 11.50% | |
| Private | $229,900.00 | $1,339,000.00 | 6.70% | Private | $219,400.00 | $1,676,000.00 | 7.60% | |
| Private | $148,800.00 | $1,321,000.00 | 8.10% | Public | $64,930.00 | $1,668,000.00 | 11.70% | |
| Best College ROI by Majo 2013: Payscale.com |
Business Major
Annual ROI
y = --0.0000002 x + 0.118 R² = 0.941
222700 176400 212200 125100 212700 92910 214900 217800 225600 217300 226500 215500 223500 226600 189300 89700 87030 218200 229900 148800 7.6999999999999999E-2 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.00000000000000 07E-2 7.0000000000000007E-2 7.4999999999999997E-2 9.9000000000000005E-2 0.1 6.9000000000000006E-2 6.7000000000000004E-2 8.1000000000000003E-2
Cost
Annual ROI
Engineering Major
Annual ROI
y = -0.0000002 x + 0.1268 R² = 0.9515
221700 213000 230100 222600 225800 87660 224900 221600 125100 215700 92530 217800 89700 229600 101500 115500 104500 69980 219400 64930 8.6999999999999994E-2 8.3000000000000004E-2 7.9000000000000001E-2 0.08 0.08 0.112 7.9000000000000001E-2 7.9000000000000001E-2 9.8000000000000004E-2 7.9000000000000001E-2 0.106 7.6999999999999999E-2 0.107 7.4999999999999997E-2 0.10199999999999999 9.7000000000000003E-2 0.10100000000000001 0.115 7.5999999999999998E-2 0.11700000000000001
Cost
Annual ROI
Engineering Major
| School Type | Cost | 30 Year ROI | Annual ROI |
| Private | $221,700.00 | $2,412,000.00 | 8.70% |
| Private | $213,000.00 | $2,064,000.00 | 8.30% |
| Private | $230,100.00 | $1,949,000.00 | 7.90% |
| Private | $222,600.00 | $1,947,000.00 | 8.00% |
| Private | $225,800.00 | $1,938,000.00 | 8.00% |
| Public | $87,660.00 | $1,937,000.00 | 11.20% |
| Private | $224,900.00 | $1,915,000.00 | 7.90% |
| Private | $221,600.00 | $1,878,000.00 | 7.90% |
| Public | $125,100.00 | $1,854,000.00 | 9.80% |
| Private | $215,700.00 | $1,794,000.00 | 7.90% |
| Public | $92,530.00 | $1,761,000.00 | 10.60% |
| Private | $217,800.00 | $1,752,000.00 | 7.70% |
| Public | $89,700.00 | $1,727,000.00 | 10.70% |
| Private | $229,600.00 | $1,716,000.00 | 7.50% |
| Public | $101,500.00 | $1,703,000.00 | 10.20% |
| Public | $115,500.00 | $1,694,000.00 | 9.70% |
| Public | $104,500.00 | $1,690,000.00 | 10.10% |
| Public | $69,980.00 | $1,685,000.00 | 11.50% |
| Private | $219,400.00 | $1,676,000.00 | 7.60% |
| Public | $64,930.00 | $1,668,000.00 | 11.70% |
