Excel template - SavedF2123456789FileHomeAPlayerMichael LetzigScott VerplankD.A. PointsJerry KellySoren HansenD.J. TrahanBubba WatsonReteif GoosenJeff Klauk1011 Kenny Perry12Aron Price13Charles Howell14 Jason Dufner15Mike Weir16Carl Pettersson17Bo Van Pelt18 Ernie Els19Cameron Beckman=20Nick Watney21 Tommy Armour III222324252627282930313222InsertArialBFirstRound7173656970667268657269757574Data +65 76 75 77Draw Page Layout6572✓ 10сFinalRound6576697171717373696971686867666667686966VCalculation Mode: Automatic Workbook StatisticsBfx After reading these instructions delete all text in this shaded area.FFormulasDifferences☆ESearch (Option + Q)DataReviewViewvPart cMargin of Error (to 2 decimals)Part bDifference Between the Two PopulationMeans (to 2 decimals)abHelpGGeneralPart aAfter reading these instructions delete all text in this shaded area.Use the XLMiner Analysis ToolPak to conduct your t-Test analysis.After deleting all text in this shaded area, set the output range inthe ToolPak to the top left cell of this area (F2).Your t-Test analysis output should fit into this shaded area.H←0.00Formula.00→.0#N/A#N/AVKEvEditingATVLMGive Feedback to MicrosoftCommentsN100% + 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 thefollowing questions.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 ToolPakXOpen spreadsheetSuppose 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 inthe final round cause scores to go up? Or does the increased player concentration cause scores to come down?a. Usea = .10 to test for a statistically significantly difference between the population means for first- and final-round scores. What is thep-value?p-value isWhat is your conclusion?There is noFinal round(to 4 decimals)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?significant difference between the mean scores for the first and final rounds.Yesc. 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)?

Question

Excel template - SavedF2123456789FileHomeAPlayerMichael LetzigScott VerplankD.A. PointsJerry KellySoren HansenD.J. TrahanBubba WatsonReteif GoosenJeff Klauk1011 Kenny Perry12Aron Price13Charles Howell14 Jason Dufner15Mike Weir16Carl Pettersson17Bo Van Pelt18 Ernie Els19Cameron Beckman=20Nick Watney21 Tommy Armour III222324252627282930313222InsertArialBFirstRound7173656970667268657269757574Data +65 76 75 77Draw Page Layout6572✓ 10сFinalRound6576697171717373696971686867666667686966VCalculation Mode: Automatic Workbook StatisticsBfx After reading these instructions delete all text in this shaded area.FFormulasDifferences☆ESearch (Option + Q)DataReviewViewvPart cMargin of Error (to 2 decimals)Part bDifference Between the Two PopulationMeans (to 2 decimals)abHelpGGeneralPart aAfter reading these instructions delete all text in this shaded area.Use the XLMiner Analysis ToolPak to conduct your t-Test analysis.After deleting all text in this shaded area, set the output range inthe ToolPak to the top left cell of this area (F2).Your t-Test analysis output should fit into this shaded area.H>←0.00Formula.00→.0#N/A#N/AVKEvEditingATVLMGive Feedback to MicrosoftCommentsN100% + 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 thefollowing questions.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 ToolPakXOpen spreadsheetSuppose 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 inthe final round cause scores to go up? Or does the increased player concentration cause scores to come down?a. Usea = .10 to test for a statistically significantly difference between the population means for first- and final-round scores. What is thep-value?p-value isWhat is your conclusion?There is noFinal round(to 4 decimals)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?significant difference between the mean scores for the first and final rounds.Yesc. 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)?

Accepted Answer

The random sample of size, nd=20
The scores data of the first and final rounds are:

First Round…