top

Search

Project Management Tutorial

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.Pareto charts: Helps focus attention on the most critical issues. Prioritizes potential cause of the problem. Helps identify the critical few from the uncritical many.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 hotelOccurrences% CountHouse Keeping3244Telephone34Air-conditioning68Noise46Check-in Delay811Restaurant2027Total73100We 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 hoteOccurrences% CountCumulative %House Keeping324444Restaurant202771Check-in Delay81182Air-conditioning6890Noise4696Telephone34100Total73100100We can now create a Pareto Chart (which is an ordered histogram) from the above prioritized data as below.ConclusionPareto 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.
logo

Project Management Tutorial

Pareto Chart Tool

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.

Pareto charts: 

  • Helps focus attention on the most critical issues.
  •  Prioritizes potential cause of the problem.
  •  Helps identify the critical few from the uncritical many.

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 hotelOccurrences% Count
House Keeping3244
Telephone34
Air-conditioning68
Noise46
Check-in Delay811
Restaurant2027
Total73100

We can create a visual histogram depicting the occurrences of various complaint types as below in excel.Visual histogram depicting the occurrencesWe 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 hoteOccurrences% CountCumulative %
House Keeping324444
Restaurant202771
Check-in Delay81182
Air-conditioning6890
Noise4696
Telephone34100
Total73100100

We can now create a Pareto Chart (which is an ordered histogram) from the above prioritized data as below.

Pareto chart in project management

Conclusion

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.

Leave a Reply

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

Comments

Myrah keya

Thank you very much for this article. It was useful to me.

Fikile

hi Very helpful indeed I need assistance on PM

Dan Addams

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.

Amanuel Watesso

good article. Well explained!

LELINA MWEEMBA

Well explained. Thank you so much. Continue educating us.

Suggested Tutorials

PRINCE2 Tutorial [Video]

PRINCE2 Tutorial [Video]

USEFUL LINKS