Pareto Chart

During my PMP exam preparations, I was a bit confused between a histogram and a Pareto chart. A Pareto Chart is just an advanced type of histogram. I will try to discuss all the concepts easily – Stay tuned!

Pareto Charts is also known as Pareto diagram, Pareto analysis. It is one of the most important 7 Basic Quality Control Tools (Fishbone diagram, Scatter diagram, Histogram, Check sheets, Flow charts, Pareto Charts, Control Charts).

If you are a history guy, then you need to know that Kaoru Ishikawa – professor at Tokyo University, was the first who emphasized these QC tools.

Each quality tool has its own functions and is used as per conditions. The Pareto Charts helps to perform a root cause analysis. Fishbone Diagrams (Cause & Effect, Ishikawa) & Scatter Diagrams are also used to perform root cause analysis.

Pareto Principle (80:20)

Pareto Principle was developed by Vilfredo Pareto, an Italian economist and sociologist who performed Italy in the early 1900s.

One day while working in his garden, and observed that 80% of beans are being produced by 20% of bean plants.

He came to know that 80% of the wealth is concentrated in the hands-on only 20% of the people there. World GDP in Pareto perspective Richest 20% (82.70%),  Second 20% (11.75%) Third 20% ( 2.30%) Fourth 20% (1.85%) Poorest 20% (1.4%)

And 80% of the problems incurred are caused by 20% of the major causes.

So, a Pareto principle is basically talking about the unequal distributions in the universe.

  • 80% of your jobs created by 20% of companies in the world.
  • 80% of the friends don’t give you joy, but 20% do 🙂
  • 80% of the shoes you have don’t use often but 20%.
  • 20% of the syllabus you study is in exam paper 80% is not.
  • 80% of the defects are due to 20% of the problems.
  • 20% of my blogs generate more income than 80% of the rest.

This 80:20 rule is roughly calculated; it can be 90:10, 70:30, or even 99:1. Whatever is the ratio, but it will undoubtedly help to invest your efforts in most cases.

The Pareto Charts helps to find major causes first, and this way, we only concentrate only on the major ones. So, you will get to know that a few causes occur the majority of the defects.

How does the Pareto Charts help?

You will also see many occasional/seasonal problems that cause the effect occasionally. This is called rule as a vital few over the trivial many.

  • To draw a Pareto diagram is easy.
  • We can quickly get significant effects and their causes.
  • It eliminates the seasonal problem to save our time as we are not considering those anymore for that particular analysis.
  • These charts also help during a report to top management as you can visualize the problem quickly.

How to Draw a Pareto Chart | Example

Before going for a graph, you need to be clear that the data can be arranged into categories, and each category is essential. Make sure to download the template here for a better understanding of the Pareto Charts Excel Template.

Step – 1. Collect raw data about the cause and effect (Problem)

Step – 2. Use checksheets and tally your data. This will help you to determine the units, like frequency, cost, time, etc.

Step – 3. Check also the period to use use the collected data like one year, one area or whole project or EPS, or even one week.

Step – 4. Define your category bars

Step – 5. Put causes on horizontal the x-axis and frequencies on the y-axis

Step – 6. Ensure the bar with the highest number of frequencies should be at the extreme left on the chart.

Step – 7. Add cumulative counts and lines by adding each percentage, and the right side has a maximum rate of 100%.Pareto Chart MS Excel Template

Example of a Pareto Chart

In the above example, you downloaded we got more than 1000 defective casting pieces. We started to segregate and used telly sheets to record the data.  Some defects were so in numbers that we did not consider. This is one of the major benefits of Pareto Charts that you can ignore the less frequent causes.

After we got Blow Holes, Overlaps, Sand Inclusions, Entrapments, Misrun, Porosity, Burning Effects in our telly with high frequency.

We put all in MS Excel in descending order like the most frequent on Blow Holes at the extreme right and so on.

We got a total of 770 defective pieces with repeated defects.

The Pareto chart is ready, and now you draw a cumulative sum line. The procedure to draw this line is as follows:

Calculate each category’s percentage to the total – 770 then, if you are using MS excel, just drop-down or calculate one by one. Put these dots and connect. MS Excel will do all itself for you, but you can make it manually if you prefer it.

Pareto Diagram | Limitations

Pareto charts have some limitations; that’s why we need to choose any QC tool carefully before start implementing. Let see what the significant limitations are;

  1. It is just a thumb rule and not fixed all the time. As I said earlier, it can be 70:30, 90:10, or even 99:1.
  2. Data should be segregated before going to start implementing the Pareto rule.
  3. It needs telly sheets to categorize data, and hence extra time and cost are required.
  4. We can get the root cause but not the solution.
  5. As it will give the major causes on a specific period of time, and hence you may eliminate any other major cause that may hamper shortly.

Histogram Vs. Pareto Charts

Remember, a Pareto is a type of histogram. There is no need to prioritize category in a histogram, and you will not find any cumulative curve. Here, you draw as per data and then analyze the peaks and find the problem. A histogram is just a frequency distribution on each bar with time.Difference between Pareto Charts and Histograms

Wrap Up

No doubt, Pareto chart analysis is a time-saving tool in Quality Management. As we have seen through the Pareto chart example that careful analysis can save tons of your time. This is the best tool when you are running out of time. As a project manager, you can use this tool to perform delay analysis on your project to make quick decisions.

FEATURED POSTS


Download Primavera P6
To download and install Primavera P6 was never that easy as nowadays. By following these steps…

Download Primavera P6

What is PMP?
What does PMP stand for? You are here as you just have heard about PMP, or you know a little already but have some …

What is PMP?

Stakeholer Engagement
A stakeholder is any individual, a group of people or an organization that can affect or be affected positively….

Stakeholer Engagement

Work Breakdown Structure
The heaviest fine is for drifting that is 20,000 for the first time, 40,000 SAR for second and 60,000 SAR for the third violation.

Work Breakdown Structure

Project Management
Project management is how you apply the knowledge, skills, tools, and techniques to get the project management …

Project Management

Gantt Chart
A Gantt chart is also known as bar chart represents a project plan by making each task into a bar and …

Gantt Chart

Planning Engineer
Planning Engineer is considered the right-hand of a Project Manager as he floats the information about project…

Planning Engineer

Team Development
Dr. Bruce W. Tuckman, a psychologist published a theory in 1965 called ‘Tuckman’s Stages of Group Development’.

Team Development


1 thought on “Pareto Chart”

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top