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:

1. For each of the 2 majors calculate the mean, median, minimum, maximum, range, and standard deviation for the columns ‘Cost’ and ’30-Year ROI’.
2. Define each of the terms in #1, and explain how each can be used to provide information about a data set.
3. What is the difference between a sample and a population? When you did the calculations in #1, do these numbers apply to a sample or a population?
4. 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 ‘Public’.
5. 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.
6. Fill in these tables

Place an X either under “business” or under “engineering” for each factor. Then, in the final box, determine if the factor is desirable for our scenario (ex: Do we want a higher cost?)

Factor	Business	Engineering	Is this factor desirable for our scenario? (answer y / n )
Higher mean cost
Higher median cost
Broader/wider range of costs
Higher standard deviation of cost
Higher maximum cost
Higher minimum cost

Factor	Business	Engineering	Is this factor desirable for our scenario? (answer y / n )
Higher mean 30-year ROI
Higher median 30-year ROI
Broader/wider range of 30-year ROIs
Higher standard deviation of 30-year ROI
Higher maximum 30-year ROI
Higher minimum 30-year ROI

This is your highlighted box for your project: Hint: Write your answers in full sentences so that you can drop them into your week 8 project should you choose to use this information. Your Week 8 project is a paper, so having the sentences will save you time later.

What would a greater range NOT be helpful in our scenario?

What does it mean if there is a greater standard deviation in terms of ROI? Is that a good thing? Explain.

Why would it not be accurate to say something like “The ____ major has the school with the highest 30-year ROI, therefore, it is the best major?”

Which major is looking like it has the better ROI right now? Why?

Critical question: Are your conclusions here pertaining to a sample or to a population? Why? What are the implications of what the data pertains to?

*** Remember that written portions go on a MS Word document.

Looking for a solution written from scratch with No plagiarism and No AI?

WHY CHOOSE US?

We deliver quality original papers	Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected
Free revisions	We offer our clients multiple free revisions just to ensure you get what you want.
Discounted prices	All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount
100% originality	We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI
On-time delivery	We will deliver your paper on time even on short notice or  short deadline, overnight essay or even an urgent essay