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 dev

     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