In many problem situations, effect is distributed unequally across many causes. A Pareto Analysis separates the few drivers with high leverage from the long remainder and focuses attention on what measurably moves the needle.
Decision Making Decision method
Pareto Analysis
Shows which categories contribute most to the measured total burden.
Pareto Analysis orders consistently measured categories by contribution and adds their cumulative distribution. It reveals concentrations for further investigation, while rank alone does not establish cause.
Which categories contribute most to the measured total burden?
- Participants
- 1-6 participants
- Time
- 30–60 minutes with prepared data

Set measurement basis
Set measurement basis
Choose one unit and period; define categories and assign every case once.
Total and sort
Total and sort
Add values per category, calculate the total and sort categories descending.
Calculate shares and curve
Calculate shares and curve
Share = value / total × 100; cumulative = running sum / total × 100. Round only for display.
Focus investigation
Focus investigation
Select the largest actionable contributions and agree a cause investigation with an owner.
Repeat the same measurement logic after a targeted intervention; compare rates as well if volume changes.
A good fit when
For recurring defects, costs or volumes with reliable data.
Ideal for
- Quality improvement
- Backlog triage
- Operational focus
Not good for
- Exploratory ideation without data
- Complex tradeoffs with many criteria
Outputs

Pareto table and chart
Descending category table and Pareto chart with value, share, cumulative share and a justified investigation focus.

Justified investigation brief
The analysis brief defines the later impact check on the same measurement basis and also considers severity and exceptions.
Pareto Analysis· worksheet
Fictional example
Pareto analysis orders consistently measured categories by contribution and adds their cumulative distribution. It reveals concentrations for further investigation. Rank alone does not establish cause.
| Rank | Item | Value (cases) | Share (%) | Cumulative (%) |
|---|---|---|---|---|
| 1Enter category and measurements; calculate from unrounded values. | Login access | 58 | 39.7 | 39.7 |
| 2Enter category and measurements; calculate from unrounded values. | Payment status | 39 | 26.7 | 66.4 |
| 3Enter category and measurements; calculate from unrounded values. | Course navigation | 25 | 17.1 | 83.6 |
| 4Enter category and measurements; calculate from unrounded values. | Other | 24 | 16.4 | 100 |
1. Item
- 1
- Login access
- 2
- Payment status
- 3
- Course navigation
- 4
- Other
2. Value (cases)
- 1
- 58
- 2
- 39
- 3
- 25
- 4
- 24
3. Share (%)
- 1
- 39.7
- 2
- 26.7
- 3
- 17.1
- 4
- 16.4
4. Cumulative (%)
- 1
- 39.7
- 2
- 66.4
- 3
- 83.6
- 4
- 100
Fictional: 146 cases. Share = value / 146 × 100. Cumulative = running sum / 146 × 100; 122 / 146 = 83.6%. Round only for display.
First step
Agree metric, period and mutually exclusive categories; prepare complete raw data.
Good to do first
Deep dive
Causes or contributions are sorted by their share of effect and viewed cumulatively. The curve reveals where a few factors explain most of the problem or potential. The analysis shifts attention from breadth to leverage.
Pareto Analysis is strong when many causes or cases produce unequal amounts of effect. Comparable data and a deliberate counting or weighting unit matter more than the well-known 80/20 formula. The approach pays off once a few drivers are prioritized and then checked against effect.
Make sure the cases under review were counted or assessed comparably before a ranking emerges. The analysis becomes relevant when a few causes explain a large share of the effect and are also influenceable at the same time. Document at the end the main drivers, their data basis, and the intervention that gets checked first.
The method guide walks execution through 4 phases, timing, 4 pitfalls, and clear stop criteria.
Open method guideYour perspective
Does this method help with your work?
Your feedback helps shape the next improvements to methodatlas.
Sources and topics
Pareto Analysis: WorksheetAgree metric, period and mutually exclusive categories; prepare complete raw data.markdown
pareto-analysis-working-template.md
Agree metric, period and mutually exclusive categories; prepare complete raw data.
Pareto Analysis: Worksheet
Question
To be confirmed
Desired outcome
To be confirmed
Scope
Complete cycle Time: 30–60 minutes with prepared data
Complete this worksheet on paper or in your own document during the work.
Preparation for this scope
Method setup
- Materials: Raw data with category and measurement; table or spreadsheet for totals, shares and cumulative shares.
- Roles: Data analyst, process owner and category expert.
- Advance information: Agree metric, period and mutually exclusive categories; prepare complete raw data.
- Overall time needed: 30–60 minutes with prepared data
- Setup: Preserve raw data unchanged; prepare an analysis table and adjacent bars with a cumulative percentage line.
Prepare for the work steps
Set measurement basis: Set measurement basis
- Raw data
- Category definitions
Total and sort: Total and sort
- Reviewed measurement basis
Calculate shares and curve: Calculate shares and curve
- Contribution table
- Positive total
Focus investigation: Focus investigation
- Pareto distribution
- Ability to intervene
Pareto Analysis· worksheet
| Rank | Item | Value (cases) | Share (%) | Cumulative (%) |
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 |
- 1: Enter category and measurements; calculate from unrounded values.
- 2: Enter category and measurements; calculate from unrounded values.
- 3: Enter category and measurements; calculate from unrounded values.
- 4: Enter category and measurements; calculate from unrounded values.
Record metric, period and total. Share = value / total × 100; cumulative = running sum / total × 100. Sort descending; for ABC also define thresholds and the boundary rule.
Set measurement basis: Set measurement basis
Expected artifact: Reviewed measurement basis
Are all values measured using the same rule?
Entry:
...
- Are all values measured using the same rule?
Total and sort: Total and sort
Expected artifact: Descending contribution table
Does the total reconcile with the raw data?
Entry:
...
- Does the total reconcile with the raw data?
Calculate shares and curve: Calculate shares and curve
Expected artifact: Pareto distribution
Does the curve end at 100% without adding rounded shares?
Entry:
...
- Does the curve end at 100% without adding rounded shares?
Focus investigation: Focus investigation
Expected artifact: Justified investigation brief
Is focus data-based without claiming causation?
Entry:
...
- Is focus data-based without claiming causation?
Open questions and next steps
...
Method guide: https://methodatlas.meierhoff-systems.de/en/methods/pareto-analysis/run-sheet
Alternatives and neighbors
Fitting alternatives with decision guidance, followed by other related methods.

Instead of Pareto Analysis, when you want to reliably order processes, responsibilities, or risks in operations with as direct a connection to reality as possible, and for strategic classification and positioning.

Sorts tasks by urgency and importance and turns them into a simple action decision.

Paired data points reveal whether two variables move together and where a suspected relationship needs deeper proof.

Separates events, evidence, confirmed causes, and fitting actions so analysis does not turn into blame-finding.

Clarifies workflows, data, causes, and improvements by framing the problem precisely, branching possible causes, and defining countermeasures.

Clarifies workflows, data, causes, and improvements by framing the situation, analyzing the problem with is/is not, and planning risks and actions.
Constraints and origin
Profile
- Method form
- Decision method
- Participants
- 1-6
- Time
- 30-60 min
- Maturity
- Canonical
- Origin
- Vilfredo Pareto


