A human resources director wants to determine

6. A human resources director wants to determine if here is a dependence between day of the week and the number of times employees took sick leave on that day. Sick leave attachment below.
Test H0: Monday = Tuesday = Wednesday = Thursday = Friday = Saturday. Keep your file open for the following 3 questions.
A. .81
B. .80
C. .82
D. .83
*Hint A preference for a day to take sick leave will be indicated by dependence.
7. Continuing, determine the critical value at the significance level of .05 using one of
-Table Chi Square Table
- = CHISQ.INV.RT
- = CHISQ.INV
- =CHIINV() to find the critical value.
The critical value is:
A. 11.070
B. 12.592
C. 1.145
D. 1.635
8. Continuing, find the pvalue using the chi square statistic in a) and one of the EXCEL function CHISQ. DIST.RT, =CHISQ.DIST, or =CHIDIST().
The pvalue is:
A. 0.977
B. 0.023
C. 0.992
D. 0.936
*Hint: You can check your results by comparing the results of multiple methods
9. Comparing the chi square statistic in a) to the critical value b), or the pvalue in c) to ?, is it indicated that employees have a tendency to use Monday as a sick day?
A. True
B. False
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday ? Days
Sick
12
9
11
10
9
9

-
Rating:
5/
Solution: A human resources director wants to determine