Pareto Analysis Tool
Turn defect, delay, complaint, or cost data into a ranked Pareto analysis. Find the largest contributors and see how quickly cumulative impact approaches 80%.
Total measured impact
120
Occurrences
Top 3 contributors
75.8%
Share of total impact
Categories to reach 80%
4
Ranked from largest to smallest
1. Enter your data
Add each cause once. Counts must use the same unit and time period.
2. Pareto chart
Bars show individual impact; the line shows cumulative percentage.
The red dashed line marks 80%. Use the ranked table below to identify which categories account for most of the measured impact.
3. Ranked results
Sorted automatically by highest impact. Use these results to prioritize root-cause investigation.
| Rank | Category | Occurrences | Share | Cumulative |
|---|---|---|---|---|
| 1 | Late vehicle arrival | 42 | 35.0% | 35.0% |
| 2 | Loading delay | 31 | 25.8% | 60.8% |
| 3 | Documentation error | 18 | 15.0% | 75.8% |
| 4 | Equipment unavailable | 14 | 11.7% | 87.5% |
| 5 | Vehicle capacity mismatch | 9 | 7.5% | 95.0% |
| 6 | Other causes | 6 | 5.0% | 100.0% |
| Total | 120 | 100.0% | 100.0% | |
What is Pareto analysis?
Pareto analysis ranks categories by their measured contribution and calculates each category’s share and cumulative share. In Lean Six Sigma, it helps teams decide which defects, delays, costs, or complaints to investigate first.
How to use this tool
- Choose a clear analysis title and a single unit of measurement.
- Enter categories and their counts or measured impact for the same period.
- Review the automatically ranked bars, individual shares, and cumulative percentages.
- Investigate the largest contributors, then export the table to CSV for your project records.
Pareto analysis identifies where the measured impact is concentrated; it does not prove root cause. Validate the data and use tools such as 5 Whys or a fishbone diagram to investigate why the largest contributors occur.