60.1K

Verified Solution

Link Copied!

For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadheet. Download it here.

Using the ROI data set:

1. 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.
   1. What are the two possible data values in this column?
   2. Given which data value you are looking for, which one is the "success?" Which one is the "failure?"
   3. What proportion of the values is the success? This is your p.
   4. How many values are there in all? This is your n.
   5. What is your z-sub-alpha-over-two value? Did you get it from the chart on page 340? I hope so... :)
   6. Show how these values have been put into a formula and what the result was.
   7. Explain how to get the interval. What did you do with your answer in the previous step?
   8. State and interpret the interval.
   9. Repeat these steps for the second major.

G9 1 School Type Cost 30 Year ROI Annual ROI 8.70% 8.30% 7.90% 8.00% 8.00% $87,660.00 $1,937,000.00 11.20% 7.90% 7.90% 9.80% 7.90% $92,530.00 $1,761,000.00 10.60% 7 70% $89,700.00 $1,727,000.00 10.70% 7.50% $101,500.00 $1,703,000.00 10.20% 9.70% $104,500.00 $1,690,000.00 10.10% $69,980.00 $1,685,000.00 11.50% 7.60% $64,930.00 $1,668,000.00 11.70% 2 Private $221,700.00 $2,412,000.00 3 Private $213,000.00 $2,064,000.00 4 Private $230,100.00 $1,949,000.00 5 Private $222,600.00 $1,947,000.00 6 Private $225,800.00 $1,938,000.00 7 Public 8 Private $224,900.00 $1,915,000.00 9 Private $221,600.00 $1,878,000.00 $125,100.00 $1,854,000.00 11 Private $215,700.00 $1,794,000.00 10 Public 12 Public 13 Private $217,800.00 $1,752,000.00 Private$229,600.00 $1,716,000.00 $115,500.00 $1,694,000.00 4 Public 15 16 Public 17 Public 18 Public 19 Public 20 Private 21 Public $219,400.00 $1,676,000.00 1 School Type 2 Private 3 Private 4 Private 5 Public 6 Private 7 Public 8 Private 9 Private 0 Private 1 Private 2 Private 3 Private 4 Private 5 Private 6 Private 7 Public 8 Public 9 Private 0 Private 1 Private 2 Best College ROI by Majo 2013: Payscale.com Cost 30 Year ROI Annual ROI $222,700.00 $1,786,000.00 $176,400.00 $1,758,000.00 $212,200.00 $1,714,000.00 $125,100.00 $1,535,000.00 $212,700.00 $1,529,000.00 $92,910.00 $1,501,000.00 $214,900.00 $1,485,000.00 $217,800.00 $1,483,000.00 $1,444,000.00 $217,300.00 $1,442,000.00 $226,500.00 $1,441,000.00 $215,500.00 $1,438,000.00 $223,500.00 $1,428,000.00 $226,600.00 $1,414,000.00 $189,300.00 $1,397,000.00 $89,700.00 $1,382,000.00 $87,030.00 $1,376,000.00 $218,200.00 $1,343,000.00 $229,900.00 $1,339,000.00 $148,800.00 $1,321,000.00 7 .70% 8.40% 7.80% 9.10% 7.40% 10.10% 7.30% 7.20% 7.00% 7.10% 7.00% 7.20% 7.00% 7.00% 7.50% 9.90% 10.00% 6.90% 6.70% 8.10% $225,600.00

Answer & Explanation Solved by verified expert

See Answer