Question: Video Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of


Video Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak A study measuring the fatigue of air traffic controllers resulted in proposals for modficiation 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 a = 0.05 to test for any significant differences. X Open spreadsheet 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 24.11 0 2 0 12.06 5.51 Blocks 42.28 5 0 8.46 0 Error 21.89 10 2.19 0 Total 88.28 17 0 Calculate the value of the test statistic (to 2 decimals). 5.51 Calculate the critical value (to 2 decimals). 2.33 X Calculate the p-value (to 4 decimals). 0.0244 Reject null hypothesis? Yes What is your conclusion? The population mean stress levels differ for the three workstation alternatives
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
