Using the ROI data set:

1. For each of the 2 majors calculate the mean, median, minimum, maximum, range, and standard deviation for the columns ‘Cost’ and ’30-Year ROI’.

2. By hand or with Excel, for each of the 2 majors calculate the probability that a college picked from the column for ‘School Type’ is ‘Private’.

3. By hand or with Excel, for each of the 2 majors find the probability that a college with the ‘School Type’ ‘Private’ has a ’30-Year ROI’ between $1,500,000 and $1,800,000.

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%
Public	$104,500.00	$1,690,000.00	10.10%
Public	$69,980.00	$1,685,000.00	11.50%
Private	$219,400.00	$1,676,000.00	7.60%
Public	$64,930.00	$1,668,000.00	11.70%