Write a minimum 4 page report explaining the results from your analysis of the ROI of Business Majors and Engineering Majors. Use your results from each week’s assignment to make this report.

For each of the 2 majors calculate the mean, median, minimum, maximum, range, and standard deviation for the columns ‘Cost’ and ’30-Year ROI

Engineering Major

Minimum $64,930.00

Maximum $230,100.00

Mean $164,680.00

Median $214,350.00

Standard Dev $66,385.12

Range $165,170.00

Business Major

Minimum $87,030.00

Maximum $229,900.00

Mean $188,632.00

Median $215,200.00

Standard Dev $50,503.43

Range $142,870.00

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

Engineering

11÷20=0.55=55

Business

16÷20=0.80=80

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.

Engineering

4÷11=0.36=36

Business

4÷16=.025=25