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. Due to a recent change by Microsoft you will need to open the XLMiner Analysis Tool Pak add-in manually from the home ribbon. Screenshot of ToolPak X 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.86 The p-value is .0116 What is your conclusion? There is sufficient (to 4 decimals). 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 = .05. Absolute Value LSD (to 2 decimals) Difference (to 2 decimals) - 2134.42 1634.38 1-3 735.33 1634.38 2-3 2869.75 1634.38 Conclusion Significant difference No significant difference Significant difference Check My Work Reset Problem D E G Team Name Division W Buffalo Bisons North 66 Lehigh Valley IronPigs North 55 Pawtucket Red Sox North 85 Rochester Red Wings North 71 Scranton-Wilkes Barre Yankees North 88 Syracuse Chiefs North 69 Charlotte Knights South 61 Durham Bulls South 74 Norfolk Tides South 64 Richmond Braves South 63 Columbus Clippers West 69 Indianapolis Indians West 68 Louisville Bats West 87 Toledo Mud Hens West 75 LTP PPPPPLES PCT Attendance Part a. Rearrange the Attendance values for the Anova: Single-Factor Analysis 77 0.462 8808 89 0.382 8456 North South West 58 0.594 9103 8808 4497 7775 70 0.504 6913 8456 7020 8558 56 0.611 7118 9103 6284 9149 74 0.483 5758 6913 4432 8230 78 0.439 4497 7118 70 0.514 7020 5758 78 0.451 6284 78 0.447 4432 73 0.486 7775 Anova: Single Factor 76 0.472 8558 56 0.608 9149 SUMMARY 69 0.521 8230 Groups North South West Count Sum 6 4 4 33712 Average Variance 46156 7692.6667 1699348.7 22233 5558.25 1686038.9 8428 334118 MS F P-value F crit 2 9074365.4 6.8569452 0.0116542 3.982298 11 1323383.1 ANOVA Source of Variation SS df Between Groups Within Groups 18148730.85 14557214.08 Total 32705944.93 13 Part b Significance Level (Alpha) Critical t-value Fisher's LSD Procedure: North-South North-West South-West 0.05 2.2010 Formula |=T.INV.2T(131,J24) Conclusion (Enter "Significant difference" or "No significant difference" 1634.38 Significant Difference 1634.38 No Significant Difference 1634.38 Significant Difference Absolute Value North-South ABS(K16-K17) North-West ABS(K16-K18) South-West ABS(K17-K18) LSD Conclusion =$I$33 * SQRT($K$24 * (1/$I$16 + 1/$I$1 =IF(137>=J37,"Significant Difference", "No Significant Differer =$I$33 * SQRT($K$24 * (1/$I$16 + 1/$I$1]=IF(138>=J38,"Significant Difference","No Significant Differer =$I$33 * SQRT($K$24 * (1/$I$16 + 1/$I$1 =IF(139>=J39,"Significant Difference","No Significant Differer Absolute Value LSD 2134.42 735.33 2869.75