For the assignment below, prepare answers in a Word document (.doc or .docx) and submit a single file to the Dropbox.  You should use Excel to calculate your answers, and be sure to submit both your calculations and final answers. Calculations can be pasted from Excel into your Word document. Note that Excel calculations are supporting documentation, but you still need to explain the exact answers in narrative form in order to receive full credit. In addition to the textbook, check out the Unit 5 Resources section for additional content including  PowerPoints and video tutorials that might aid you in your calculations.  You can find a "case study template" to use under Course Home.  Remember to include a title page, introduction, conclusion, and reference list. See further below for grading rubric. NOTE: You will need to access the 'Analysis Toolpak' in Excel in order to perform the calculations for this case.  If you have not already installed this free add-in, please see the Week 5 Resources area to view the 'Installing Excel Analysis Toolpak' instructions. CASE STUDY: Touchdown Corp: Touchdown Corp is a major manufacturer of football equipment. Management believes that Touchdown's market share could be increased with the introduction of a wind-resistant, longer-lasting football. Therefore, the research group at Touchdown has been investigating a new football coating designed to resist wind and provide a more durable ball. The tests with the coating have been promising. One of the researchers voiced concern about the effect of the new coating on throwing distances. Touchdown would like the new wind-resistant football to offer throwing distances comparable to those of the current-model football. To compare the throwing distances for the two balls, 40 footballs of both the new and current models were subjected to distance tests. The testing was performed with a mechanical throwing machine so that any difference between the mean distances for the two models could be attributed to a difference in the two models. The results of the tests, with distances measured to the nearest foot are included in the attached data file Touchdown. Prepare a report that addresses the following:      a. Formulate and present the rationale for a hypothesis test that Touchdown could use to compare the throwing distances of the current and new footballs.      b. Analyze the data to provide the hypothesis testing conclusion. What is the p-value for your test? What is your recommendation for Touchdown?      c. Provide descriptive statistical summaries of the data for each model

INSTRUCTIONS:

For the assignment below, prepare answers in a Word document (.doc or .docx) and submit a single file to the Dropbox.  You should use Excel to calculate your answers, and be sure to submit both your calculations and final answers. Calculations can be pasted from Excel into your Word document. Note that Excel calculations are supporting documentation, but you still need to explain the exact answers in narrative form in order to receive full credit. In addition to the textbook, check out the Unit 5 Resources section for additional content including  PowerPoints and video tutorials that might aid you in your calculations.  You can find a "case study template" to use under Course Home.  Remember to include a title page, introduction, conclusion, and reference list. See further below for grading rubric.

NOTE: You will need to access the 'Analysis Toolpak' in Excel in order to perform the calculations for this case.  If you have not already installed this free add-in, please see the Week 5 Resources area to view the 'Installing Excel Analysis Toolpak' instructions.

CASE STUDY:

Touchdown Corp: Touchdown Corp is a major manufacturer of football equipment. Management believes that Touchdown's market share could be increased with the introduction of a wind-resistant, longer-lasting football. Therefore, the research group at Touchdown has been investigating a new football coating designed to resist wind and provide a more durable ball. The tests with the coating have been promising.

One of the researchers voiced concern about the effect of the new coating on throwing distances. Touchdown would like the new wind-resistant football to offer throwing distances comparable to those of the current-model football. To compare the throwing distances for the two balls, 40 footballs of both the new and current models were subjected to distance tests. The testing was performed with a mechanical throwing machine so that any difference between the mean distances for the two models could be attributed to a difference in the two models. The results of the tests, with distances measured to the nearest foot are included in the attached data file Touchdown.

Prepare a report that addresses the following:

     a. Formulate and present the rationale for a hypothesis test that Touchdown could use to compare the throwing distances of the current and new footballs.

     b. Analyze the data to provide the hypothesis testing conclusion. What is the p-value for your test? What is your recommendation for Touchdown?

     c. Provide descriptive statistical summaries of the data for each model.

     d. What is the 95% confidence interval for the population mean throwing distance of each model, and what is the 95% confidence interval for the difference between the means of the two populations?

     e. Do you see a need for larger sample sizes and more testing with the footballs? Discuss.