Question: What formulas and method should I use on excel to answer this 2. Do employees' absentee rates differ across the five days of the workweek
What formulas and method should I use on excel to answer this

2. Do employees' absentee rates differ across the five days of the workweek (Monday through Friday)? To answer this question, an econometrician randomly selected nine weeks and the absentee rate (percentage worker absent) was determined for each day (Monday to Friday). The data are as follows Week Monday Absentee rate Tuesday 5.3 Wednesday 0.6 Thursday 1.9 Friday UI AWN 12.9 1.3 9.4 1.6 0.8 2.6 0.4 0.8 5.7 0.5 2.6 0.4 0.0 23.5 4.5 1.4 -JO 9.6 10.2 9.1 11.3 4.5 13.6 4.5 14.1 11.5 7.5 4.2 2.1 4.1 9.3 8 9.5 4.2 7.1 4.1 9 4.8 4.5 5.2 9.1 10.0 12.9 6.9 Based on the above information, answer the following questions. 9.0 (a) At the 5% level of significance, was blocking effective? Follow all the necessary steps and verify your results using Excel/PHStat. (b) Using a 5% level of significance, is there a significance difference in the mean absentee rate of the five workweek? Follow all the necessary steps to perform the test. (c) If your results in (b) indicates that it is appropriate, use the Tukey procedure to determine which groups differ in the mean absentee rate. Use 5% level of significance. Follow all the necessary procedure to perform the test
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
