Trying to find the LSD's VideoThe International League of Triple-A minor league baseball consists of 14 teams organized into three divisions: North, South, and West. The data showing the average attendance for the 14 teams in the International Leagueare contained in the Excel Online file below. Also shown are the teams' records; W denotes the number of games won, L denotes the number of games lost, and PCT is the proportion of games played that were won.Construct a spreadsheet to answer the following questions.Open spreadsheeta. Use a = .05 to test for any difference in the mean attendance for the three divisions.Calculate the value of the F-statistic (to 2 decimals).6.91The p-value is 0.011O (to 4 decimals).What is your conclusion?There is sufficientVO evidence to conclude that the mean attendance values are not the same across the three divisions of the International League of Triple-A minor league baseball.b. Use Fisher's LSD procedure to test whether there is a significant difference between the means for North (1), South (2), and West (3). Use a = .05.Absolute Value(to 2 decimals)LSD(to 2 decimals)DifferenceConclusion2158.58 O1630.01Significant difference700.921630.01No significant difference vT2 – T32859.50 O2075.52 XSignificant differenceCheck My WorkReset Problem DEGH.MPRTTeam NameDivisionL.PCTAttendancePart a. Rearrange the Attendance values for the Anova: Single-Factor AnalysisBuffalo BisonsNorth66770.46288260.3820.594Lehigh Valley IronPigsNorth55898506NorthSouthWestNorthNorthPawtucket Red Sox855891247716.835558.258417.75Rochester Red Wings74700.514693664Scranton-WilkesBarre YankeesNorth88560.6117156Syracuse ChiefsCharlotte KnightsDurham BullsNorfolk TidesRichmond BravesColumbus ClippersIndianapolis IndiansNorth69720.4895753450869866276South65780.455South74700.514South64780.451SouthWest63890.414446369730.4867777After reading these instructions delete all text in this shaded area.West68760.4728510Louisville BatsWest90560.6169127Use the XLMiner Analysis ToolPak to conduct your Anova: Single Factor analysis.Toledo Mud HensWest75690.5218257After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (H16).Your Anova analysis output should fit into this shaded area.Part bSignificance Level (Alpha)0.05FormulaCritical t-value#N/AFisher's LSD Procedure:Conclusion(Enter "Significant difference" or"No significant difference"Absolute ValueLSDAbsolute ValueLSDConclusionNorth-South =ABS(H4-14)North-West =ABS(H4-J4)#N/A#N/ANorth-South2158.58700.92#N/ANorth-West#N/A

Question

Trying to find the LSD's VideoThe International League of Triple-A minor league baseball consists of 14 teams organized into three divisions: North, South, and West. The data showing the average attendance for the 14 teams in the International Leagueare contained in the Excel Online file below. Also shown are the teams' records; W denotes the number of games won, L denotes the number of games lost, and PCT is the proportion of games played that were won.Construct a spreadsheet to answer the following questions.Open spreadsheeta. Use a = .05 to test for any difference in the mean attendance for the three divisions.Calculate the value of the F-statistic (to 2 decimals).6.91The p-value is 0.011O (to 4 decimals).What is your conclusion?There is sufficientVO evidence to conclude that the mean attendance values are not the same across the three divisions of the International League of Triple-A minor league baseball.b. Use Fisher's LSD procedure to test whether there is a significant difference between the means for North (1), South (2), and West (3). Use a = .05.Absolute Value(to 2 decimals)LSD(to 2 decimals)DifferenceConclusion2158.58 O1630.01Significant difference700.921630.01No significant difference vT2 – T32859.50 O2075.52 XSignificant differenceCheck My WorkReset Problem DEGH.MPRTTeam NameDivisionL.PCTAttendancePart a. Rearrange the Attendance values for the Anova: Single-Factor AnalysisBuffalo BisonsNorth66770.46288260.3820.594Lehigh Valley IronPigsNorth55898506NorthSouthWestNorthNorthPawtucket Red Sox855891247716.835558.258417.75Rochester Red Wings74700.514693664Scranton-WilkesBarre YankeesNorth88560.6117156Syracuse ChiefsCharlotte KnightsDurham BullsNorfolk TidesRichmond BravesColumbus ClippersIndianapolis IndiansNorth69720.4895753450869866276South65780.455South74700.514South64780.451SouthWest63890.414446369730.4867777After reading these instructions delete all text in this shaded area.West68760.4728510Louisville BatsWest90560.6169127Use the XLMiner Analysis ToolPak to conduct your Anova: Single Factor analysis.Toledo Mud HensWest75690.5218257After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (H16).Your Anova analysis output should fit into this shaded area.Part bSignificance Level (Alpha)0.05FormulaCritical t-value#N/AFisher's LSD Procedure:Conclusion(Enter &#34;Significant difference&#34; or&#34;No significant difference&#34;Absolute ValueLSDAbsolute ValueLSDConclusionNorth-South =ABS(H4-14)North-West =ABS(H4-J4)#N/A#N/ANorth-South2158.58700.92#N/ANorth-West#N/A

Accepted Answer

Given information:
The data represents the attendance of 3 divisions (North, South and West).