Business Statistics excel assignment

Project  5

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 consider the ‘School Type’ column.  Assuming the requirements are met, construct a 90% confidence interval for the proportion of the schools that are ‘Private’.  Be sure to interpret your results.
  2. For each of the 2 majors construct a 95% confidence interval for the mean of the column ‘Annual % ROI’.  Be sure to interpret your results.