Notice: Trying to access array offset on value of type bool in /home/flixwrit/domains/raywriters.com/public_html/wp-content/themes/Divi/includes/builder/functions.php on line 2421
Expert answer:MA215 Grantham Week 2 Probability and Standard Dev - Ray writers
Select Page

Solved by verified expert:Project Week 2 For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadheet. 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.Excell Sheet Attached with ROI Data
w_2_roi_by_major.xlsx

Unformatted Attachment Preview

Don't use plagiarized sources. Get Your Custom Essay on
Expert answer:MA215 Grantham Week 2 Probability and Standard Dev
Just from \$10/Page

School Type
Private
Private
Private
Public
Private
Public
Private
Private
Private
Private
Private
Private
Private
Private
Private
Public
Public
Private
Private
Private
Best College ROI by Majo 2013: Payscale.com
Cost
\$222.700,00
\$176.400,00
\$212.200,00
\$125.100,00
\$212.700,00
\$92.910,00
\$214.900,00
\$217.800,00
\$225.600,00
\$217.300,00
\$226.500,00
\$215.500,00
\$223.500,00
\$226.600,00
\$189.300,00
\$89.700,00
\$87.030,00
\$218.200,00
\$229.900,00
\$148.800,00
30 Year ROI
\$1.786.000,00
\$1.758.000,00
\$1.714.000,00
\$1.535.000,00
\$1.529.000,00
\$1.501.000,00
\$1.485.000,00
\$1.483.000,00
\$1.444.000,00
\$1.442.000,00
\$1.441.000,00
\$1.438.000,00
\$1.428.000,00
\$1.414.000,00
\$1.397.000,00
\$1.382.000,00
\$1.376.000,00
\$1.343.000,00
\$1.339.000,00
\$1.321.000,00
Annual ROI
7,70%
8,40%
7,80%
9,10%
7,40%
10,10%
7,30%
7,20%
7,00%
7,10%
7,00%
7,20%
7,00%
7,00%
7,50%
9,90%
10,00%
6,90%
6,70%
8,10%
School Type
Private
Private
Private
Private
Private
Public
Private
Private
Public
Private
Public
Private
Public
Private
Public
Public
Public
Public
Private
Public
Cost
\$221.700,00
\$213.000,00
\$230.100,00
\$222.600,00
\$225.800,00
\$87.660,00
\$224.900,00
\$221.600,00
\$125.100,00
\$215.700,00
\$92.530,00
\$217.800,00
\$89.700,00
\$229.600,00
\$101.500,00
\$115.500,00
\$104.500,00
\$69.980,00
\$219.400,00
\$64.930,00
30 Year ROI
Annual ROI
\$2.412.000,00
8,70%
\$2.064.000,00
8,30%
\$1.949.000,00
7,90%
\$1.947.000,00
8,00%
\$1.938.000,00
8,00%
\$1.937.000,00
11,20%
\$1.915.000,00
7,90%
\$1.878.000,00
7,90%
\$1.854.000,00
9,80%
\$1.794.000,00
7,90%
\$1.761.000,00
10,60%
\$1.752.000,00
7,70%
\$1.727.000,00
10,70%
\$1.716.000,00
7,50%
\$1.703.000,00
10,20%
\$1.694.000,00
9,70%
\$1.690.000,00
10,10%
\$1.685.000,00
11,50%
\$1.676.000,00
7,60%
\$1.668.000,00
11,70%