Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates
Run the t-Test: Two-Sample Assuming Unequal Variances for the Data File Golf (Chapter 10) using the video How to Add Excel’s Data Analysis ToolPak (Links to an external site.) for assistance. In a managerial report, use the methods of hypothesis testing to 1. Formulate and present the rationale for a hypothesis test that Par could use to compare the driving distances of the current and new golf balls. 2. Analyze the data to provide the hypothesis testing conclusion. What is the p-value for your test? What is your recommendation for Par, Inc.? 3. Provide descriptive statistical summaries of the data for each model. 4. Explain what the 95% confidence interval is for the population mean driving distance of each model, and explain what the 95% confidence interval is for the difference between the means of the two populations. 5. Discuss whether you see a need for larger sample sizes and more testing with the golf balls.