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 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). 7.06 The p-value is .0109 (to 4 decimals). What is your conclusion? There is sufficient v 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 - 12 2156.83 -3.31 X Significant difference I1 - C3 724.92 No significant difference v 2 - C3 2881.75 Significant difference Check My Work Reset ProblemA B C D E F G Team Name Division W L PCT Attendance Buffalo Bisons North 66 77 0.462 8792 Lehigh Valley IronPigs North 55 89 0.382 8488 Pawtucket Red Sox North 85 58 0.594 9115 5 Rochester Red Wings North 72 70 0.507 6935 Scranton-Wilkes 6 Barre Yankees North 88 56 0.611 7168 Syracuse Chiefs North 69 74 0.483 5764 8 Charlotte Knights South 64 78 0.451 4503 g Durham Bulls South 74 70 0.514 6980 10 Norfolk Tides South 64 78 0.451 6265 11 Richmond Braves South 63 84 0.429 4466 12 Columbus Clippers West 69 73 0.486 7798 13 Indianapolis Indians West 68 76 0.472 8551 4 Louisville Bats West 86 56 0.606 9179 15 Toledo Mud Hens West 75 69 0.521 8213 16 17