A human resources director wants to find
Please upload answer in an excel document.Chi Square:A human resources director wants to find out if there is a relationship with the day of the week and the number of times employees were sick on that day. She tallied the number of times 60 employees were absent on these days:Monday: 12Tuesday: 9Wednesday: 11Thursday: 10Friday: 9Saturday: 9Using a significance level of .05 and the Excel function, =chiinv(), find the critical value.a. What is the chi square value for this scenario?b. Use the answer to “a” and the =chidist() equation in Excel to find the p value.c. Is there a relationship between the days of the week and the number of employees who are sick on that day?