Pareto Chart Mistakes

home · products · services · search ·  view cart · contact  
 
  NAVIGATION        
 

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar

2253 S. Oneida
Ste 3D
Denver, CO 80224

We help people think!

Copyright © 2008

 



 

A pareto analysis shows where effort can be focused for maximum benefit. Pareto analysis uses pareto charts which combine a bar graph with a cumulative line graph to illustrate the 80/20 rule.

Pareto Analysis in Excel using QI Macros SPC Software for Excel

Common Pareto Chart Mistakes

1. Stopping Your Pareto Analysis Too Soon

A common pareto chart mistake is to stop at too high a level. It may take two or more levels of pareto charts to narrow the focus to an actionable level. How can you tell if you've stopped too soon? In the next step of the problem solving process, root cause analysis, your "fishbone" diagram will turn into a "whalebone" diagram covering many walls. By taking the "big bar" of folded flaps above down one more level, we get a clear insight into where to improve: production line number three.

Pareto Chart Detail with QI Macros SPC Software for Excel

Double the power of Pareto's 80-20 rule by applying the 4-50 rule. Look at the 20% within the 20% (4%) that represents over half of the problem. You can do this by drawing another Pareto chart using just the data representing your big bar. In the example below the blue bar represents the 4% of the business that is causing over 50% of the problem.

2. Using a Parflato chart instead of a Pareto Chart

Another common pareto chart mistake involves using a "parflato" chart. If the left bar or two on your Pareto chart are not significantly bigger than the other bars on the chart then you have a "perflato" chart. A flat pareto chart means that the 80/20 rule does not apply.

Pareto ChartFlat Pareto Chart

Try organizing your data by another attribute (e.g subtotal by geography, cost, or time of day instead of by error type) and see if you can get a Pareto chart that helps you better focus your efforts.

For example, one client created a Pareto chart of insurance claim errors by error code and found no one code that accounted for a significant amount of errors. They then created a Pareto chart of errors by insurance company and found that one company was the source of most of the errors. Once they approached the company with compelling data it was easy to convince them their process needed fixing.

3. Not Comparing Pareto Charts to Show Before and After Improvement

Teams often want to "declare victory" after identifing root cause and implementing countermeasures. The only way to know if the change really improved the process is to compare pareto charts before and after:

Pareto Charts showing improvement using QI Macros SPC Software for Excel

The Pareto chart is just one of the tools included in the QI Macros for Excel SPC Software for Excel.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma





QI Macros - Download with backup CD & User Guide (#230) $139 + S&H
QI Macros - Download Only - No Shipping or Customs Duties (#W230) $139
Unconditional 90-day Money-back Guarantee!


 

 

Download
FREE
30-Day Trial

QI Macros SPC Software for Excel

Or Buy It Now!
Unconditional
90-Day
Money-Back
Guarantee

QI Macros - Download with backup CD & User Guide (#230) $139 + S&H
QI Macros - Download Only - No Shipping or Customs Duties (#W230) $139



 
home | products | services | search |  view cart | contact