A study measuring the fatigue of air traffic controllers resulted in proposals for modification and redesign of the controllers' workstation. After consideration of several designs for the workstation, three specific alternatives are selected as having the best potential for reducing controller stress. The key question is: To what extent do the three alternatives differ in terms of their effect on controller stress? A randomized block design is used to test the hypothesis of no difference in stress levels for the three workstation alternatives. The data for the experiment is located in the Microsoft Excel Online file below. Use ? = 0.1 to test for any significant differences. System A System B System C Controller 1 15 15 19 Controller 2 14 15 15 Controller 3 11 11 15 Controller 4 13 13 17 Controller 5 16 14 17 Controller 6 13 13 14 Set up the ANOVA table for this problem. Show the entries to 2 decimals, if necessary. Source of Variation Sum of Squares Degrees of Freedom Mean Square F Treatments X x X X Blocks x X x Error 11.22 10 1.12 Total 70.44 17 Calculate the value of the test statistic (to 2 decimals)= 11.93 Calculate the critical value (to 2 decimals)_________x XX Help with critical value and areas marked with X please.
Please help with areas marked with an X, I got the rest of the data from running Anova which provided me with the information below, but the first few rows were incorrect, not sure what I am doing wrong. Please help
13.4 Excel Activity 1 - ANOVA with XLMiner Analysis ToolPak, Randomized Block Design (Freeform)
A study measuring the fatigue of air traffic controllers resulted in proposals for modification and redesign of the controllers' workstation. After consideration of several designs for the workstation, three specific alternatives are selected as having the best potential for reducing controller stress. The key question is: To what extent do the three alternatives differ in terms of their effect on controller stress?
A randomized block design is used to test the hypothesis of no difference in stress levels for the three workstation alternatives. The data for the experiment is located in the Microsoft Excel Online file below. Use ? = 0.1 to test for any significant differences.
|
System A |
System B |
System C |
Controller 1 |
15 |
15 |
19 |
Controller 2 |
14 |
15 |
15 |
Controller 3 |
11 |
11 |
15 |
Controller 4 |
13 |
13 |
17 |
Controller 5 |
16 |
14 |
17 |
Controller 6 |
13 |
13 |
14 |
Set up the ANOVA table for this problem. Show the entries to 2 decimals, if necessary.
Source of Variation |
Sum of Squares |
Degrees of Freedom |
Mean Square |
F |
Treatments |
X |
x |
X |
X |
Blocks |
x |
X |
x |
|
Error |
11.22 |
10 |
1.12 |
|
Total |
70.44 |
17 |
|
|
Calculate the value of the test statistic (to 2 decimals)= 11.93
Calculate the critical value (to 2 decimals)_________x
XX Help with critical value and areas marked with X please.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images