Week 2 Assignment 2 (Project)

Week 2 Project

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?

(550 words)

Approximate price: \$22

## How it Works

1

It only takes a couple of minutes to fill in your details, select the type of paper you need (essay, term paper, etc.), give us all necessary information regarding your assignment.

2

Once we receive your request, one of our customer support representatives will contact you within 24 hours with more specific information about how much it'll cost for this particular project.

3

After receiving payment confirmation via PayPal or credit card – we begin working on your detailed outline, which is based on the requirements given by yourself upon ordering.

4

Once approved, your order is complete and will be emailed directly to the email address provided before payment was made!