The superintendent of the Red Clay School District is concerned about the sick time taken by teachers and administrators.

More specifically, she would like to know if there is a difference in the number of hours of sick time taken when comparing the days of the week. To investigate this, seven random weeks were selected during the school year, and the total “sick hours” taken by all employees each day were recorded. The hours are shown in the following table and can be found in the file sick hours.xlsx.

Week Mon Tues Wed Thurs Fri 1 17 29 24 19 24 2 23 24 18 23 27 3 26 22 22 22 30 4 22 26 20 27 32 5 30 28 21 20 33 6 36 17 21 22 32 7 21 22 21 21 25

a. Using a = 0.05, does there appear to be a difference in the number of sick hours taken during the days of the week?

b. Was blocking effective? Why or why not?

c. If warranted, determine which pairs of days were different using a = 0.05.

d. What might account for some of these differences?

e. Verify your results with Excel.

AppendixLO1