..............

QUESTION 1 Open the Excel file at this link Module 12 Quiz Data.xIsx 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 4 ANOVA Source of Variation SS of MS P-Value Fcrit Between Groups Within Groups Total T critical= T calc for each pair Significant Test (Yes or No) B VS A C VS A D VS A E vS A F VS A C VS B D vs B E vs B F VS B D vs C E vs C F vs C E vS D F VS D F VS EQUESTION 2 Based on the information contained in the spreadsheet provided for question 1, as well as the one-factor ANOVA you performed using Excel, and the Tukey's HSD test, if you performed one, what seems to be the correct decision for Widgets International to make regarding the six training programs? Select the best answer. No decision is supported by the data That training program D should be characterized as probably the single best of the options That the ANOVA was not significant That the Tukey's HSD test was not necessary That training program A was probably more effective than training programs B and E That training program F was probably more effective than training program BThe company tested six training programs to determine which was the most effective. Employees were selected at random without replacement to participate in one of the six programs. Each employee took a pretest to establish their individual 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. Widgets International, Inc. Customer Service Training Program Results Data Average Increase is Customer Service Rating n = 46 Training Program Obs A B C D E F 1 7.1450 6.4321 4.5026 8.9833 6.3725 6.4019 1.3366 5.2028 6.9098 8.0757 6.3634 1.9490 3 4.0803 4.6213 6.8365 0.7171 0.0949 0.5877 4 4.3484 1.8253 3.7284 2.3644 5.2921 7.4361 5 1.1525 3.9304 2.4960 0.9290 1.8146 4.0535 6 0.2731 1.2253 2.1237 5.0272 4.6281 6.1355 7 1.4849 5.2480 6.6369 8.7305 3.4578 4.5758 8 7.2752 2.7862 1.0293 7.4286 2.7076 3.7281 9 5.4633 2.6642 1.8807 3.9928 6.1821 3.9533 10 6.3326 1.9752 3.5546 6. 1988 0.7700 3.0514 11 1.0040 5.7828 6.4243 7.8104 3.8212 4.3959 12 4.2202 2.9171 2.9303 4.9774 4.1450 4.1039 13 6.1987 6.1147 6.0316 8.9232 6.5704 0.3352 14 1.5221 2.6455 3.4742 3.1576 6.4422 4.5611 15 4.5605 2.0377 3.7563 1.7535 6.1780 7.5924 16 2.8473 5.5399 6.0719 3.2452 2.7325 1.5382 17 3.5988 5.4419 0.6825 9.2944 0.4750 4.4376 18 1.9623 5.1547 5.2447 6.4369 0.7099 3.0593 19 6.7068 1.7154 5.5777 5.3976 1.6988 5.9421 20 2.6413 1.7130 6.2779 7.8438 4.6146 4.4621 21 3.9885 3.8901 4.1009 3.1931 5.9337 5.6430 22 6.4021 4.9273 4.2732 8.0956 5.9684 3.5661 23 0.3522 4.3613 4.2195 0.2441 2.5651 6.7090 24 7.2324 3.6012 2.1456 0. 1281 6.9894 7.0096 25 1.3643 6.7352 5.5884 8.8700 1.0318 6.2338 26 6.3161 3.7710 5.9975 6.5012 2.5090 3.6379 27 2.9682 6.1903 5.3841 2.7765 7.2036 2.2047 28 0.0164 3.6750 7.0451 2.0978 0.9431 5.6073 29 6.5905 1.9986 1.6737 9.3028 4.1861 2.3790 30 0.0175 0.1789 0.6224 3.8610 0.1682 2.9750 31 3.2130 5.5492 0.4153 3.2652 6.1234 1.1909 32 4.2769 1.2104 0.2673 8.3340 6.7197 6.2645 33 1.6800 2.7695 0.6853 5.0737 0.8708 1.5349 34 6.9260 1.3376 5.4123 1.5086 0.2630 4.2725 35 1.2882 4.4639 2.4377 8.3885 0.2734 1.5083 36 3.5897 2.1637 5.5163 8. 1211 6.3764 5.7276 37 4.2754 0.9823 1.2939 7.5690 7.4843 6.7420 38 4.1063 0.5348 2.2081 3.2506 2.5664 4.4191 39 6.0611 6.2423 4.7750 7.2144 0.1785 4.6576 40 2.8483 4.8520 2.7964 5.9497 2.3291 7.0392 41 5.1359 1.9667 6.2175 1.0315 5.6966 3.6553 42 1.8630 1.0681 4.1710 4.0615 3.4927 3.4692 43 3.8191 6.4647 3.8903 6.6731 2.1072 3.6651 44 6.1673 4.2724 4.2621 9.0941 4.8017 7.4335 45 3.7122 4.1110 4.2114 5.0024 3.7781 4.5122 46 3.9998 4.2287 3.9986 4.9588 3.9224 4.3225 Mean 3.7471 3.6200 3.9082 5.3446 3.6859 4.3191