The height of your workstation desk is one of the essential criteria for creating the perfect ergonomic workspace, whether at home or in your office. A company's plant manager is currently considering two designs of ergonomic computer desks for their employees. An experiment is performed to help with the purchasing decision. 42 randomly selected employees used the design A computer desk for a week. They used the design B computer desk for the following week. On a 15point scale, their comfort level was recorded in the EXCEL file ComputerDesk.xlsx. Use EXCEL and an appropriate hypothesis test to help the plant manager to answer the following research question. Research Question: Are the comfort levels of the two designs (design A and design B) different? Figure 1: Design A Histogram Figure 2: Design B Histogram Frequency Frequency LO 9 10 11 10 11 Comfort Level Ratings Comfort Level Ratings Figure 3: Histogram of Differences (A-B) Figure 4: Boxplots of Comfort Level ratings Comfort Level Ratings Frequency CO LO o -2 N Design A Design B Comfort Level Ratings Answer the following questions by choosing the most correct option or typing the answer:Answer the following questions by choosing the most correct option or typing the answer: 1. {1 mark) The most appropriate test for these data is: c 2. {1 mark) Which graphical display would be useful to check normality assumption for this hypothesis? A v Figure 1 Figure 2 Figure 3 Figure4 Figure 1 81 2 Figure 3 8L 4 . No need to check normality assumption IOTWPOFP .All four figures are needed LU . {1 mark) How can you check the assumption of equal variances? 0 . Comparative boxplots could be used (e.g. if the sizes of boxes are similar or not) Descriptive statistics such as variance, standard deviation and range could be used Descriptive statistics such as mean and median could be used . The histogram of differences could be used Both A 8: B could be used .'I'IF'IUOPUP No need to check the assumption of equal variances For the remaining questions you may assume that any relevant assumptions have been met. 4. {2 marks} The absolute 1liralue of the test statistic is equal to {3dp} 5. {1 mark) The degrees of freedom is equal to (Integer) 6. {1 mark) The pvalue is larger than 0.05 7. {2 marks} The test shows that the comfort level ratings were A. significantly different between design A and design B, possibly greater for design A. B. significantly different between design A and design B, possibly greater for design B. C. not significantly different between the two design of the computer desks. 0