Complete 2 Part Easy Business Statistics Assignment

Complete 2 Part Easy Business Statistics Assignment

PART 1:
For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadsheet (ATTACHED).
Using the ROI data set:

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

PART 2:
For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadsheet (ATTACHED).
Using the ROI data set:

For each of the 2 majors test the hypothesis at the 5% significance level:

The mean ‘Cost’ for a college is $160,000. Be sure to interpret your results.

For Business versus Engineering majors conduct a two sample test of the hypothesis at the 10% significance level (assume the variances are not equal):

The average ’30-Year ROI’ for Business majors is less than for Engineering Majors. Be sure to interpret your results.

PLEASE USE THE ATTACHMENT FOR BOTH PARTS