Pareto Chart

List your defects or causes with their counts and see the few that cause most of the problem.

Data · 5 categories
CategoryCount
Paste two columns (category, count) from Excel anywhere on this page
Options
%
Same rule as leading statistical software. The same name entered twice is added together.
Vital few
⁦3⁩ of ⁦5⁩ categories cause ⁦85.0⁩% of the problems
Start with Dimensional error: ⁦42.0⁩% of all ⁦100⁩ counts.

Results

Free with an account
Total count100
Categories5
Vital few3
Top category42.0%

Pareto chart

Bars: counts, largest first · line: cumulative % · dashed line: 80%
Breakdown Table
#CategoryCount%Cum %Status
1Dimensional error4242.042.0Vital Few
2Surface defect2828.070.0Vital Few
3Wrong material1515.085.0Vital Few
4Assembly fault99.094.0Useful Many
5Packaging damage66.0100.0Useful Many

About the Pareto chart

How it is calculated · worked example · references

What it does

A Pareto chart sorts problem categories (defect types, causes, complaint reasons, downtime reasons) from the largest to the smallest and draws the cumulative percentage line over the bars. It shows the “vital few” categories that account for most of the problem, so you fix those first instead of spreading effort over everything. Small categories at the end can be grouped into one “Other” bar.

The 80/20 split is a rule of thumb, not a law. Use the chart to choose where to start, and count by cost or severity instead of frequency when one type of defect matters much more than another.

Method

The chart follows the classic Pareto analysis used in quality management, and is tested with hand-calculated cases, including ties and repeated category names.

Worked example

The data behind “Try an example”: 100 rejected parts in five defect types.

CategoryCountCumulative %
Dimensional error4242
Surface defect2870
Wrong material1585
Assembly fault994
Packaging damage6100

The vital few are the first three categories: together they are 85% of the rejects, so that is where the improvement effort should start.

References

  • Juran, J. M., Quality Control Handbook.
  • Montgomery, D. C., Introduction to Statistical Quality Control.