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

• How to grade operators in a factory and Why
  Share this knowledge and support manufacturing industry Grading of the operators is categorizing or grouping the operators according to the various factors which is essential to do the job. In this article we will be discussing on how to grade operators along with the factors to be considered. So, stay tuned… We are explaining everything… Read more: How to grade operators in a factory and Why
• 50 Problems which 5S Solve
  Share this knowledge and support manufacturing industry In this article we will be discussing about 50 problems in your factory, which can be solved by implementing 5S. Below, we have listed 50 problems and explained how these problems are solved using 5S. Before moving in to list, if you not yet attended our 5S training… Read more: 50 Problems which 5S Solve
• Andon in Manufacturing
  Share this knowledge and support manufacturing industry Visual controls are the major part in any stream of business. May be Production, Road transport, Railway stations and in home appliances. Andon is a visual management tool used in lean manufacturing to communicate the status of production to the operators or the production team. The status can… Read more: Andon in Manufacturing
• A guide on Key Performance Indicator
  Share this knowledge and support manufacturing industry A Key Performance Indicator (KPI) is a measurable metric that evaluates success and aligns actions with strategic goals in business. In the dynamic landscape of modern business, staying ahead requires more than just intuition and experience. Data-driven decision-making has become a cornerstone for success, and Key Performance Indicators… Read more: A guide on Key Performance Indicator
• CNC machine problems and solutions
  Share this knowledge and support manufacturing industry In the intricate world of CNC machining, breakdowns can be a significant hurdle to seamless production. This article dives deep into the most prevalent issues faced by CNC machines, from improper voltage supply to auto tool changer glitches, providing valuable insights into their causes and offering expert solutions.… Read more: CNC machine problems and solutions
• Manpower productivity formula
  Share this knowledge and support manufacturing industry Manpower productivity, also known as labor productivity, is a measure of the efficiency of labor in generating economic output. It is typically calculated by the formula, ratio of output (goods or services produced) to the input of labor. The goal of measuring manpower productivity is to assess how… Read more: Manpower productivity formula
• What is Microsoft Excel
  Share this knowledge and support manufacturing industry Microsoft Excel, a stalwart in the world of spreadsheet software, has become synonymous with data management, analysis, and decision-making. Since its inception in 1985, Excel has undergone significant transformations, evolving into a multifaceted tool that caters to the needs of individuals, businesses, and researchers alike. In this comprehensive… Read more: What is Microsoft Excel
• OEE Software for Maximizing Operational Efficiency
  Share this knowledge and support manufacturing industry In today’s fast-paced industrial landscape, the pursuit of operational excellence is a critical factor for success. One key metric that plays a pivotal role in achieving this goal is Overall Equipment Efficiency (OEE). OEE software has emerged as a powerful tool for businesses seeking to optimize their operations… Read more: OEE Software for Maximizing Operational Efficiency
• Takt time Clock
  Share this knowledge and support manufacturing industry In the realm of manufacturing precision, a pivotal player emerges the Takt Time Clock. This sophisticated timekeeping instrument is more than a mere apparatus; it serves as a cornerstone for aligning production with customer demand. In this exploration, we’ll navigate the professional significance of the Takt Time Clock… Read more: Takt time Clock
• Takt time and Cycle time
  Share this knowledge and support manufacturing industry In the ever-evolving landscape of manufacturing, efficiency is a paramount goal. Two critical concepts that play a pivotal role in achieving this efficiency are Takt Time and Cycle Time. In this article, we will unravel the essence of Takt Time and Cycle Time, exploring their definitions, significance, and… Read more: Takt time and Cycle time
• Takt time example
  Share this knowledge and support manufacturing industry Takt time is a fundamental concept in lean manufacturing that plays a crucial role in optimizing production processes. In this article, we’ll explore a practical example of takt time in the context of an automotive assembly line. Understanding how takt time operates in real-world scenarios is essential for… Read more: Takt time example
• Companies hire Industrial engineers in India
  Share this knowledge and support manufacturing industry Are you an industrial engineer looking for exciting career prospects in India? You’re in the right place! We’ve compiled a comprehensive list of companies that frequently hire industrial engineers. It’s important to note that this isn’t an exhaustive list, and there may be other companies actively seeking industrial… Read more: Companies hire Industrial engineers in India
• SOP vs Work instruction
  Share this knowledge and support manufacturing industry In the dynamic landscape of various industries, ensuring consistency, compliance, and efficiency in daily operations is paramount. Two key documents that play a crucial role in achieving these goals are Standard Operating Procedures (SOP) and Work Instructions (WI). While often used interchangeably, it’s important to recognize that SOPs… Read more: SOP vs Work instruction
• Definition of waste in lean manufacturing perspective
  Share this knowledge and support manufacturing industry The definition of waste in Lean Manufacturing perspective is “any activity that does not add value to the product or service” Something deep inside of almost every person tells us that it is good to improve. It is better to move forward than it is to move backward.… Read more: Definition of waste in lean manufacturing perspective
• AutoCAD Recovery Manager
  Share this knowledge and support manufacturing industry In today’s article we are going to talk about AutoCAD recovery manager. We all know about AutoCAD and how this software has changed our life drastically. If you want to learn more about AutoCAD you can check here. Autodesk’s AutoCAD is a household name nowadays, it is a… Read more: AutoCAD Recovery Manager
• Operational excellence strategy
  Share this knowledge and support manufacturing industry Operational excellence strategy is a comprehensive approach that organizations employ to optimize their processes, enhance productivity, and consistently deliver high-quality products or services. Operational excellence is a multifaceted approach to improving business performance and productivity. It encompasses a wide range of principles, strategies, and practices aimed at optimizing… Read more: Operational excellence strategy
• 3D Printing in manufacturing
  Share this knowledge and support manufacturing industry Hey there! Have you heard about 3D printing? It’s this incredible technology that’s shaking up the world of manufacturing. Let me break it down for you. Imagine a world where you can create anything you want, from the most intricate designs to personalized medical implants, at the touch… Read more: 3D Printing in manufacturing
• Industrial wastewater treatment
  Share this knowledge and support manufacturing industry Industrial wastewater treatment is the process of purifying and removing contaminants from water that has been used in industrial processes. It aims to eliminate harmful substances, such as chemicals, heavy metals, and pollutants, from the wastewater before it is discharged into the environment or returned for reuse. This… Read more: Industrial wastewater treatment
• Takt time excel template
  Share this knowledge and support manufacturing industry Takt time excel template is a format in Microsoft excel, which can be used to calculate takt time from the inputs entered in to it. Following are the three inputs needed for calculating takt time in the excel template; Here you will be able to download the takt… Read more: Takt time excel template
• Eliminate these 6 Big Losses to improve OEE
  Share this knowledge and support manufacturing industry OEE is one of the key factors in calculating efficiency of an Automation or machines. If any factory OEE is more than 85% than the utilization of Automation or machines is very good. In this article we will learn how to increase OEE by eliminating or reducing 6… Read more: Eliminate these 6 Big Losses to improve OEE
• How I got admission for Masters in United States
  In this article I will be sharing my complete experience and will share the steps I have taken to get admission for Masters in United States.
• Gemba Walk
  Share this knowledge and support manufacturing industry Gemba walk can be defined as “A Regular or Scheduled walkthrough through the factory, which focuses on Elimination of Non value added activities (NVAs) in producing a product” Lean methodologies are growing very aggressively in all facilities and brands. Almost all products and services require Lean execution. To… Read more: Gemba Walk
• Factory Layout Design
  Share this knowledge and support manufacturing industry Factory layout design is the process of arranging and organizing elements of a manufacturing facility. Physical spaces, equipment, machinery, workstation, materials, and people are some of the elements of a manufacturing facility. Following points is to be considered while designing the factory layout design; In this article we… Read more: Factory Layout Design
• Skill Matrix Software
  Share this knowledge and support manufacturing industry A skill matrix software is a tool or application that helps organizations in assessing, tracking, and optimizing employee skills. In today’s fast-paced and competitive business environment, Skill matrix software has emerged as a powerful tool for managing their employee’s skills. These software solutions offer features to assess, track,… Read more: Skill Matrix Software
• List of CAD Software
  Share this knowledge and support manufacturing industry Discover CAD software list for efficient technical drawing. AutoCAD, SketchUp, Rhino, Revit, SolidWorks & more. Stay updated & choose the perfect software! Following are the list of CAD Software; Before talking about the available CAD software in the market it is important to understand what actually drafting means.… Read more: List of CAD Software
• General Ledger
  Share this knowledge and support manufacturing industry In an organization, a General Ledger (GL) is a key component of the overall accounting system. General Ledger is a centralized record-keeping system that contains all the financial transactions of a company. The GL serves as a central repository for tracking and reporting financial information, and it plays… Read more: General Ledger
• Common workplace problems and solutions
  Common workplace problems and solutions refer to issues faced in the workplace and the corresponding strategies to address them effectively.
• Accounting Forms
  Share this knowledge and support manufacturing industry Accounting forms are templates or documents which are used to record, track and organize financial transactions. A manufacturing company typically has to maintain many fundamental accounting forms, in order to manage its financial activities. Depending on the company’s size, sector, and reporting requirements, other formats could be used.… Read more: Accounting Forms
• What type of insurance does a manufacturing company need
  Property insurance, Business interruption insurance, etc. and list of insurance for manufacturing company goes up to 13. Know more about them.
• Box and Whisker Plot
  How to interpret a boxplot, a visual 5-number summary.