Project Week 2
For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadheet.
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 calculatethe 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 theprobability that a college with the “School Type’ “Private’ has a’30-Year ROI’ between $1,500,000 and $1,800,000.
Excell Sheet Attached with ROI Data