the science behind breakthrough improvements

First step
You can manage,
  what you can measure;
You can measure,
  what you can define;
You can define,
  what you understand.


discover further
  • Six Sigma Basics
  • Statistics
  • Probability Theory
  • Methods, Tools & Techniques

rss feeds
  • What is RSS Feed?
  • Subscribe

meet author
Sanjaya Kumar Saxena

sanjaya kumar saxena
india

view profile >>


information
  • Mission
  • Terms of Use
  • Contact Form
  • Links



Valid XHTML 1.0 Strict

Pareto Chart

Share/Comment
Add to Deli.cio.us Deli.cio.us   Digg it Digg
Send feedback Feedback e-mail to a friend EMail

A Pareto Chart depicts the frequency with which certain events occur. It is a bar graph where each frequency (or frequency range) is shown in a descending order of importance of data, from left to right.

This is based on the Pareto Principle, also called 80-20 rule or rule of vital few. Formulated by the father of quality - Dr. Juran and named after the famous Italian economist Vilfredo Pareto, this principle helps separate the "vital few" from the "useful many" in any business scenario. It helps us identify and focus on "vital few" to maximize our returns on investments on resources.

To develop an exact understanding of the concept, let us go back to our famous pizza shop example. Here is some old customer complaint data before they mastered the thirty minutes pizza delivery.

Customer Complaint Data

The pizza shop wanted to develop a strategy to reduce the customer complaint dramatically. This is where Pareto Chart comes in to action. Let us see how.

To create a Perato Chart, this data is sorted and cumulative count & percentages are computed as illustrated in the following table.

Cumulative Count & Percentages

Using this data. a bar-cum-line graph is drawn using a standard spreadsheet like MS Excel. The bar represents the count of each complaint and the line illustrates the cumulative complaint count percentages.

Perato Chart
Share/Comment
Add to Deli.cio.us Deli.cio.us   Digg it Digg
Send feedback Feedback e-mail to a friend EMail

With this graph, finding the vital few is simple. Locate the 80% point on the right y-axis and find the corresponding point on the x-axis. It clearly highlights that we need to address "delayed delivery" and "pizza not hot" complaint categories to take care of 80% of the customer complaints. In fact, the "pizza not hot" complaint was partially the result of "delayed delivery" problem. These two complaint categories only constitute 22% of all the complaint categories. Can we see the 80-20 rule? It is evident that by fixing only 20% (22% to be precise) of the complaint categories solve 80% (78% to be precise) of the customer complaints. This helped our pizza shop to focus on solving the right set of the problems


November, 2005   |  Permalink   |  Home   |  Previous Topic   |  Next Topic
Copyright © 2005-08 Sanjaya Kumar Saxena
Rights reserved. Please seek permission for reproduction.