Business Statistics – Week #3 AssignmentWeek 3 Project AssignmentFor these project assignments throughout the course you will need to reference the data in the ROI Excel spreadsheet. Download it here.Using the ROI data set:If we select 7 colleges from a major and then record whether they are of ‘School Type’ ‘Private’ or not, is this experiment a binomial one? Why or why not?For each of the 2 majors determine if the ‘Annual % ROI’ appears to be normally distributed. Consider the shape of the histogram and the measures of central tendency (mean and median) to justify your results. Report on each of these with charts and calculations to justify your answers.

Step 1: Read:Review Case Problem 1: Air Force Training Program downloadfrom Chapter 11 of the ebook.Step 2: Do:Run the F-Test Two-Sample for Variances for the Data File Training (Chapter 11) using the video How to Add Excel's Data Analysis ToolPak (Links to an external site.) for assistance.In a managerial report,Use appropriate descriptive statistics to summarize the training time data for each method. What similarities or differences do you observe from the sample data?Conduct a hypothesis test on the difference between the population means for the two methods. Discuss your findings.Compute the standard deviation and variance for each training method. Conduct a hypothesis test about the equality of population variances for the two training methods. Discuss your findings.Explain what conclusion you can reach about any differences between the two methods. What is your recommendation? Explain.Suggest other data or testing that might be desirable before making a final decision on the training program to be used in the future.Step 3: Discuss:What did you find in your analysis of the data? Were there any surprising results? What recommendations would you make based on your findings? Include details from your managerial report to support your recommendations.350 words