Project Week 2
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:
? 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.
Categories: