Pareto Chart  Diagram  Pareto Principles  Excel Template

What is Pareto Chart in 7 QC Tools?

→ It was invented by Mr. Vilfredo_Pareto and it is a combination of a bar graph and a line graph. It helps us to prioritization.
→ In this diagram the order of the largest number of occurrences by item or by classes and the cumulative sum total are available.
→ The bar graph shows the number of defects in descending order and the line graph shows the cumulative percentage of the defect.
→ It is the most popular prioritization tool out of 7 QC Tools for Process Improvement.


What is the Pareto Chart used for?

  • This tool is used for Prioritization
  • It is used to calculate the potential impact of the things
  • It is used for identifying the vital few and trivial many.

History:

→ Vilfredo Pareto was an Italian engineer, sociologist, economist, political scientist, and philosopher.
→ He shows an observation that is: "80% of the land in Italy was owned by about 20% of the population."
→ He introduced the concept of efficiency and helped to develop the field of microeconomics.
→ The Pareto principle was named after him.
→ He also contributed to the fields of sociology and mathematics.




What is the Pareto Principle?

→ It is also known as the 80/20 rule, the law of the vital few or the principle of factor sparsity
→ 80% of the Problems come from 20% of the causes.
→ 80% of the Output comes from 20% of the Input.
→ It Distinguishes between Vital Few from Trivial Many.
→ 80% of the Results come from 20% of the effort

Pareto Principle

How to Do Pareto Chart Analysis?

→ As mentioned in the above picture we can analyze the chart based on the 80/20 rules such as the 20% causes that are responsible for 80% of the problems. Similarly, by applying the 20% efforts we can get rid of 80% of the problems.


How do I make a Pareto chart?

➝ Refer below five steps for Making a Pareto_Chart:
  1. Select the problem.
  2. Collection of data.
  3. Sort data & calculate the cumulative percentage.
  4. Draw the axes, bars, cumulative percentage line, and labeling.
  5. Identify Priority and plan further action.

Step 1. Select the Problem:

➝ Select the problem for investigation.
➝ Determine the data collection method and period of collection.
➝ Design a separate Check Sheet if necessary.
➝ E.g.: Defect analysis.


Step 2. Collection of data:

➝ The second step is data collection for the graph after the selection of the problem

Step 3. Sort data & calculate the cumulative percentage:

➝ The third step is to sort out data and find the cumulative percentage.
➝ Refer the below picture for better understanding and clarification

Step 2 and 3



Step 4. Draw the axes, bars, cumulative percentage line, and labeling:

➝ Now, we have to draw the axes, bars, cumulative percentage line and give title and labeling to the_chart
➝ See the below picture in which all the above things are mentioned.

Construction of  Pareto_Chart

Step 5: Identify Priority and plan further action:

→ Now we analyze the chart and identify Vital Few problems from the Trivial Many by using 80:20 principle and plan further action:
→ Let's say in our example we are taking defect D, E, F, and defect A for further action because the contribution of these defects is almost around 81%. it is as per 80:20 Rule.
→ It is not mandatory to take defects up to 80% we can take only the first two defects which contribute around 65% problem.
→ Now we will take action on these defects by finding the root cause with the help of any root cause analysis method (i.e. Cause and Effect Diagram or 5 Why analysis) of defect generation and implement preventive action on it.


👉 Pareto Chart Excel Template Download


 | Benefits

→ We can easily distinguish between Vital Few and Trivial Many.
→ It displays the relative importance of causes of the problem.
→ It helps the team to focus on those causes that will have the greatest impact when solved.
→ By using 20% of resources we can solve 80% of problems.
→ We can easily understand the impact of the defect on our production
→ It is very easy for analysis by this tool and also this tool is very useful in the various project of six sigma, QCC, and 7QC Tools.


👉 Also Read:
      2. Cause & Effect Diagram (Fishbone or Ishikawa)


👉 For a regular update :   
Join us (Telegram Group)
Join us (WhatsApp Group)

👉 See Also:

8 Comments

  1. Thanks for giving new information

    ReplyDelete
  2. Nor only in six sigma. Long before six sigma there is Toyota Production System as well as QCC and 7QC Tools

    ReplyDelete
  3. what is cumulative and why needed in pareto chart, can you explain me briefly sir..

    ReplyDelete
    Replies
    1. Cumulative is percentage and it is used for creating the graph of cumulative percentage so we can have an estimate abut it.

      Delete
  4. Good morming, i had download pareto chart file. I would need to edit the file. Is possible to have the password??

    Thanks.

    Regards, Carlo.

    ReplyDelete
  5. Good day, I have been following your writeups for a while and I must commend that you are doing a fantastic job sir. Kudos!

    ReplyDelete

Post a Comment

Previous Post Next Post