Find the Vital Few That Drive the Most The 80/20 Rule

How it works

The analysis sums the value column for every category, ranks the categories from largest to smallest, and builds the cumulative share curve. The vital few is the smallest set of categories whose cumulative share reaches 80%. Categories are then split into ABC classes: A up to 80%, B from 80 to 95%, C the remaining tail. Concentration is summarized by the top-category share, the top-three share, and a Gini score. A Pareto chart shows the ranked bars (top 20, with the rest pooled into Other) alongside the cumulative share.

Use it whenever you have a category and an amount and want to know which few categories carry most of the total: defects, complaints, downtime causes, revenue by customer or SKU, spend by supplier.

Not for testing whether categories differ significantly (use a categorical test), not for rates or averages that do not sum to a meaningful total, and not when every category is roughly equal. There is no vital few to find.

What data do you need?

Any table with a category and an amount. For example, a defect log:

Minimum 5 rows · Best with A few hundred to a few thousand rows across 10-200 categories

What's in the report?

Standard-library analysis: find the few categories that drive most of the total, straight from a raw category/value table. The analysis totals your value by category, ranks them biggest to smallest, builds the cumulative 80/20 curve, and reports the vital few that reach 80%, the ABC classes (A/B/C), and how concentrated the total is: the workhorse Lean and Six Sigma tool for defects, complaints, revenue concentration, or SKUs. Map one category column and one numeric value column.