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.

A B C D E F G H First Final Part a Player Round Round Differences Michael Letzig 65 76 After reading these instructions delete all text in this shaded area. Scott Verplank 77 69 D.A. Points 65 73 Use the XLMiner Analysis ToolPak to conduct your t-Test analysis. Jerry Kelly 75 65 Soren Hansen 70 71 After deleting all text in this shaded area, set the output range in D.J. Trahan 74 74 the ToolPak to the top left cell of this area (F2). Bubba Watson 77 70 Reteif Goosen 71 77 Your t-Test analysis output should fit into this shaded area. Jeff Klauk 75 66 Kenny Perry 71 72 Aron Price 74 69 Charles Howell 66 67 Jason Dufner 74 75 Mike Weir 67 67 Carl Pettersson 66 68 Bo Van Pelt 65 65 Ernie Els 73 70 Cameron Beckman 67 70 Part b Formula Difference Between the Two Nick Watney 76 77 Population Means (to 2 decimals) #N/ Tommy Armour III 74 75 Part c Margin of Error (to 2 decimals) #N/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 guestions. 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 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 e = .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 isnc B @ significant difference between the mean scores for the first and final rounds. P 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? Final round B @ . 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)? Yas E@