Nt1310 Unit 4

1. Using filter, I found out the minimum number of defects by batch was zero, and the maximum number of defects by batch was twenty-three. Therefore, we can say that the number of defects that are more than ten are major problems and should be flagged. I chose ten as the number to base it on because when you compare the number of defects to the batch size (500, 1000, 5000 and10000) anything less than ten is rather small and is to be expected. Conditional formatting was used to highlight all defects which were greater than ten.

Using the data above, which includes only the information for batches that had greater than ten defects, I created a pivot table to summarize how many defects were produced from each machine. It shows that machines six and seven produced the most defects, which were greater than ten.

I created another pivot table comparing the total count of defects, including the defects from one to ten, that each machine produced. Machine six and seven still produced the most instances of defects when compared to the other machines.

Although I’ve assumed that machine six and seven are contributing to the increase
This showed that although employee 2222 had the most defects, machines six and seven had consistently produced defects for each employee. Employee 5555 produced the most defects using machine seven, and employee 2222 produced the most defects using machine six.

Therefore, I can’t say with certainty that a specific employee is responsible for the defects being produced. I noticed that machine six and seven are being used the most by employees. Perhaps it is time to take these machines out of production to be serviced. I suggest that machine six and seven be removed from the line, and have employees work with machines five and eight. During this time, machines six and seven should be repaired. This will help to reduce the amount of defects being produced and should increase