Avon Products has a 24-hour distribution facility in Newark, Delaware, that fulfills orders for the cosmetic maker’s sales representatives. Orders are filled in one of three distribution lines. Random business days were selected, and the number of orders processed for each line over 4-hour intervals was recorded. The data are as follows and can also be found in the file Avon.xlsx.

Interval Line 1 Line 2 Line 3 7:00 a.m.–11:00 a.m. 1,313 1,254 1,279 11:00 a.m.–3:00 p.m. 1,118 1,093 1,395 3:00 p.m.–7:00 p.m. 1,276 1,227 1,190 7:00 p.m.–11:00 p.m. 1,096 988 1,210 11:00 p.m.–3:00 a.m. 1,050 1,244 1,114 3:00 a.m.–7:00 a.m. 1,239 1,202 1,036

a. Using a = 0.05, does there appear to be a difference in the number of orders processed by the lines?

b. Was blocking effective? Why or why not?

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

d. Verify your results with Excel.

AppendixLO1