A Pareto analysis ranks the causes of a problem by how often they happen, or what they cost, so you can see which few causes make up most of it. It is named after the Italian economist Vilfredo Pareto, who showed in the 1890s that wealth in Italy and other countries was concentrated in the hands of a small share of the population.
Joseph Juran, the quality pioneer, applied the idea to quality problems in the 1940s and called it the principle of the "vital few and trivial many". The 80/20 split is a rule of thumb, not a law. The useful point is that causes are rarely equal.
A heating and plumbing firm logs 100 customer complaints over three months:
| Cause | Count | Share | Running total |
|---|---|---|---|
| Engineer arrived late | 42 | 42.0% | 42.0% |
| Wrong part on van | 23 | 23.0% | 65.0% |
| Invoice error | 15 | 15.0% | 80.0% |
| Mess left on site | 8 | 8.0% | 88.0% |
| Not called back | 6 | 6.0% | 94.0% |
| Other | 6 | 6.0% | 100.0% |
Three of the six causes make up 80% of complaints. Late arrival alone is 42%. Fixing late arrival, perhaps through more realistic booking slots and a text when the engineer sets off, would do more than tackling the other four causes together.
Enter your causes and counts. The table sorts them and adds the running total for you.
Ranking by count shows what happens most often. Ranking by cost can give a different order: one rare but expensive cause, such as a warranty claim, can outweigh many cheap ones. Where costs differ a lot, multiply each count by the average cost of that cause and rank again.
A Pareto chart shows where to look, not why it happens. Take the top cause and use the 5 Whys to find its root cause. After the fix, count again for another four weeks and redraw the chart. The order often changes, and the new top cause is your next project.
Free Excel templates for time studies, debtor days and staff costs. Enter your email once and download them all.
Get the Free Templates →Want an independent view of your own numbers? See the Diagnostic Assessment.