Title: Exercise
Course: PW-Course-Import-Test

Module 7

Check Sheet and Pareto Chart Exercise

 | Watch

The following video shows how to construct a Pareto Chart.

 | Practice

After reviewing this video fill out a check sheet and construct a pareto chart in Excel using  bag of m&m
candies. For this exercise you will need a 1.74 oz bag of m&m candies. Open the bag and count total number of candies in it. If you do not have a bag of m&m available then you can use the information in the check sheet below to construct the pareto chart. The m&m bag I bought had a total of 41 candies in it with the different colors listed in the check sheet below.

 | Color | Red | Blue | Green | Yellow | Orange | Brown
Quantity | 8 | 7 | 11 | 9 | 2 | 4

In the video the first two columns are “Expense” and “Amount.” In the m&m exercise these column headings will be replaced by ‘Color’ and ‘Quantity’. Good luck on constructing your first pareto chart.

 | Watch

Root Cause Analysis Exercise

 | Practice

After reviewing this video construct a fishbone diagram on a piece of paper using the scenario below.

You bought a brand new car right after Christmas. The car is midnight black; the color you always wanted your car to be. In the third week of driving the car you notice that the paint on the hood is peeling off. You are not happy about it and call the dealership. On your way to the dealership you and your wife try to figure out what could have happened that caused the paint to peel. Your wife blames it on the black color because she always wanted a red car. What are the other reasons that you can think off that may have caused the paint to peel off?

In this exercise you will create a Cause and Effect Diagram (Fishbone Diagram) which shows relationships between quality characteristics and the possible sources of variation. The six major characteristics reviewed in a fishbone diagram are:

1. Measurement
2. People (Manpower)
3. Environment (Mother Nature)
4. Machines
5. Methods
6. Materials

Histogram Exercise

The following videos show how to construct a Histogram in Excel. Depending on the version of Excel you have, choose from one of the following videos.

 | Watch

Excel 2007

Excel 2010

Excel 2011

Excel 2013

 | Practice

After reviewing the video, construct a histogram using the scenario below.

A medical device company has a total of 20 inspections completed last week for incoming material. These inspections took varying times depending on the complexity of the inspection, the amount of paperwork involved, and experience of the inspector. The quality supervisor wants to understand hours spent on inspection and their frequency.

The inspection times for the last week are as follows:

3, 5, 8, 11, 13, 2, 19, 23, 22, 25, 3, 10, 21, 14, 9, 12, 17, 22, 23, 14

Construct a histogram in Excel using this data.

Hint-

Title: Number of Inspections

x-axis: Hours Spent

y-axis: Inspections