Please be very detailed using all excel steps TLS Audio Systems Sandra Harris is
ID: 3219115 • Letter: P
Question
Please be very detailed using all excel steps
TLS Audio Systems
Sandra Harris is the production manager of TLS Audio Systems, Inc. and she is concerned about the idle time of workers. In particular, she would like to know if there is a difference in the idle minutes for the workers on the day shift and the evening shift. The information in the table is the idle minutes for 5 day shift workers and six evening shift workers from yesterday. (These data are in the file TLS Audio Systems Spring 2017.)
Day Shift
Evening Shift
92
96
103
114
106
104
81
112
99
95
125
Use the Wilcoxon Rank-Sum test to show if there is any difference in the idle time between the two shifts. Do a six-step hypothesis test to be 95% confident in your result and write a memo the Ms. Harris explaining your conclusion.
Day Shift
Evening Shift
92
96
103
114
106
104
81
112
99
95
125
Explanation / Answer
Step 1: H0: There is no significance difference in the idle time between the two shifts
STep 2: H1: There is significance difference in the idle time between the two shifts
Step 3: Let the los be alpha 5%
STep 4:
From the given data, we calculate ranks to the both samples
W = MIn(22,44) = 22
Step 5 : The critical value of W = 18 at 5% los n1 = 5, n2 = 6 from Wilcoxon Rank-Sum Table
Step 6: Here W > Critical W, we accept the null hypothesis.
thus,we conclude that There is no significance difference in the idle time between the two shifts
Day Shift Evening Shift R1 R2 1 92 96 2 4 2 103 114 6 10 3 106 104 8 7 4 81 112 1 9 5 99 95 5 3 6 125 11 Total: 22 44