Pareto principle was introduced by Italian Economist Vilfredo Pareto. He stated that 80% of the effects are caused by 20% of the causes. So if we closely monitor and solve 20% of the causes. It will significantly improves the affected area and you will see good results.
For Example: 80% of the revenue gets generated by 20% of the clients
While doing research Mr. Pareto found that 20% of land in Italy was occupied by 80% of the population. He carried out this survey to other areas and got same results
This rule is also well known as 80/20 rule across the globe and is mostly being used to find the causes which is impacting business or producing defective products/services
Hence Pareto chart is a graphical representation of Pareto Principle
Pareto Chart studies the frequency distribution and advise you the most impacted/affected areas. So you should use Pareto Chart when:
Here are few steps to collect data before you start preparing your Pareto Chart in Excel:
Here I collated the Complaints data from one of the Courier Company survey and will create Pareto Chart for them. Lets follow the steps now:
So here your Pareto chart is ready. This will help you to showcase the major pain areas or impacted areas in visual display
Now if you want to make this chart more appealing and visual. Then you can do this by learning tricks about formatting charts.
Hope you liked this article. Please comment below for any questions and for your feedback about this tutorial.
Follow us by Subscribe Us option for new updates
MAX function is used to get the largest number in range or list of values. MAX function has one required argument i.e. number1
How to find duplicates in excel? Hope you read the post “Remove Duplicates in Excel”. Now I am going to explain how you can find these duplicates. There are multiple methods available to Find and…
Lock Cells to avoid editing, Hide Formulas Sometimes you create amazing projects, dashboards however people can make mistakes and edit the calculations, formats what you have made. Still you can protect the sheets, workbooks and…
In this guide, you will learn how to use the NPV function in Excel to calculate the net present value of an investment and how to avoid common mistakes when using NPV in Excel.
When creating a formula in Excel, many people get confused by the $ symbol in cell references. But it’s actually very simple. The dollar sign in an Excel cell reference tells Excel whether to keep the reference the same or allow it to change when you copy the formula to other cells. This guide will explain how it works and why it’s helpful.
Understanding Excel cell references is really important. Knowing the difference between absolute, relative, and mixed references will help you get the most out of Excel formulas and functions.
AVERAGEIF function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.
I really liked this article. Well drafted. Thanks for the help 🙂