Home / Lean Six Sigma / Basic quality tools
Paste your data from Excel and see in seconds which few categories account for most of the defects, stoppages or costs — with the chart ready to download.
Pre-sizing and estimating tool: results do not replace design, calculations or reports signed by a licensed professional, nor verification against the applicable codes and standards.
Bars from largest to smallest, cumulative percentage curve (right axis) and cut-off line. The vertical line marks off the vital few.
How to read: each bar is a category, from largest to smallest; the height is the count (left axis). The curve climbs as it adds the bars up to 100% (right axis). The bars to the left of the vertical line are the vital few: tackling only them solves most of the problem. Bars all about the same height = no vital few; stratify.
One chart per stratum, all on the same vertical scale: compare the height and order of the bars. Each category keeps the same color in every panel.
Every category in order, with count, percentage and cumulative percentage. Download as .xlsx with the button at the end of the page.
Take this page’s results to another calculator with the fields already filled in.
The calculation report gathers this page's inputs, results, equations, assumptions and references, with fields for project, engineer and revision. The full report also includes the charts and interpretations, in color. In the print dialog, choose Save as PDF.
List the categories (defect types, stoppage reasons) with the count for each, sort from largest to smallest, and work out each one’s percentage and the cumulative percentage. Bars show the counts and the line shows the cumulative total. Here you just paste the two columns from Excel: the sorting, percentages and chart come out ready.
Look at where the cumulative curve crosses the 80% line: the bars to the left of that point are the vital few, which deserve action first. Then check the size of “Other” — if it is large, the classification is too generic. Bars of almost the same height mean there is no clear priority.
No. It is a guideline for concentration, not a law. Sometimes 2 categories make up 90%, sometimes it takes 6 to reach 80%. When the chart comes out flat, stratify the data (by shift, machine, product) or weight it by cost: the concentration usually shows up.
Yes. Paste the log with one occurrence per line (for example, the “defect” column of the inspection sheet): each line counts as 1 and the page adds up repeats, ignoring case and accents. It handles tens of thousands of lines.
When defects cost very different amounts: a dent that turns into scrap can cost ten times more than a scratch that only needs polishing. Choose the layout with cost and see both Paretos side by side; if the order changes, prioritize by cost and use frequency to guide data collection.
To show the effect of an improvement action. Both charts are drawn on the same scale: the targeted bar should shrink, and so should the total. The page calculates the reduction and shows which category became the 1st — the next priority.
The “Download PNG” button creates a high-resolution image on a white background, ready for a presentation or an A3 report. The “One-page report (PDF)” has the chart, the vital few and the conclusion, and the .xlsx button downloads the full table.
Important notice: Indus Metrics tools produce estimates and pre-sizing results from the data you enter and from published engineering methods. They do not replace design, calculations or reports signed by a licensed professional engineer (PE), nor verification against the applicable codes, standards and regulations, such as OSHA rules and the ASME codes. Material and fuel properties vary: check manufacturer data or your own process analyses before deciding. By using this site you agree to the Terms of Use.
© 2026 Indus Metrics. Found an error? Write to contato@seudominio.com.