Trying to find the LSDs
Video The 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 League are 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. X HILL Open spreadsheet a. 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.91 The p-value is 0.011 (to 4 decimals). What is your conclusion? There is sufficient 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 LSD Difference (to 2 decimals) (to 2 decimals) Conclusion 1 2158.58 0 1630.01 X Significant difference I1 - IS 700.92 1630.01 X No significant difference v I2 - I3 2859.50 2075.52 X Significant difference v Check My Work Reset Problemfx B E G H K M N O P Q R S U C D Team Name Division W L PCT Attendance Part a. Rearrange the Attendance values for the Anova: Single-Factor Analysis Buffalo Bisons North 66 77 0.462 8826 Lehigh Valley IronPigs North 55 89 0.382 8506 North South West Pawtucket Red Sox North 85 58 0.594 912 7716.83 5558.25 8417.75 Rochester Red Wings North 74 70 0.514 6936 6 Scranton-Wilkes Barre Yankees North 38 56 0.611 7156 Syracuse Chiefs North 69 72 0.48 5753 Charlotte Knights South 65 78 0.455 4508 Durham Bulls South 74 70 0.514 6986 Norfolk Tides South 64 78 0.451 6276 Richmond Braves South 63 89 0.414 4463 Columbus Clippers West 69 73 0.48 7777 After reading these instructions delete all text in this shaded area. Indianapolis Indians West 68 76 0.472 8510 Louisville Bats West 90 56 0.616 9127 Use the XLMiner Analysis ToolPak to conduct your Anova: Single Factor analysis. Toledo Mud Hens West 75 69 0.521 8257 After 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 b Significance Level (Alpha) 0.05 Formula Critical t-value #N/A Fisher's LSD Procedure: Conclusion Absolute Value LSD (Enter "Significant difference" or Absolute Value LSD Conclusion "No significant difference" North-South 2158.58 North-South =ABS(H4-14) #N/A #N/A #N/A North-West 700.92 North-West =ABS(H4-J4) #N/A
