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
wk5Homwork.docx
For each of the 2 majors consider the ‘School Type’ column. Assuming the requirements are met, construct a 90% confidence interval for the proportion of the schools that are ‘Private’. Be sure to interpret your results.
Business
|
Sample Size |
20 |
|
Response of Interest |
Private |
|
Count for Response |
16 |
|
Sample Proportion |
0.8 |
|
|
|
|
Confidence Coefficient |
0.9 |
|
Z values |
1.644853627 |
|
|
|
|
Standard Error |
0.871779789 |
|
Margin error |
1.433950147 |
|
|
|
|
Point Estimate |
0.08 |
|
Lower Limit |
-1.353950147 |
|
Upper Limit |
1.513950147 |
Engineering
|
Interval Confidence for Proportion |
|||
|
|
|
|
|
|
Sample Size |
|
20 |
|
|
Response of Interest |
Private |
||
|
Count for Response |
|
10 |
|
|
Sample Proportion |
|
0.5 |
|
|
|
|
|
|
|
Confidence Coefficient |
0.9 |
||
|
Z values |
|
|
1.644854 |
|
|
|
|
|
|
Standard Error |
|
0.689202 |
|
|
Margin error |
|
1.133637 |
|
|
|
|
|
|
|
Point Estimate |
|
0.05 |
|
|
Lower Limit |
|
-1.08364 |
|
|
Upper Limit |
|
1.183637 |
For each of the 2 majors construct a 95% confidence interval for the mean of the column ‘Annual % ROI’. Be sure to interpret your results.
Business
|
30 Year ROI |
|
|
|
|
|
|
|
Mean |
1477800 |
|
|
Standard Error |
29727.05661 |
|
|
Median |
1441500 |
|
|
Mode |
#N/A |
|
|
Standard Deviation |
132943.4387 |
|
|
Sample Variance |
17673957895 |
|
|
Kurtosis |
1.059973389 |
|
|
Skewness |
1.313262635 |
|
|
Range |
465000 |
|
|
Minimum |
1321000 |
|
|
Maximum |
1786000 |
|
|
Sum |
29556000 |
|
|
Count |
20 |
|
|
Confidence Level (95.0%) |
62219.44455 |
|
|
|
|
|
|
|
|
|
|
|
Lower Limit |
Upper Limit |
|
Confidence Interval |
$1,415,580.56 |
$1,540,019.44 |
|
|
|
|
Engineering
|
30 Year ROI |
|
|
|
|
|
|
|
|
|
|
|
Mean |
1838000 |
|
|
|
|
Standard Error |
40204.22 |
|
|
|
|
Median |
1777500 |
|
|
|
|
Mode |
#N/A |
|
|
|
|
Standard Deviation |
179798.7 |
|
|
|
|
Sample Variance |
3.23E+10 |
|
|
|
|
Kurtosis |
4.44257 |
|
|
|
|
Skewness |
1.811239 |
|
|
|
|
Range |
744000 |
|
|
|
|
Minimum |
1668000 |
|
|
|
|
Maximum |
2412000 |
|
|
|
|
Sum |
36760000 |
|
|
|
|
Count |
20 |
|
|
|
|
Confidence Level (95.0%) |
84148.39 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Lower Limit |
|
Upper Limit |
|
Confidence Interval |
$1,753,851.61 |
|
$1,922,148.39 |
