For each of the 2 majors consider the ‘School Type’ column

For each of the 2 majors consider the ‘School Type’ column

Subject: Mathematics    / Statistics
Question

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:

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.
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.

School Type
Private
Private
Private
Public
Private
Public
Private
Private
Private
Private
Private
Private
Private
Private
Private
Public
Public
Private
Private
Private
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
$225,600.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% School Type
Private
Private
Private
Private
Private
Public
Private
Private
Public
Private
Public
Private
Public
Private
Public
Public
Public
Public
Private
Public Cost
30 Year ROI
Annual ROI
$221,700.00 $2,412,000.00
8.70%
$213,000.00 $2,064,000.00
8.30%
$230,100.00 $1,949,000.00
7.90%
$222,600.00 $1,947,000.00
8.00%
$225,800.00 $1,938,000.00
8.00%
$87,660.00 $1,937,000.00
11.20%
$224,900.00 $1,915,000.00
7.90%
$221,600.00 $1,878,000.00
7.90%
$125,100.00 $1,854,000.00
9.80%
$215,700.00 $1,794,000.00
7.90%
$92,530.00 $1,761,000.00
10.60%
$217,800.00 $1,752,000.00
7.70%
$89,700.00 $1,727,000.00
10.70%
$229,600.00 $1,716,000.00
7.50%
$101,500.00 $1,703,000.00
10.20%
$115,500.00 $1,694,000.00
9.70%
$104,500.00 $1,690,000.00
10.10%
$69,980.00 $1,685,000.00
11.50%
$219,400.00 $1,676,000.00
7.60%
$64,930.00 $1,668,000.00
11.70%