Question: Excel Online Tutorial 2 laffic controllers resulted in proposals for modciation and redesign of the controllers' workstation. After consideration of several designs forthe workstation, three

 Excel Online Tutorial 2 laffic controllers resulted in proposals for modciation

Excel Online Tutorial 2 laffic controllers resulted in proposals for modciation and redesign of the controllers' workstation. After consideration of several designs forthe workstation, three specific alternatives are selected as having the best potential for reducing controller stress. The key question is: To I.vhat 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 le below. Use at = 0.01 to test for any significant differences. 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 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 32.45 (3 5 6 6.488 '3 3.33r {3 Blocks 16.?? (>3 2 (3 8.38 (3 Error 19.22 (:4) 10 (Q3) 1.92 (g Total 68.44 (:9 1? (9 Calculate the value of the test statistic (to 2 decimals]. 4.36 (:2) Calculate the critical value [to 2 decimals]. 2.92 8 Calculate the p-yalue {to 4 decimals). 0.0434 (:2)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!