1. Open an EXCEL document. Complete a Pareto Table and graph. Remember to identify your charts/graphs- Main Titles, X-Axis and Y-Axis. 2. Choose the top two defects from your Pareto analysis. For each one of these, produce a run (line) chart. Have the x axis with the days of the month, and the y axis with the number of times that defect occured. This will give you information about the occurance of each of those two defects.

Glass Latch 1 January Quality Data Date Colour Edge Label 2 1 1 1 3 3 1 4 2 2 2 5 4 4 6 Glue Trim Scratch 2 1 3 2 2 2 2 2 3 2 2 DN AN N N 2 1 2 2 9 10 2 1 11 12 1 2 Nmmmm 1 13 2 1 2 2 WN 4 2. 16 17 18 19 -m 1 1 4 2 3 2 1 1 20 23 2 1 1 4 1 1 1 1 24 25 N 1 3 2 26 1 2 2 1 3 27 N 1 2 1 2 2