methodatlas

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.

Core question
Which categories contribute most to the measured total burden?
Participants
1-6 participants
Time
30–60 minutes with prepared data
Paper illustration for Pareto Analysis
  1. Set measurement basis

    Set measurement basis

    Choose one unit and period; define categories and assign every case once.

  2. Total and sort

    Total and sort

    Add values per category, calculate the total and sort categories descending.

  3. Calculate shares and curve

    Calculate shares and curve

    Share = value / total × 100; cumulative = running sum / total × 100. Round only for display.

  4. 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.

Pareto Analysis· worksheet
RankItemValue (cases)Share (%)Cumulative (%)
1Enter category and measurements; calculate from unrounded values.Login access5839.739.7
2Enter category and measurements; calculate from unrounded values.Payment status3926.766.4
3Enter category and measurements; calculate from unrounded values.Course navigation2517.183.6
4Enter category and measurements; calculate from unrounded values.Other2416.4100
  1. 1. Item

    1
    Login access
    2
    Payment status
    3
    Course navigation
    4
    Other
  2. 2. Value (cases)

    1
    58
    2
    39
    3
    25
    4
    24
  3. 3. Share (%)

    1
    39.7
    2
    26.7
    3
    17.1
    4
    16.4
  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.

ASQ: Pareto Chart

First step

Agree metric, period and mutually exclusive categories; prepare complete raw data.

Open the method guide

Deep dive

Purpose

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.

How it works

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.

In detail

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.

Facilitation

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 guide

Your perspective

Does this method help with your work?

Your feedback helps shape the next improvements to methodatlas.

Sources and topics

Topics
Artifact templates
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

RankItemValue (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.

ASQ: Pareto Chart

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.

All methods
Constraints and origin
LowWorkshop + async30-60 min

Profile

Method form
Decision method
Participants
1-6
Time
30-60 min
Maturity
Canonical
Origin
Vilfredo Pareto
A 5 Whys working surface connects an observable problem with evidenced causes, marked uncertainty and concrete countermeasures with ownership.
Next up: 5 Whys