Project Assignment
Using the ROI data set:
In Excel, for each of the 2 majors calculate the mean, median, minimum, maximum, range, and standard deviation for the columns ‘Cost' and '30-Year ROI'. Make sure to use the standard deviation of the sample. (You will see an S in the Excel formula - Don't pick the P - that's the population)
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.
Interpretation Questions
(Remember the scenario - you are helping a student choose a major based on which gives the better ROI. Put this part in a Word document ) Put these responses into one paragraph that you can use in your paper in Week 8.
1) You looked at mean and median. Do you want these numbers to be high or low in terms of Cost? Which major has the better cost?
2) You looked at mean and median. Do you want these numbers to be high or low in terms of 30-year ROI? Which major has the better 30- year ROI?
3) You looked at range and standard deviation. Is it better to have smaller ranges and standard deviations when trying to predict or larger ranges and standard deviations when trying to predict? Why? Which major has a better range/standard deviation in terms of prediction?
4) Can you say that from these samples of 20 schools, that ALL schools will be in alignment with what this data is showing? Why or why not?
Format your homework according to the following formatting requirements:
(1) The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
(2) The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
(3) Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.