X AutoSave Off A Assignment 10-TK test and review- due Dec04-2022.xlsx V Search (Alt+Q) File Home Insert Draw Page Layout Formulas Data Review View Help Calibri 11 ~ A" A Number Conditional Formatting Paste % 9 B Format as Table I UV v E 00 .00 Cell Styles Undo Clipboard Font Alignment Number Styles B21 v : X V fx =(B16+C16+D16+E16)/4 FLU VACCINE CI COVID-VACCINE 1 COVID-VACCINE 2 COVID-VACCINE 3 G M N 17.3 16.4 22 3 11.8 13.8 12.4 17.5 14.1 15.4 15.2 21.3 7.5 24.9 19.2 16.4 Anova: Single Factor 12.9 11.3 16.3 24.1 9.8 12.9 13.8 Anova: Single Factor 24.4 12.7 7.4 9.3 23.7 9.3 SUMMARY 154 18.6 20.4 13.5 STUNTS 12.6 12.8 12 140.1 19.5 FLUVACCINE CONTROL Average Variance 1429 1121 COVID-VACCINE 1 140.1 1 8.43656556 sum 13 214.4 142.9 14.29 8.68322222 mean 14.29 21.44 14 standard deviation 2.90 SOVID-VACCINE 2 2.95 2.99 2.86 214.4 21.44 8.94044444 15 variance 8 44 8.68 8.94 8.16 COVID-VACCINE 3 11.71 8.15655556 variance [ valu 8 94 0 16 17 ANOVA Factor levels Sowee of Variation MyS Between Groups 532.5627 177.52 20.7524996 5.587515-08 2.8663 20 n Within Groups 21 s'2_pooled = MS 36 8.5542 I[ average variances pooled or MS ) 22 n. 23 [ equal # of groups ) Total 840.51375 39 Q ( upper critical value from equals c ( c-1) / 2 , 50 =4 x 3 / 2 = studentized table Range ) ( 4 top. 36 side ] 27 12/2 =? comparisons (below ) Tukey-Kramer Procedure Num df ( total # of group ) = ' Den df ( total n - # of groups ) 36 Comparison ( all possible pairs )[ Group Absolute Difference Critical Range Results if Abs Difference is > Critical Range, there is a sig difference between these two groups. step 2 subtract sample means of each group ( abs function for pos #'s ) step 3 use studentized Range Table for Qu value step 4 Qu value : square root of s*2 (pooled]in. = critical range YOUR DATA - Assign 10 a Tukey-Kramer Test Example Studentized range of Qu values + Ready Ex Accessibility: Investigate Type here to search O L W