# 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

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