Needs to Done on Time!!!

profileylang
week5Project1.xlsx

Business Major

School Type Cost 30 Year ROI Annual ROI School Type Business Major Engineering Major
Private $222,700.00 $1,786,000.00 7.70% Private 16 11
Private $176,400.00 $1,758,000.00 8.40% Public 4 9
Private $212,200.00 $1,714,000.00 7.80% Total 20 20
Public $125,100.00 $1,535,000.00 9.10% Proportion (p) 0.8 0.55
Private $212,700.00 $1,529,000.00 7.40% Confidence Interval 90% 90%
Public $92,910.00 $1,501,000.00 10.10% Z(Critical) 1.645 1.645
Private $214,900.00 $1,485,000.00 7.30% Stnadard Error 0.0894 0.1112
Private $217,800.00 $1,483,000.00 7.20% Margin Error 0.1471 0.1830
Private $225,600.00 $1,444,000.00 7.00% 90% Lower Limit 0.6529 0.3670
Private $217,300.00 $1,442,000.00 7.10% 90% Upper Limit 0.9471 0.7330
Private $226,500.00 $1,441,000.00 7.00%
Private $215,500.00 $1,438,000.00 7.20% Interpretation
Private $223,500.00 $1,428,000.00 7.00% We are 90% sure that the interval (0.6529,0.9471) contains true population proportion school that are private in business major
Private $226,600.00 $1,414,000.00 7.00% We are 90% sure that the interval (0.3670,0.7330) contains true population proportion school that are private in Engineering major
Private $189,300.00 $1,397,000.00 7.50%
Public $89,700.00 $1,382,000.00 9.90% Annual ROI Business Major Engineering Major
Public $87,030.00 $1,376,000.00 10.00%
Private $218,200.00 $1,343,000.00 6.90% Mean 0.0782 0.09145
Private $229,900.00 $1,339,000.00 6.70% Standard Error 0.0024587117 0.003265026
Private $148,800.00 $1,321,000.00 8.10% Median 0.0735 0.085
Best College ROI by Majo 2013: Payscale.com Mode 0.07 0.079
Standard Deviation 0.0109956929 0.0146016401
Sample Variance 0.0001209053 0.0002132079
Count 20 20
Confidence Interval 95% 95%
Z(Critical) 1.960 1.960
Margin Error 0.0048 0.0064
95% Lower Limit 7.34% 8.51%
95% Upper Limit 8.30% 9.78%
Interpretation
We are 95% sure that the interval (7.34,8.30) contains true mean of annual ROI in percentage of business Major
We are 95% sure that the interval (8.51,9.78) contains true mean of annual ROI in percentage of Engineering Major

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% Annual ROI
Public $104,500.00 $1,690,000.00 10.10%
Public $69,980.00 $1,685,000.00 11.50% Mean 0.09145
Private $219,400.00 $1,676,000.00 7.60% Standard Error 0.003265026
Public $64,930.00 $1,668,000.00 11.70% Median 0.085
Mode 0.079
Standard Deviation 0.0146016401
Sample Variance 0.0002132079
Kurtosis -1.3960284328
Skewness 0.4731131039
Range 0.042
Minimum 0.075
Maximum 0.117
Sum 1.829
Count 20