The company tested six training programs to determine which was the most effective.Employees were selected at random without replacement to participatein one of the six programs.Each employee took a pretest to establish theirindividual baselines. They took a post-test to measure the amount of improvement resulting from the training.The increase in test scores for each employee in each training program is provided below.
Use Excel to perform a one-factor ANOVA at alpha = .05 and Tukey's HSD test if appropriate. Fill in all the blanks in the tables below. Round each of your entries to exactly 4 decimal places (Do NOT use any rounded numbers in any calculations). Do not include any leading zeros. If the HSD test was not appropriate, enter N/A or n/a in each of the cells for the HSD test values. Single-Factor ANOVA Groups Count Sum Average Variance A B C D E F ANOVA Source of SS df MS F P-Value Fcrit Variation Between Groups Within Groups Total T critical=10 Widgets International, Inc. 11 Customer Service Training Program Results Data 12 Average Increase is Customer Service Rating n = 46 13 Training Program 14 Obs A B C D E F 15 1 7.1450 6.4321 4.5026 8.9833 6.3725 6.4019 16 2 1.3366 5.2028 6.9098 8.0757 6.3634 1.9490 17 3 4.0803 4.6213 6.8365 0.7171 0.0949 0.5877 18 4 4.3484 1.8253 3.7284 2.3644 5.2921 7.4361 19 5 1.1525 3.9304 2.4960 0.9290 1.8146 4.0535 20 6 0.2731 1.2253 2.1237 5.0272 4.6281 6.1355 21 7 1.4849 5.2480 6.6369 8.7305 3.4578 4.5758 22 8 7.2752 2.7862 1.0293 7.4286 2.7076 3.7281 23 9 5.4633 2.6642 1.8807 3.9928 6.1821 3.9533 24 6.3326 1.9752 3.5546 6.1988 0.7700 3.0514 25 11 1.0040 5.7828 6.4243 7.8104 3.8212 4.3959 26 12 4.2202 2.9171 2.9303 4.9774 4.1450 4.1039 27 13 6.1987 6.1147 6.0316 8.9232 6.5704 0.3352 28 14 1.5221 2.6455 3.4742 3.1576 6.4422 4.5611 29 15 4.5605 2.0377 3.7563 1.7535 6.1780 7.5924 30 16 2.8473 5.5399 6.0719 3.2452 2.7325 1.5382 31 17 3.5988 5.4419 0.6825 9.2944 0.4750 4.4376 32 18 1.9623 5.1547 5.2447 6.4369 0.7099 3.0593 33 19 6.7068 1.7154 5.5777 5.3976 1.6988 5.9421 34 20 2.6413 1.7130 6.2779 7.8438 4.6146 4.4621 35 21 3.9885 3.8901 4.1009 3.1931 5.9337 5.6430 36 22 6.4021 4.9273 4.2732 8.0956 5.9684 3.5661 37 23 0.3522 4.3613 4.2195 0.2441 2.5651 6.7090 38 24 7.2324 3.6012 2.1456 0.1281 6.9894 7.0096 39 25 1.3643 6.7352 5.5884 8.8700 1.0318 6.2338 40 26 6.3161 3.7710 5.9975 6.5012 2.5090 3.6379 41 27 2.9682 6.1903 5.3841 2.7765 7.2036 2.2047 42 28 0.0164 3.6750 7.0451 2.0978 0.9431 5.6073 43 29 6.5905 1.9986 1.6737 9.3028 4.1861 2.3790 44 0.0175 0.1789 0.6224 3.8610 0.1682 2.9750 45 31 3.2130 5.5492 0.4153 3.2652 6.1234 1.1909 46 32 4.2769 1.2104 0.2673 8.3340 6.7197 6.2645 47 33 1.6800 2.7695 0.6853 5.0737 0.8708 1.5349 48 34 6.9260 1.3376 5.4123 1.5086 0.2630 4.2725 49 35 1.2882 4.4639 2.4377 8.3885 0.2734 1.5083 50 36 3.5897 2.1637 5.5163 8.1211 6.3764 5.7276 51 37 4.2754 0.9823 1.2939 7.5690 7.4843 6.7420 52 38 4.1063 0.5348 2.2081 3.2506 2.5664 4.4191 53 39 6.0611 6.2423 4.7750 7.2144 0.1785 4.6576 54 40 2.8483 4.8520 2.7964 5.9497 2.3291 7.0392 55 41 5.1359 1.9667 6.2175 1.0315 5.6966 3.6553 56 42 1.8630 1.0681 4.1710 4.0615 3.4927 3.4692 57 43 3.8191 6.4647 3.8903 6.6731 2.1072 3.6651 58 44 6.1673 4.2724 4.2621 9.0941 4.8017 7.4335 59 45 3.7122 4.1110 4.2114 5.0024 3.7781 4.5122 60 46 3.9998 4.2287 3.9986 4.9588 3.9224 4.3225 61 62 Mean 3.7471 3.6200 3.9082 5.3446 3.6859 4.3191
