business stats (easy and short)

profilecrytal20

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. 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.
    • 9 years ago
    • 5
    Answer(1)

    Purchase the answer to view it

    blurred-text
    • attachment
      week_2_project.docx