Umbrella handles data

At an umbrella manufacturing facility, umbrella handles are measured and then removed from the assembly line if they don't meet specifications. A daily report indicates how many rejected handles were produced by each of three presses at the facility during each of three shifts. A quality engineer wants to determine whether press and shift are associated.

You can use this data to demonstrate Chi-Square Test for Association, Cross Tabulation and Chi-Square, Bar Chart of Values from a table, and other commands that analyze summary data in a two-way table.

Worksheet column Description
Machine ID The machine identification number: 1, 2, or 3
1st shift The number of rejected handles during the first shift by machine
2nd shift The number of rejected handles during the second shift by machine
3rd shift The number of rejected handles during the third shift by machine