I need help analyzing and computing the data found in the attached spreadsheet. 13.2 A1

H1 X V fx B C D E G I J K M N 0 P Q R S T U V W 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 8785 UAWNH Lehigh Valley IronPigs North 55 89 0.38 8505 North South West Pawtucket Red Sox North 58 0.594 9076 Rochester Red Wings North 79 70 0.53 6929 Scranton-Wilkes 6 Barre Yankees North 88 56 0.611 7124 Syracuse Chiefs North 59 78 0.469 5748 Charlotte Knights South 63 78 0.44 4508 9 Durham Bulls South 74 70 0.514 7005 10 Norfolk Tides 78 0.451 6259 11 Richmond Braves South 85 0.426 4461 12 Columbus Clippers West 73 0.486 7793 After reading these instructions delete all text in this shaded area. 13 Indianapolis Indians West 68 76 0.472 8557 14 Louisville Bats West 81 56 0.591 9138 Use the XLMiner Analysis ToolPak to conduct your Anova: Single Factor analysis. 15 Toledo Mud Hens West 75 69 0.521 8253 16 After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (H16). 17 18 Your Anova analysis output should fit into this shaded area. 19 20 21 22 23 24 25 26 27 28 29 Part b 30 Significance Level (Alpha) 0.05 Formula Critical t-value #N/A 35 Fisher's LSD Procedure: Conclusion Absolute Value LSD (Enter "Significant difference" or Absolute Value LSD Conclusion 36 "No significant difference" North-South North-South #N/A #N/A #N/A 38 North-West North-West #N/A #N/A #N/A South-West South-West #N/A #N/A 40 41 42 43 44 45 46 47