Project Week 2For these project questions throughout the course you will need to reference the dat

Project Week 2For 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 calculate the mean, median, minimum, maximum, range, and standard deviation for the columns ‘Cost’ and ’30-Year ROI’. 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’.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 TypePrivatePrivatePrivatePublicPrivatePublicPrivatePrivatePrivatePrivatePrivatePrivatePrivatePrivatePrivatePublicPublicPrivatePrivatePrivateBest College ROI by Majo 2013: Payscale.comCost30 Year ROIAnnual 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.007.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 TypePrivatePrivatePrivatePrivatePrivatePublicPrivatePrivatePublicPrivatePublicPrivatePublicPrivatePublicPublicPublicPublicPrivatePublicCost30 Year ROIAnnual ROI$221,700.00 $2,412,000.008.70%$213,000.00 $2,064,000.008.30%$230,100.00 $1,949,000.007.90%$222,600.00 $1,947,000.008.00%$225,800.00 $1,938,000.008.00%$87,660.00 $1,937,000.0011.20%$224,900.00 $1,915,000.007.90%$221,600.00 $1,878,000.007.90%$125,100.00 $1,854,000.009.80%$215,700.00 $1,794,000.007.90%$92,530.00 $1,761,000.0010.60%$217,800.00 $1,752,000.007.70%$89,700.00 $1,727,000.0010.70%$229,600.00 $1,716,000.007.50%$101,500.00 $1,703,000.0010.20%$115,500.00 $1,694,000.009.70%$104,500.00 $1,690,000.0010.10%$69,980.00 $1,685,000.0011.50%$219,400.00 $1,676,000.007.60%$64,930.00 $1,668,000.0011.70%