Dashb X G The ox X Pokem X h Hulu + X 10.3M X " MindT X Excel ( X Excel ( X Questi X C | Cheg x C Target X (119) \\ X Cours( X + C https:/g.cengage.com/staticb/ui/evo/index.html? deploymentld=5935112189509097482354739820&elSBN=9780357110614&snapshotl.. 6 * Gh*30 Update : C Chapter 16 Learn... Khoi v CENGAGE | MINDTAP Q Search this course ? My Home 10.3 Microsoft Excel: Structured Activity #3 X Question 1 Courses 0/10 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. Catalog and Study Tools 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 A-7 Rental Options College Success Tips 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 Career Success Tips 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? RECOMMENDED FOR YOU 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? bongo Check In! Your Body and (to 2 decimals) Wellness Self-Assessment iz!] For which round is the population mean score lower? Help c. What is the margin of error for a 90% confidence interval estimate for the difference between the population means? Give Feedback (to 2 decimals) A+ Could this confidence interval have been used to test the hypothesis in part (a)? v Explain. I Ice the noint of the difference hotweon the two nonullation means and add and cuhtract thic marain of error If yarn I vl in the interval the difference O Back NextDash X G The c X Poker X h Hulu x 10.3 x Mind X Excel X Excel X Excel x Ques X C | Che x C Targe X (119) X Cour X + | about:blank Update : C Chapter 16 Learn... Excel template - Saved Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments 5 v [ v Arial 10 B V M Av . .. Ev ab General $ v 00 . .. F2 X V fx After reading these instructions delete all text in this shaded area. A B D E G H I J K L M N First Final Part a Player Round Round Differences Michael Letzig 74 71 After reading these instructions delete alll text in this shaded area. WN Scott Verplank 69 67 D.A. Points 76 74 Use the XLMiner Analysis ToolPak to conduct your t-Test analysis. Jerry Kelly 66 70 Soren Hansen 76 76 After deleting all text in this shaded area, set the output range in D.J. Trahan 69 76 the ToolPak to the top left cell of this area (F2) Bubba Watson 72 71 Reteif Goosen 70 67 Your t-Test analysis output should fit into this shaded area. 10 Jeff Klauk 72 76 11 Kenny Perry 69 72 12 Aron Price 68 71 13 Charles Howell 77 69 14 Jason Dufner 68 77 15 Mike Weir 66 74 16 Carl Pettersson 69 66 17 Bo Van Pelt 72 65 Ernie Els 69 67 19 Cameron Beckman 68 66 Part b Formula Difference Between the Two 20 Nick Watney 74 67 Population Means (to 2 decimals) #N/A 21 Tommy Armour III 99 70 22 Part c 23 Margin of Error (to 2 decimals) #N/A 24 25 26 27 28 29 30 31 E Data + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft 100% +