AutoSave OFF @ E. Chapters 10-11 Summer 2021 Homework Home Insert Draw Page Layout Formulas Data Review View XLSTAT Tell me Share 0 Comments NIT Calibri (Body) v 11 == AA X LO V ab Wrap Text General F CE WE ILX AYO Paste BIU a Av A v E Merge & Center $ % ) Insert .00 000 v Delete Format Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select v Analyze Data Yes No B 1 M O o R S T U V w Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? K13 4 x fx A c D E E F G H K L M N 1 11.1A 11.1 Columns C-F contains data on the number of partners in accounting firms in 4 geographical regions: Capital, Great Lakes, 2 Null Hypothesis Mid-Atlantic, and New England. 3 Alternative Hypothesis A) At the .05 level of significance, is there evidence of a difference among the 4 region accounting firms with respect to the mean 4 number of partners? 5 F Statistic Value B) If the results in part A indicate that it is appropriate to do so, use the Tukey-Kramer procedure to determine which regions differ in the mean number of partners 6 F Critical Value Please use a Q value of 3.74 7 Decision State your decision Relative to the Problem Capital Great Mid- New 8 Region Lakes Atlantic England 9 Part B. 13 156 274 31 If you did find a difference in the means which ones were different? Place an 10 X by the ones that were different 14 262 154 16 11 Capital Area and Great Lakes 29 148 172 10 12 Capital Area and Mid-Atlantic 18 61 144 18 13 Capital Area and New England 33 54 109 30 14 Great Lakes and Mid-Atlantic 11 58 90 12 15 Great Lakes and New England 19 57 78 17 16 Mid-Atlantic and New England 10 33 37 15 17 11 27 73 17 18 16 32 54 8 19 21 44 72 20 20 15 27 60 14 21 19 24 36 10 22 21 24 41 9 9 23 20 29 7 24 55 35 8 25 17 38 11 26 23 21 10 27 26 25 28 17 37 29 23 28 30 11 31 16 32 23 33 8 34 8 35 16 36 17 37 15 38 > Hints Ch10 Answers Ch11 Ans. 10.1 10.2 10.3 10.4 11.1 11.2 11.3 Paired Paired Low Paired_Upper Pooled Pooled LOWE + Ready 100%