Question

Undo Clipboard Font Alignm H1 f Part a. Rearrange the Attendance values for the Anova: Single-Factor A A E 1 Team Name Buffalo Bisons Lehigh Valley IronPigs Pawtucket Red Sox Rochester Red Wings Scranton-Wilkes 6 Division North PCT Attendance Part a. Rea 2 66 0.462 8804 8453 9091 3 North 55 0.382 4 North 0.594 5 North 0.533 6893 Barre Yankees Syracuse Chiefs Charlotte Knights Durham Bulls 10 Norfolk Tides Richmond Braves Columbus Clippers 13 Indianapolis Indians 14 Louisville Bats Toledo Mud Hens 0.611 7172 North North 69 0.469 0.466 5777 7 4547 6992 6276 4438 South South South South 74 70 0.514 0.451 0.417 0.486 0.472 0.6 0.521 64 11 After reading 7818 69 73 West 12 8549 9178 8220 West Use the XLMI West West 75 15 After deleting 16 17 Your Anova an 18 19 20 21 OL7837 6988 8 88889 W8388 8882838881 Merge & Center $-% . Conditional Format Insert Delete Format Formatting as Table Alignment Number Tables Cells Anova: Single-Factor Analysis K M dance Part a. Rearrange the Atter dance values for the Anova: Single-Factor Analysis 04 53 91 893 North South West 172 5777 4547 6992 6276 4438 After reading these instructions delete all text in this shaded area. 7818 8549 9178 8220 Use the XLMiner Analysis ToolPak to conduct your Anova: Single Factor a 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 0.05 Significance Level (Alpha) Critical 1-value Fisber's LSD Procedure Clipboard Font Alignment fPart a. Rearrange the Attendance values for the Anova: Single-Factor Analysis H K Part b Significance Level (Alpha) 0.05 Critical t-value Fisher's LSD Procedure Conclusion Absolute Value LSD (Enter "Significant difference" or No sianificant.difference 7 North-South 8 North-West 39 South-West 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 Data Saved to Cengage $19-5340-GP%620P..pdf AutoSum Insert Delete Format Clear Merge&Center $-% Conditional Fomat Formatting as Table Sort &Find & Fiter Select Alignment Number Tables Cells Editing gle-Factor Analysis S T L Formula #N/A Conclusion Absolute Value LSD #NIA ANIA #NA #NIA #NIA North-South #NIA #NIA NIA North-West #NIA South-West e structured Activity 2 Q seach th Video Excel Online DATAfle Activity: Triple-A The International League of Triple-A minor league baseball consists of 14 teams organized into three divisions: North, South, and est. The data showing the averae atendance for the 14 t contained in the Excel Online file below, Al spreadsheet to answer the following quecae n are the teams recards w denotes the mumber of games wor, L denctes the unber of games lest, and PCT the proportion of gmes plent Cant stions in the Intemational League ar Open spreadshee a. Use a 05 to test for any difference in the mean attendance for the theree divisions Calculate the value of the F-statistic (to 2 decimals) The p-value is (to 4 decimals) What is your condlusionh or ag a There is ucent evidence to condude that the mean attendance values are not the same across the three divisions of the Intmanal Laeof riple b. Use Fisherh LSD procedure to test whether there is a significant dfference between the eans for North () Seth (3), and Wetr (Us 0 Absolute Value (to 2 dedimals) LSD (to 2 decimals) Conclasion pifference Snticant dference No sgnicant diterence igndcant erence - Reset Proble Check My Works Aset at P mentecoe. 12 pts (33 33% ) 426447 40000 Back

Answer 1

Copy General Paste B IU- A Format Painter Merge & Center Chr For Clipboard Font Alignment Number Q16 fr A C H north south west Anova: Single Factor 2 8804 4547 7818 3 8453 6992 8549 SUMMARY 4 9091 6276 9178 Groups Count Sum Average Variance 6893 4438 8220 north 46190 7693.333 1669730 6 7172 south 4 22253 5563.25 1616097 5777 8441.25 33060o.9 west 4 33765 10 ANOVA 1 12 13 Source of Vaia Between 18227021 Within Grc 14188745 SS df 2 9113510 7.065362 F P-value 0.01063 3.932298. Fait 11 1239836 14 15 16 17 18 Total 32415765 13

A)F = 7.07

p value = 0.0106

Since p value is less than 0.05 , there is sufficient evidence to say that there is difference in the mean of attendance of three divisions.

B)Fisher LSD = √ MSE (1/n_i+1/n_j)

ta/2

t _cric = 2.593

Reject H₀ if |x_i (bar) -x_j (bar)| > LSD

Difference	Absolute Value	LSD	Conclusion
x1 (bar)- x2 (bar)	2135.08	1901.04	Significant difference
x2 (bar) - x3(bar)	2878	2082.48	Significant difference
x1 (bar) - x3 (bar)	742.92	1901.04	No Significant difference