1252p

1252p.docx

Home >Business & Finance homework help >Accounting homework help >1252p

Using the ROI data set from the Excel Spreadsheet. Please provide all the steps required to reach the solution. If you cannot do this, then please don’t request the assignment.

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

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