10.3 Excel Activity 3 - XLMiner Analysis ToolPak for Hypothesis Tests and Confidence Intervals (Structured)

Please see attachments.

Scores in the first and final rounds for a sample of 20 golfers who competed in tournaments are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.

Suppose you would like to determine if the mean score for the first round of an event is significantly different than the mean score for the final round. Does the pressure of playing in the final round cause scores to go up? Or does the increased player concentration cause scores to come down?

10.3 Excel Activity 3 - XLMiner Analysis ToolPak for Hypothesis Tests and Confidence Intervals (Structured) Question 1 0/10 Video Submit Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak Scores in the first and final rounds for a sample of 20 golfers who competed in tournaments are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. Open spreadsheet Suppose you would like to determine if the mean score for the first round of an event is significantly different than the mean score for the final round. Does the pressure of playing in the final round cause scores to go up? Or does the increased player concentration cause scores to come down? a. Use a = .10 to test for a statistically significantly difference between the population means for first- and final-round scores. What is the p-value? p-value is (to 4 decimals) What is your conclusion? There significant difference between the mean scores for the first and final rounds. b. What is the point estimate of the difference between the two population means? (to 2 decimals) For which round is the population mean score lower? c. What is the margin of error for a 90% confidence interval estimate for the difference between the population means? (to 2 decimals) Could this confidence interval have been used to test the hypothesis in part (a)? v Explain. Use the point of the difference between the two population means and add and subtract this margin of error. If zero in the interval the difference is not statistically significant. If zero v in the interval the difference is statistically significant. Check My Work Reset Problem