Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

The appropriate critical value (Tcritical) is

The test value (Tcalc) for C vs B is

Was the test for C vs B significant?

image text in transcribed \begin{tabular}{|c|c|c|c|c|c|c|} \hline & \multicolumn{6}{|c|}{ Training Program } \\ \hline Obs & A & B & C & D & E & F \\ \hline 1 & 7.1450 & 6.4321 & 4.5026 & 8.9833 & 6.3725 & 6.4019 \\ \hline 2 & 1.3366 & 5.2028 & 6.9098 & 8.0757 & 6.3634 & 1.9490 \\ \hline 3 & 4.0803 & 4.6213 & 6.8365 & 0.7171 & 0.0949 & 0.5877 \\ \hline 4 & 4.3484 & 1.8253 & 3.7284 & 2.3644 & 5.2921 & 7.4361 \\ \hline 5 & 1.1525 & 3.9304 & 2.4960 & 0.9290 & 1.8146 & 4.0535 \\ \hline 6 & 0.2731 & 1.2253 & 2.1237 & 5.0272 & 4.6281 & 6.1355 \\ \hline 7 & 1.4849 & 5.2480 & 6.6369 & 8.7305 & 3.4578 & 4.5758 \\ \hline 8 & 7.2752 & 2.7862 & 1.0293 & 7.4286 & 2.7076 & 3.7281 \\ \hline 9 & 5.4633 & 2.6642 & 1.8807 & 3.9928 & 6.1821 & 3.9533 \\ \hline 10 & 6.3326 & 1.9752 & 3.5546 & 6.1988 & 0.7700 & 3.0514 \\ \hline 11 & 1.0040 & 5.7828 & 6.4243 & 7.8104 & 3.8212 & 4.3959 \\ \hline 12 & 4.2202 & 2.9171 & 2.9303 & 4.9774 & 4.1450 & 4.1039 \\ \hline 13 & 6.1987 & 6.1147 & 6.0316 & 8.9232 & 6.5704 & 0.3352 \\ \hline 14 & 1.5221 & 2.6455 & 3.4742 & 3.1576 & 6.4422 & 4.5611 \\ \hline 15 & 4.5605 & 2.0377 & 3.7563 & 1.7535 & 6.1780 & 7.5924 \\ \hline 16 & 2.8473 & 5.5399 & 6.0719 & 3.2452 & 2.7325 & 1.5382 \\ \hline 17 & 3.5988 & 5.4419 & 0.6825 & 9.2944 & 0.4750 & 4.4376 \\ \hline 18 & 1.9623 & 5.1547 & 5.2447 & 6.4369 & 0.7099 & 3.0593 \\ \hline 19 & 6.7068 & 1.7154 & 5.5777 & 5.3976 & 1.6988 & 5.9421 \\ \hline 20 & 2.6413 & 1.7130 & 6.2779 & 7.8438 & 4.6146 & 4.4621 \\ \hline 21 & 3.9885 & 3.8901 & 4.1009 & 3.1931 & 5.9337 & 5.6430 \\ \hline 22 & 6.4021 & 4.9273 & 4.2732 & 8.0956 & 5.9684 & 3.5661 \\ \hline 23 & 0.3522 & 4.3613 & 4.2195 & 0.2441 & 2.5651 & 6.7090 \\ \hline 24 & 7.2324 & 3.6012 & 2.1456 & 0.1281 & 6.9894 & 7.0096 \\ \hline 25 & 1.3643 & 6.7352 & 5.5884 & 8.8700 & 1.0318 & 6.2338 \\ \hline 26 & 6.3161 & 3.7710 & 5.9975 & 6.5012 & 2.5090 & 3.6379 \\ \hline 27 & 2.9682 & 6.1903 & 5.3841 & 2.7765 & 7.2036 & 2.2047 \\ \hline 28 & 0.0164 & 3.6750 & 7.0451 & 2.0978 & 0.9431 & 5.6073 \\ \hline 29 & 6.5905 & 1.9986 & 1.6737 & 9.3028 & 4.1861 & 2.3790 \\ \hline 30 & 0.0175 & 0.1789 & 0.6224 & 3.8610 & 0.1682 & 2.9750 \\ \hline 31 & 3.2130 & 5.5492 & 0.4153 & 3.2652 & 6.1234 & 1.1909 \\ \hline 32 & 4.2769 & 1.2104 & 0.2673 & 8.3340 & 6.7197 & 6.2645 \\ \hline 33 & 1.6800 & 2.7695 & 0.6853 & 5.0737 & 0.8708 & 1.5349 \\ \hline 34 & 6.9260 & 1.3376 & 5.4123 & 1.5086 & 0.2630 & 4.2725 \\ \hline 35 & 1.2882 & 4.4639 & 2.4377 & 8.3885 & 0.2734 & 1.5083 \\ \hline 36 & 3.5897 & 2.1637 & 5.5163 & 8.1211 & 6.3764 & 5.7276 \\ \hline 37 & 4.2754 & 0.9823 & 1.2939 & 7.5690 & 7.4843 & 6.7420 \\ \hline 38 & 4.1063 & 0.5348 & 2.2081 & 3.2506 & 2.5664 & 4.4191 \\ \hline 39 & 6.0611 & 6.2423 & 4.7750 & 7.2144 & 0.1785 & 4.6576 \\ \hline 40 & 2.8483 & 4.8520 & 2.7964 & 5.9497 & 2.3291 & 7.0392 \\ \hline 41 & 5.1359 & 1.9667 & 6.2175 & 1.0315 & 5.6966 & 3.6553 \\ \hline 42 & 1.8630 & 1.0681 & 4.1710 & 4.0615 & 3.4927 & 3.4692 \\ \hline 43 & 3.8191 & 6.4647 & 3.8903 & 6.6731 & 2.1072 & 3.6651 \\ \hline 44 & 6.1673 & 4.2724 & 4.2621 & 9.0941 & 4.8017 & 7.4335 \\ \hline 45 & 3.7122 & 4.1110 & 4.2114 & 5.0024 & 3.7781 & 4.5122 \\ \hline 46 & 3.9998 & 4.2287 & 3.9986 & 4.9588 & 3.9224 & 4.3225 \\ \hline Mean & 3.7471 & 3.6200 & 3.9082 & 5.3446 & 3.6859 & 4.3191 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Financial Risk Management Enterprise Wide Risk Management In Theory And Practice

Authors: Donald Van Deventer, Kenji Imai, Mark Mesler

3rd Edition

1547416157, 9781547416158

More Books

Students also viewed these Finance questions