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