Business Growth

    How to Do a Pareto Analysis (Template, Example, and Steps)

    How to do a Pareto analysis for a small business: what the Pareto principle and the 80/20 rule mean, when to use a Pareto analysis, how to make a Pareto chart step by step, a template, a worked example, common mistakes, and a Claude workflow for running your own.

    David Iya
    David Iya

    Founder, AI Tools and Training Club · November 19, 2026 · 8 min read

    A row of wooden blocks on a light oak desk arranged from tallest to shortest like a bar chart, with a thin red string running across their tops, beside a pencil and a notebook in morning light - AI Tools and Training Club

    The short version

    • A Pareto analysis ranks the causes of a problem, or the sources of a result, from biggest to smallest so you can see which few account for most of the impact. It is built on the Pareto principle, often called the 80/20 rule.
    • To do one, pick the problem and the measure, collect real data by category, sort the categories from largest to smallest, add a running cumulative percentage, and focus on the few categories that make up most of the total.
    • Treat 80/20 as a rule of thumb, not a law. Your split might be 70/30 or 90/10. The point is to find the vital few and work on them first, then run a fishbone or 5 Whys to find out why they happen.

    How do you do a Pareto analysis?

    To do a Pareto analysis, choose one problem or result and one way to measure it, such as the number of complaints, hours lost, or revenue. Collect real data over a set period and group every item into a category. Add up each category, sort the categories from largest to smallest, and work out each one's share of the total plus a running cumulative percentage. The handful of categories at the top that together make up most of the total are your vital few. Work on those first.

    My strong opinion: a Pareto analysis is the cheapest way to stop a small business from spreading itself thin. Most owners try to fix every problem a little. Ranking the problems by real impact usually shows that two or three of them drive most of the pain, and fixing those beats a dozen small improvements nobody notices.

    What is a Pareto analysis?

    A Pareto analysis is a way of ranking causes or contributors by size so you can separate the vital few from the many smaller ones. It is named after Vilfredo Pareto, an Italian economist who showed that about 80% of the land in Italy was owned by about 20% of the population. Joseph Juran later applied the same idea to quality management, observing that most problems tend to come from a small number of causes. The usual output is a Pareto chart: a bar chart sorted from tallest to shortest with a line showing the cumulative percentage. The Pareto chart is one of the seven basic quality tools.

    The 80/20 rule is the shorthand version: roughly 80% of the effects come from roughly 20% of the causes. The exact numbers are not the point and will rarely be exactly 80 and 20. What matters is the pattern: impact is usually uneven, and the analysis shows you where it is concentrated.

    Pareto analysisFishbone diagram
    Question it answersWhich causes matter most?What could be causing this?
    Needs data?Yes, counts or amounts by categoryNo, it starts as a structured brainstorm
    OutputA ranked list and chart of causesA map of possible causes to investigate
    Best usedTo decide where to focusTo widen the search before you decide

    Pareto analysis compared with a fishbone diagram

    When to use a Pareto analysis

    • You have many problems and limited time. Ranking them by impact tells you which to fix first.
    • You are looking at where results come from. Which customers, products, or channels bring in most of the revenue or profit, and which take up time without paying for it.
    • You have data you can group. Complaints, refunds, defects, support tickets, sales by product, or time spent by task all work well.
    • You need to win an argument with evidence. A ranked chart settles "what should we fix first" faster than opinions do.
    • Not when you have no data yet. If you cannot count it, start with a fishbone diagram to map possible causes, then collect data and come back.

    How to do a Pareto analysis step by step

    1. Define the problem or result. One specific thing, such as customer complaints, late orders, or revenue by product.
    2. Choose the measure. Common measures are frequency, quantity, cost, and time. Pick the one that reflects real impact. Ten cheap complaints may matter less than two expensive refunds.
    3. Choose the time period. A week, a month, or a quarter. Long enough to be representative, short enough to reflect how the business runs now.
    4. Choose your categories. Group items into clear, non-overlapping categories. If a category name could mean two things, split it.
    5. Collect the data. Use records that already exist where you can, such as your help desk, order system, or accounts. Record the category for every item.
    6. Add up and sort. Total each category and list them from largest to smallest. Group the very small ones into "other" and keep it at the bottom.
    7. Add percentages and a cumulative line. Divide each category by the grand total, then keep a running total of those percentages down the list. The last row should reach 100%.
    8. Find the vital few. Draw a line where the cumulative total covers most of the impact. Those categories above the line are where you start.
    9. Act and re-measure. Fix the top category, then run the same analysis on the next period's data to check that the bar actually shrank.

    Pareto analysis template

    You can do a Pareto analysis in any spreadsheet. Set up one row per category with these columns, sort by the count or amount, and add a bar chart with the cumulative percentage as a line on a second axis.

    ColumnWhat goes in it
    CategoryOne clear group per row, with "other" last
    Count or amountThe total for that category over the period
    Percent of totalThis category divided by the grand total
    Cumulative percentThe running total of the percent column, ending at 100%
    Vital few?Yes for the categories above your cut-off line
    Next action and ownerFor the vital few: what you will do, who owns it, and when you will re-measure

    Pareto analysis template

    Run the analysis twice with two measures, such as number of complaints and cost of complaints. If the ranking changes, the cost version usually tells you what to fix first.

    Pareto analysis example for a small business

    Here is an illustrative example with made-up numbers for an online furniture store. The owner logged every customer complaint for one quarter, 120 in total, and grouped them by cause.

    CategoryComplaintsPercent of totalCumulative percent
    Late delivery4638%38%
    Damaged in transit3025%63%
    Wrong item sent1412%75%
    Unclear assembly instructions1210%85%
    Billing errors87%92%
    Website problems65%97%
    Other43%100%

    Illustrative Pareto analysis of customer complaints over one quarter

    Two categories, late delivery and damage in transit, account for 63% of all complaints, and the top three reach 75%. Both of the top two point at the same place: the delivery partner. Instead of rewriting the assembly guide and redesigning the checkout, the owner's first move is a fishbone and a 5 Whys on delivery, followed by a conversation with the courier. Next quarter, the same analysis shows whether those two bars came down.

    Pareto analysis mistakes to avoid

    • Treating 80/20 as exact. Your data might split 60/40 or 90/10. Use the real numbers, not the slogan.
    • Counting instead of weighing. The most frequent problem is not always the most costly. Check cost or time as well as count.
    • Vague or overlapping categories. If one complaint could fit two categories, the ranking stops meaning anything.
    • A huge "other" bucket. If "other" is one of your biggest bars, your categories are too narrow or something important is hiding in it.
    • Using guesses instead of data. A Pareto chart built from memory just draws a picture of what you already believed.
    • Ignoring small but critical items. A rare safety or legal issue can matter more than a common annoyance. Pareto ranks by the measure you chose, not by risk.
    • Never re-measuring. The analysis only proves a fix worked when you run it again on fresh data.

    How the Pareto analysis fits with other strategy frameworks

    • To map every possible cause before you count: start with How to Make a Fishbone Diagram (Template, Example, and Steps).
    • To dig from your top category to its root cause: run How to Do a 5 Whys Analysis (Template, Example, and Steps) on the tallest bar.
    • To measure how far you are from your target first: use How to Do a Gap Analysis (Template, Example, and Steps).
    • When the data is about lost deals: pair it with How to Do a Win-Loss Analysis (Questions, Template, and Steps).

    How to do a Pareto analysis with Claude

    Claude is useful for the tedious parts of a Pareto analysis: sorting messy records into categories and doing the arithmetic. It does not know your business, so the categories and the decision about what to fix stay with you. Open the Claude desktop app and work through it in passes.

    1. Describe the problem and ask Claude to suggest a measure, a time period, and a short list of clear, non-overlapping categories.
    2. Paste in or upload your raw records, such as complaint emails, support tickets, refund notes, or an export from your order system, and ask it to assign each item to a category and flag any it cannot place.
    3. Ask it to total the categories, sort them from largest to smallest, and add percent of total and cumulative percent columns. Spot check a few rows and the totals yourself.
    4. Ask it to build the Pareto chart as a spreadsheet you can open, or to give you the steps to make one in the spreadsheet you already use.
    5. Ask which categories make up the vital few, and what questions you should ask to find out why the top one happens. Then decide what to fix yourself. Claude does the counting, but the judgment about your business stays with you.
    Inside the AI Tools and Training Club, members bring the problems they are trying to rank and fix to the weekly calls and work out where to focus first. Join at businessbuildersclub.co.

    Frequently asked questions

    What is a Pareto analysis used for?

    A Pareto analysis is used to rank the causes of a problem, or the sources of a result, by size so you can focus on the few that account for most of the impact.

    What is the 80/20 rule?

    The 80/20 rule, or Pareto principle, is the observation that roughly 80% of effects tend to come from roughly 20% of causes. It is a rule of thumb, and real data rarely splits at exactly 80 and 20.

    How do you make a Pareto chart in Excel or Google Sheets?

    List your categories with their totals, sort them from largest to smallest, add a cumulative percent column, then insert a bar chart and plot the cumulative percent as a line on a second axis. Recent versions of Excel also include a built-in Pareto chart type.

    What is the difference between a Pareto analysis and a fishbone diagram?

    A fishbone diagram maps all the possible causes of a problem. A Pareto analysis uses data to rank causes by how much they contribute. Many teams use the fishbone to find candidate causes, then a Pareto analysis to decide which to work on.

    How many categories should a Pareto analysis have?

    Enough to separate the causes clearly, but not so many that each bar is tiny. Around five to ten categories, with the smallest grouped into other, is easy to read.

    Is the vital few always 20%?

    No. The vital few is whatever small group of categories makes up most of the total in your data. It could be one category or four. Use your own numbers to draw the line.

    Keep reading