Description
Project Week 5
For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadheet. Download it here.
- For each of the 2 majors consider the ‘School Type’ column. Construct a 92% confidence interval for the proportion of the schools that are ‘Private’.
- For each of the 2 majors, construct a 98% confidence interval for the mean of the column ‘Annual % ROI’.
- In a highlighted box, discuss the following. How do these confidence intervals provide information about the which is the better major in terms of Annual ROI? Compare the confidence intervals. Which is narrower? Wider? What does the width have to do with advising someone on which major has the better ROI? Why is it important to know the proportion of schools that are private? What factors differ in public and private schools that could influence ROI? Is a 98% confidence interval a guarantee that the ROI will be in the interval? Why or why not?
Hints - these websites might help to find z or t sub alpha over 2. (you have to know which one)
http://simulation-math.com/_Statistics/FindZalphaover2.cshtml
http://simulation-math.com/_Statistics/Findtalphaover2.cshtml
Grading Criteria Assignments | Maximum Points |
Meets or exceeds established assignment criteria | 40 |
Demonstrates an understanding of lesson concepts | 20 |
Clearly presents well-reasoned ideas and concepts | 30 |
Uses proper mechanics, punctuation, sentence structure, and spelling | 10 |
Total | 100 |
Explanation & Answer
Please find answer.Thank you.
School Type
Private
Private
Private
Private
Private
Private
Private
Private
Private
Private
Private
Private
Private
Private
Private
Private
Public
Public
Public
Public
Best College ROI by Majo 2013: Payscale.com
Cost
$222.700,00
$176.400,00
$212.200,00
$212.700,00
$214.900,00
$217.800,00
$225.600,00
$217.300,00
$226.500,00
$215.500,00
$223.500,00
$226.600,00
$189.300,00
$218.200,00
$229.900,00
$148.800,00
$125.100,00
$92.910,00
$89.700,00
$87.030,00
30 Year ROI
$1.786.000,00
$1.758.000,00
$1.714.000,00
$1.529.000,00
$1.485.000,00
$1.483.000,00
$1.444.000,00
$1.442.000,00
$1.441.000,00
$1.438.000,00
$1.428.000,00
$1.414.000,00
$1.397.000,00
$1.343.000,00
$1.339.000,00
$1.321.000,00
$1.535.000,00
$1.501.000,00
$1.382.000,00
$1.376.000,00
Annual ROI
7,70%
8,40%
7,80%
7,40%
7,30%
7,20%
7,00%
7,10%
7,00%
7,20%
7,00%
7,00%
7,50%
6,90%
6,70%
8,10%
9,10%
10,10%
9,90%
10,00%
$188.632,00
164680
$211.118,75
$98.685,00
2,139319552
$23.952,00
Private
Public
16
4
School Type
Private
Private
Private
Private
Private
Private
Private
Private
Private
Private
Private
Public
Public
Public
Public
Public
Public
Public
Public
Public
Cost
$221.700,00
$213.000,00
$230.100,00
$222.600,00
$225.800,00
$224.900,00
$221.600,00
$215.700,00
$217.800,00
$229.600,00
$219.400,00
$87.660,00...