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
  

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
Order Essay

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%

Purchase answer to see full
attachment

Ray writers

Order your essay today and save 30% with the discount code ESSAYSHELP