Sunday, November 16, 2014

Pareto chart



Pareto chart
A lot of people have heard about Pareto chart. But do we know what Pareto chart is?
A Pareto chart, named after Vilfredo Pareto, is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the cumulative total is represented by the line. The left vertical axis is the frequency of occurrence, but it can alternatively represent cost or another important unit of measure. The right vertical axis is the cumulative percentage of the total number of occurrences, total cost, or total of the particular unit of measure. Because the reasons are in decreasing order, the cumulative function is a concave function.
Pareto charts are extremely useful for analyzing what problems need attention first because the taller bars on the chart clearly illustrate which variables have the greatest cumulative effect on a given system. These charts can be generated by simple spreadsheet programs, such as OpenOffice and Microsoft Excel and specialized statistical software tools as well as online quality charts generators.
The Pareto chart is one of the seven basic tools of quality control.
The Pareto chart provides a graphic depiction of the Pareto principle, a theory maintaining that 80% of the output in a given situation or system is produced by 20% of the input.

What Questions the Pareto Chart Answers?
  • What are the largest issues facing our team or business?
  • What 20 percent of sources are causing 80 percent of the problems?
  • Where should we focus our efforts to achieve the greatest improvements?
When to Use a Pareto Chart
  • When analyzing data about the frequency of problems or causes in a process.
  • When there are many problems or causes and you want to focus on the most significant.
  • When analyzing broad causes by looking at their specific components.
  • When communicating with others about your data.
Pareto Chart Procedure:
  1. Decide what categories you will use to group items.
  2. Decide what measurement is appropriate. Common measurements are frequency, quantity, cost and time.
  3. Decide what period of time the Pareto chart will cover: One work cycle? One full day? A week?
  4. Collect the data, recording the category each time. (Or assemble data that already exist.)
  5. Subtotal the measurements for each category.
  6. Determine the appropriate scale for the measurements you have collected. The maximum value will be the largest subtotal from step 5. (If you will do optional steps 8 and 9 below, the maximum value will be the sum of all subtotals from step 5.) Mark the scale on the left side of the chart.
  7. Construct and label bars for each category. Place the tallest at the far left, then the next tallest to its right and so on. If there are many categories with small measurements, they can be grouped as “other.”
Steps 8 and 9 are optional but are useful for analysis and communication.
  1. Calculate the percentage for each category: the subtotal for that category divided by the total for all categories. Draw a right vertical axis and label it with percentages. Be sure the two scales match: For example, the left measurement that corresponds to one-half should be exactly opposite 50% on the right scale.
  2. Calculate and draw cumulative sums: Add the subtotals for the first and second categories, and place a dot above the second bar indicating that sum. To that sum add the subtotal for the third category, and place a dot above the third bar for that new sum. Continue the process for all the bars. Connect the dots, starting at the top of the first bar. The last dot should reach 100 percent on the right scale.
 
The video below will help you to create a good Pareto chart:
Here is a link on how to create a Pareto chart in Excel:


References:






No comments:

Post a Comment