Paint flaws data

A quality engineer for an automotive supply company wants to decrease the number of car door panels that are rejected because of paint flaws. The engineer wants to determine whether a relationship exists between the type of paint flaws and the shift during which the door panels are made.

You can use this data to demonstrate Bar Chart of Counts of unique values, Pie Chart, Pareto Chart, and other commands that analyze columns of categorical data where each row represents a single observation.

Worksheet column Description
Flaws The type of paint flaw: Scratch, Peel, Smudge, or Other. Each row represents a single observation.
Shift The shift in which the paint flaw occurred: Day, Evening, Night, or Weekend.