Pareto chart is one of the most powerful tools used in problem-solving. When we are saddled with many things, it is important for us to prioritize. Pareto chart is used extensively in quality management to prioritize the various root causes and problems. This helps in focusing on eliminating the critical few. Pareto chart and technique is based on Pareto Law, which says that 80% of the problems are caused by 20% of the root causes. We should not be channelizing our efforts into trivial things. A pareto chart is an ordered histogram providing a visual representation of the findings.
We can take an example to understand how Pareto law is applied and how Pareto chart is created to identify the critical root causes of problems we are facing.
Let us examine the number of complaints which are received at a hotel which offers both lodging and boarding. The management has collected the various complaints and the number of times a particular type of complaint has occurred. Below is the sample data for the same.
|Complaints in a hotel||Occurrences||% Count|
We can create a visual histogram depicting the occurrences of various complaint types as below in excel.We can then create a Pareto Chart by prioritizing the occurrences of different complaints so that we can focus on the most frequently occurring complaints. The data is sorted in a descending order of occurrences as below.
|Complaints in a hote||Occurrences||% Count||Cumulative %|
We can now create a Pareto Chart (which is an ordered histogram) from the above prioritized data as below.
Pareto chart is a simple yet a very effective chart which allows prioritizing various elements and a visual representation of the findings. Pareto charts are easily created using Excel. Learn more about Pareto chart with our PMP prep course.
Thank you very much for this article. It was useful to me.
hi Very helpful indeed I need assistance on PM
This post made an excellent point that one of the benefits of using an ERP system is that it helps monitor and track revenue. I do agree that as a business, this is important.
good article. Well explained!
Well explained. Thank you so much. Continue educating us.