Pareto Analysis

Many of us have heard about the term Pareto Analysis or Pareto Chart or 80-20 rule. But, what is the meaning of it? And how to use it in our day to day life?

This article explains about the Benefits of Pareto analysis, How to use it with Demonstration and how we can utilise it in our daily activities.

First of all we will see the history of Pareto chart:

History of Pareto chart

Origin: The principle of Pareto goes way back to 1897, when Vilfredo Pareto used the 80-20 rule to represent the distribution of wealth in Italy. He observed that 20% of Italian population possesses 80% of the Land and wealth of the country.

Later on, Joseph M. Juran named the principle “PARETO” after the Italian economist Vilfredo Pareto in 1941.

Pareto Chart is one of the 7 tools of the Quality Management.

Different names of Pareto analysis

• Pareto Principle
• 80-20 rule
• Law of the vital few
• Principle of factory sparsity

Principle of Pareto Analysis

It states that the 80% of problems/effect are caused by 20% of the causes. In short, the purpose of the chart is to find the most important/critical factor from the set of many other factors.

Examples:

• 80% of manufacturing defect comes by 20% of human error
• 80% of road accidents occurs by 20% of drivers
• 80% wealth belongs to 20% of population
• 20% employee contributes to 80% of revenue
• 20% of time spent on work gives 80% results

Benefits of Pareto Analysis

• Separate the problem and causes
• Helps to focus on the right problems
• Enhance the decision making skills
• Improves problem solving skills
• Increases the efficiency of work
• Saves time

Now that we know the principle and benefits of it, let us see how to prepare the Pareto chart and what the data that needs to be collected are.

How to make Pareto chart

Pareto chart is prepared majorly in Microsoft Excel and Minitab.

We will illustrate the chart in Microsoft excel.

Let us take an example of a printing press. So, there is a printing press and during the process of printing, there are various defects that occurs on the paper.

Step 1

The first step will be to collect the data of all the defects and the number of time it occurs on paper in one set of operation. Example is shown in table below.

As shown in the above table, there are various defects that occurred during the printing of paper and in the other column there are Number of Occurrence i.e. the total number of time it occurred on the paper.

Note: Number of occurrence can also be named as frequency

Step 2

The next step will be to arrange the Occurrence in descending order and make other two column of Cumulative and Cumulative percentage

Problem Category	Occurrence	Cumulative	%Cumulative
Folded edges	180	180	49%
Incorrect shade	79	259	70%
Torn piece of paper on roll	41	300	81%
Dusty spot on paper roller	23	323	88%
Wrinkles	14	337	91%
Cross Printing	13	350	95%
Ink Adjustment	12	362	98%
Multiple units colour adjustment	7	369	100%
Total	369

To calculate cumulative numbers, we have to add each occurrence from occurrence table to the sum of its predecessors.

Example: The first number i.e. 180 (in cumulative column) will remain same, while the second number 259 = 180 (in cumulative column) + 79 (Incorrect shades) and again 300 = 259 (cumulative number) + 41 (Torn piece of paper) and so on.

Note: The last number in cumulative column will always be same as the total number of occurrence. In this case 369 is the number which will be same in final cumulative column as well as total occurrences.

Similarly, also calculate the % cumulative.

To calculate cumulative percentage: Cumulative number/Total number of occurrence

For example: for, 49% = 180/369 and so on.

Step 3

The next step will be to prepare Pareto chart. Go to Insert – select column chart. After clicking on the column chart, white chart space will open. Right click on it and ‘Select data’. After clicking on select data, the below screen will occur.

Select the column of ‘Problem category’ and ‘Occurrence’ together. Insert comma (,) in Chart data range and select ‘Cumulative percentage’ column.

Your Pareto chart will be displayed like the above image.

Step 4

Now that the main Pareto chart is prepared, it is time to edit and make it more visible and easy to understand.

Right click on the red %cumulative and click on “Change series chart type”. After clicking on it, a new dialog box will open. In the drop down in front of %cumulative choose “line with marker” and then click OK

Step 5

After the above step, right click on the red line in the chart and click on “Format data labels” and select secondary axis.

The above image shows the almost completed Pareto chart. You can right click on the blue columns and add labels and also edit the position of it. Also you can do same for %cumulative axis by right clicking and add labels. One can easily change colour, font size and position of the numbers

Step 6

The next step will be to display the defects which contributes to the 80% of the problems, for that go to Insert- shape and select any suitable shape and highlight the chart up till 80%.

One can easily see in the above chart that 80% problems are highlighted as “Vital few”, meaning three main defects are contributing to the 80% of the problems in the printing press.

The next step will be to do brainstorming, analyse the problem and get suitable solution using Root cause analysis.

Pareto charts in Excel

You can download the pareto chart excel template here.

Thank you

If you know any subject that can be related to manufacturing industry or industrial engineering, you can earn some income by becoming article contributor of this website. For knowing more about it, please visit Join us page.

You don’t need to have any experience in article writing, just knowledge on the subject is needed.

Also you can know more about our team of article contributors by visiting the about us page.

About the Author

Jay Desai has over 4 years of experience in Lean Six Sigma, Operations Management and Production Engineering. A post graduate in Computer Integrated Manufacturing from Nirma University. He has successfully delivered Lean deployment, training and project coaching at many levels within customers organization as well as delivered educational programmes.

Latest articles from Know Industrial Engineering

• KIE Factory Stories: Why Did the Plant Head Ask for a Smaller Warehouse?
  “We need more storage space.” The Warehouse Manager was convinced. Advertisement Finished goods were filling every available corner. Pallets were blocking aisles, and the team was struggling to find space for incoming material. His solution was simple. Build a bigger warehouse. But the Plant Head asked him to check one number first. “How many days… Read more: KIE Factory Stories: Why Did the Plant Head Ask for a Smaller Warehouse?
• What is Performance Rating in Time Study?
  What is Performance Rating? Performance Rating is the assessment of an operator’s working pace compared with a defined normal performance level during a time study. Advertisement It helps an Industrial Engineer adjust observed time when the operator is working faster or slower than the normal pace. In simple terms If an operator completes a task… Read more: What is Performance Rating in Time Study?
• KIE Factory Stories: Why Did the Engineer Remove a Safety Sign?
  “Who removed the warning sign?” The supervisor was not happy. Advertisement The sign had been placed beside a machine after a small hand injury. Everyone knew the area was dangerous. But the sign was gone. The safety engineer had removed it. The supervisor stared at him. “Why would you remove a safety warning?” The engineer… Read more: KIE Factory Stories: Why Did the Engineer Remove a Safety Sign?
• What is Standard Time in Industrial Engineering and Why Is It Important?
  What is Standard Time? Standard Time is the time allowed to complete a specific task under defined working conditions, including appropriate allowances for fatigue, personal needs, and unavoidable delays. Advertisement It helps establish a realistic expectation for how long a properly trained operator should take to complete the work. In simple terms If an operator’s… Read more: What is Standard Time in Industrial Engineering and Why Is It Important?
• KIE Factory Stories: Why Did the Purchase Manager Reject the Cheaper Supplier?
  “We can save ₹8 per piece if we switch suppliers.” The Purchase Manager expected everyone to agree. Advertisement Instead, the Plant Head asked one question: “How much will we really save?” The supplier’s price was lower. But there was a catch. The new supplier delivered in larger batches. That meant more inventory. Their lead time… Read more: KIE Factory Stories: Why Did the Purchase Manager Reject the Cheaper Supplier?
• What are Value-Added and Non-Value-Added Activities in Manufacturing?
  What is a Value-Added Activity? A value-added activity is an activity that changes the product in a way the customer requires and is willing to pay for. Advertisement Examples: What is a Non-Value-Added Activity? A non-value-added activity consumes time, effort, space, or resources without increasing the value of the product. Examples: Simple Example Consider an… Read more: What are Value-Added and Non-Value-Added Activities in Manufacturing?
• Stories from the Factory Floor #06
  “Just increase the speed.” That was the Plant Manager’s answer. Advertisement The customer order had increased, and the factory was struggling to meet the target. The team increased the machine speed. Output went up. Everyone was happy. For a while. Then the rejection rate started climbing. Operators were rushing. Minor breakdowns became frequent. Rework increased.… Read more: Stories from the Factory Floor #06
• What is Ergonomics in Manufacturing and Why Does It Matter?
  What is Ergonomics? Ergonomics is the science of designing workstations, tools, equipment, and tasks to fit the worker. Advertisement The goal is to make work safer, more comfortable, and more efficient. In simple terms Instead of asking: “How can the operator adapt to the workstation?” Ergonomics asks: “How can we design the workstation so the… Read more: What is Ergonomics in Manufacturing and Why Does It Matter?
• Stories from the Factory Floor #05
  “We have always done it this way.” The sentence came up three times during the meeting. Advertisement The team was discussing a process that required six approvals before a job could move to production. Nobody could explain why all six were still necessary. So they went looking. Approval 1 was added after a quality issue… Read more: Stories from the Factory Floor #05
• What are the 8 Wastes in Lean Manufacturing?
  What is Waste in Manufacturing? In Lean Manufacturing, waste means any activity that consumes resources but does not add value from the customer’s perspective. Advertisement A process can look busy and still contain significant waste The 8 Wastes Simple Example An operator produces a component in 30 seconds, but spends another 10 seconds walking to… Read more: What are the 8 Wastes in Lean Manufacturing?
• Stories from the Factory Floor #04
  The customer called three times. Same complaint. Advertisement “The product is good, but it is difficult to use.” Quality checked the product. It passed every test. Production checked the process. Everything was within standard. Engineering checked the drawings. No problem there either. So the team visited the customer. They watched how the product was actually… Read more: Stories from the Factory Floor #04
• What are Manufacturing KPIs and Why Are They Important?
  What is a Manufacturing KPI? A Manufacturing KPI (Key Performance Indicator) is a measurable value used to understand how effectively a manufacturing process is performing. Advertisement KPIs turn production performance into data that can be monitored and improved. In simple terms Instead of saying: “Production seems slow.” A KPI helps quantify it: Output = 8,500… Read more: What are Manufacturing KPIs and Why Are They Important?
• Stories from the Factory Floor #03
  “Don’t change anything.” That was the instruction from the Production Manager. Advertisement The line had been running for years. Same machines. Same layout. Same work method. Same problems. One young engineer noticed that operators were making the same small adjustment almost every hour. She asked why. An operator replied: “Because the machine doesn’t work properly… Read more: Stories from the Factory Floor #03
• What is Performance Rate and Why Is It Important in Manufacturing?
  What is Performance Rate? Performance Rate measures how fast a machine or production process operates compared with its ideal or planned production speed while it is running. Advertisement It helps answer: “When the machine is running, is it producing as fast as it should?” In simple terms A machine may be available for production but… Read more: What is Performance Rate and Why Is It Important in Manufacturing?
• Stories from the Factory Floor #02
  “Why are we producing this?” Nobody answered. Advertisement The Production Manager looked at the planning sheet. The order was approved. The material was available. The machine was ready. So production continued. Two days later, the finished products were sitting in the warehouse. Nobody was asking for them. The Planning Manager checked the customer order. The… Read more: Stories from the Factory Floor #02
• What is Quality Rate and Why Is It Important in Manufacturing?
  What is Quality Rate? Quality Rate measures the proportion of produced units that meet the required quality standards compared with the total units produced. Advertisement It helps answer: “How much of what we produced was good without being rejected?” In simple terms If a process produces 1,000 units and 30 units are defective: Good units… Read more: What is Quality Rate and Why Is It Important in Manufacturing?
• Stories from the Factory Floor #01
  “We don’t have it.” The Plant Head thought he had heard wrong. Advertisement “What do you mean?” “One component is out of stock.” The entire production line was ready. Operators were waiting. Machines were ready. Orders had to be shipped. The missing component? It cost less than ₹20. “Check the warehouse.” Nothing. “Check incoming material.”… Read more: Stories from the Factory Floor #01
• What is Voice of the Customer (VOC) and Why Does It Matter in Manufacturing?
  What is Voice of the Customer? Voice of the Customer (VOC) is the process of collecting and understanding customer needs, expectations, requirements, and feedback. Advertisement It helps manufacturers understand what customers actually value not just what the company assumes they value. In simple terms A customer may say: “I need faster delivery.” But the real… Read more: What is Voice of the Customer (VOC) and Why Does It Matter in Manufacturing?
• What is PMTS and How Can It Help Determine Standard Time?
  What is PMTS? PMTS stands for Predetermined Motion Time System. Advertisement It is a work measurement technique used to determine the time required to perform a task by analyzing the basic human motions involved, rather than measuring the entire task repeatedly with a stopwatch. In simple terms Instead of asking: “How long did this operator… Read more: What is PMTS and How Can It Help Determine Standard Time?
• What is Heijunka and How Does Production Leveling Improve Factory Flow?
  What is Heijunka? Heijunka is a Lean manufacturing method used to level production volume and product mix over time. Advertisement Instead of allowing demand fluctuations to create highly uneven production schedules, the goal is to create a smoother and more predictable workload. In simple terms Imagine customer demand requires: A factory could produce all of… Read more: What is Heijunka and How Does Production Leveling Improve Factory Flow?
• What is Production Mix and Why Does It Matter in Manufacturing?
  What is Production Mix? Production Mix refers to the combination and quantity of different products a factory produces during a specific period. Advertisement A factory may have enough total capacity, but the product mix can still create a capacity problem. In simple terms Suppose a factory produces: 🔹 Product A🔹 Product B🔹 Product C Each… Read more: What is Production Mix and Why Does It Matter in Manufacturing?
• What is Production Planning and Control (PPC) and Why Is It Important?
  What is Production Planning and Control? Production Planning and Control (PPC) is the process of deciding what to produce, how much to produce, when to produce it, and how to control the production process to meet customer requirements. Advertisement In simple terms PPC connects: Customer Demand → Production Plan → Materials → Machines → Manpower… Read more: What is Production Planning and Control (PPC) and Why Is It Important?
• What is Queue Time and How Does It Affect Manufacturing Lead Time?
  What is Queue Time? Queue Time is the time a job spends waiting before the next operation can begin. Advertisement The product is not being processed during this period it is simply waiting. In simple terms Manufacturing time can include: Processing Time + Waiting Time + Movement Time + Inspection Time A product may require… Read more: What is Queue Time and How Does It Affect Manufacturing Lead Time?
• What is Downtime Analysis and How Can It Improve Production?
  What is Downtime Analysis? Downtime Analysis is the systematic study of when, why, and how long production equipment or processes remain unavailable for production. Advertisement Instead of simply recording: “Machine stopped for 2 hours.” Industrial Engineers investigate: “Why did it stop, how often does it happen, and what is causing the biggest loss?” In simple… Read more: What is Downtime Analysis and How Can It Improve Production?
• What is Resource Utilization and Why Does It Matter in Manufacturing?
  What is Resource Utilization? Resource Utilization measures how effectively available manufacturing resources are being used compared with their available capacity. Advertisement Resources can include: In simple terms If a machine is available for 8 hours but actually produces for only 6 hours, its utilization is: 6 ÷ 8 × 100 = 75% The remaining 25%… Read more: What is Resource Utilization and Why Does It Matter in Manufacturing?
• Revisiting my Production Engineering subjects: SCT College, 2006–2010
  By Melvin Vincent In 2006, I joined Sree Chitra Thirunal College of Engineering, Trivandrum, to pursue B.Tech in Mechanical Engineering, Production Engineering stream, under the University of Kerala. I graduated in 2010. Advertisement Years later, I feel like opening those books again. Some lessons have stayed with me; others need a little refreshing. I am… Read more: Revisiting my Production Engineering subjects: SCT College, 2006–2010
• Elon Musk Says Money Won’t Matter in the Future. Is It Already Happening?
  Elon Musk has repeatedly discussed a future where AI and robotics could create such enormous productivity that many goods and services become extremely abundant. It sounds difficult to imagine. Advertisement But look at the past. We may already have experienced smaller versions of the same transformation. Things That Once Cost Money but Are Now Almost… Read more: Elon Musk Says Money Won’t Matter in the Future. Is It Already Happening?
• What leads to recent 4.3 Million EVs Recall – An analysis
  In August 2026, nine vehicle manufacturers announced recalls covering approximately 4.276 million electric vehicles in China. The recalls centred on a safety mechanism that was already present in the affected vehicles: the mechanical emergency door release. This was not simply a case of millions of defective door latches. The concern arose from what could happen… Read more: What leads to recent 4.3 Million EVs Recall – An analysis
• Understand how money works through This story of Adam and Ben
  Imagine Earth thousands of years ago. There is only one man. Let’s call him Adam. Advertisement Adam wakes up hungry. He catches a fish. He eats it. Later, he wants shelter. So he cuts some wood and builds a small hut. He wants water. He walks to the river and collects it. There is no… Read more: Understand how money works through This story of Adam and Ben
• Mukesh Ambani’s Three Success Rules Every Manufacturing Professional Should Follow
  Manufacturing professionals are trained to solve problems. A machine stops, we restore it. A line misses its target, we rebalance it. Rejection increases, we search for the root cause. Yet one important problem often remains unattended: Are we building only a successful process, or are we also building a successful career? Many capable engineers spend… Read more: Mukesh Ambani’s Three Success Rules Every Manufacturing Professional Should Follow