Pareto Charts created by QI Macros for Excel


© 2007 KnowWare International, Inc. DBA LifeStar
2253 S. Oneida St., Ste 3D
Denver, CO 80224

Jay Arthur
888-468-1537
303-756-9144
Email Us

We help people think!

Pareto Charts and the 80/20 Rule

Pareto Charts use the 80/20 rule, based on the work of Vilfredo Pareto the Italian mathematician, who suggested that 20 percent of the people would accumulate 80% of the wealth. In America, 4% of the people have over 50% of the wealth--the Pareto principle squared.

In Six Sigma, Pareto charts show where effort can be focused for maximum benefit. It may take two or more Pareto charts to focus the problem to a level that can be successfully analyzed.

How is a Pareto Chart Created?

The Pareto chart combines a bar graph with a cumulative line graph. The bars are placed from left to right in descending order. The cumulative line graph shows the percent contribution of all preceding bars.

Here is a sample Pareto chart created using the QI Macros for Excel SPC software

Pareto Chart Excel

I really like the QI Macros. The Pareto chart is worth the purchase price of the whole deal."
Mike Dean, Ellwood Texas Forge .


The Pareto chart macro and Pareto Chart Template are just one of the tools included in the QI Macros for Excel SPC Software for Excel.

Buy QI Macros Excel SPC Software for Histograms and Control Charts Now QI Macros Excel SPC Software for Histograms and Control Charts $139 Plus S&H

Common Pareto Chart Errors

1. Stopping Your Pareto Chart Analysis Too Soon

A common error is to stop at too high a level. 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.

Pareto Chart Excel  4 50 rule

2. Settling for a Perflato chart instead of a Pareto Chart

If the left bar or two left bars on your Pareto chart are not significantly bigger than the other bars on the chart then you have a "perflato" chart. Try organizing your data by another attribute (e.g subtotal by geography 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.

To learn more about how to analyze Excel tables using the Pareto chart, click here.

 

The QI Macros has been a really useful tool for me since 2000. Almost everyone who has seen it has been impressed. I use the Pareto Chart and the Histogram on a daily basis. It has even been praised by the Corporate Auditors as well as our ISO Registrar.
You have demystified the Six Sigma/Statistics world for me. I wish I had had this software available when I was in the Army.
Rich Richardson, Quality Assurance Manager, Muller Martini Mfg. Corp


The Pareto chart macro and Pareto Chart Template are 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

Buy the QI Macros Now! Unconditional, No Questions Asked, 90-day Money-Back Guarantee!

Buy QI Macros Excel SPC Software for Histograms and Control Charts Now QI Macros Excel SPC Software for Histograms and Control Charts $139 Plus S&H



© 2007 KnowWare International Inc. (888) 468-1537
knowwareman@qimacros.com
Home | Lean Six Sigma | QI Macros | KnowWare | Site Map

QI Macros 30-day Trial & FREE QI Macros Course
Name:
E-mail
 

QI Macros SPC Software for Excel
Or Buy It Now!
Unconditional
90-Day
Money-Back
Guarantee

The QI Macros for Excel $139, is an inexpensive easy to use set of Excel add-ins for statistical process control and Lean Six Sigma. It draws line, pie, bar, pareto, box whisker, histogram (Cp, Cpk), scatter and control charts (with stability analysis).

It contains over 70 fill in the blank templates such as the Ishikawa diagram, QFD, DOE, FMEA, PPAP, and Gage R&R for MSA. Performs ANOVA, t-test, F-test, and regression analysis.

Buy All-in-One, Excel SPC Software Now

Quantity Discounts

Customer Testimonials

Minitab Comparison

QI Macros FAQs

FREE Lean Six Sigma Course
& QI Macros 30-day Trial
Name:
E-mail