The Pareto Principle

Interested in a free 25+ eBook on the 7 Wastes? Please DOWNLOAD HERE.

The Pareto Principle was named after an Italian economist who discovered that 80% of the wealth in Europe was concentrated in 20% of the population. This discovery is also known as the 80/20 rule or the Law of the Vital Few. The Pareto Principle is a phenomenon that finds application in many places, such as software engineering, quality, manufacturing, word-of-mouth marketing, human resources, and government; the 80/20 rule was also popularized by the book “The Mckinsey Way” as a principle by which Mckinsey consultants follow to solve client problems.

A result of the Pareto Principle is the Pareto Chart. The Pareto Chart is used to graphically summarize and display the relative importance of the differences between groups of data, or to visually represent the Vital Few versus the Trivial Many.

You can create a Pareto Chart in any statistical tool such as GNU Plot, MatLab, Mathematica, Stata, SAS, or MiniTab. For our example, I’ll show how to create a Pareto Chart in Excel.

To create a Pareto Chart in Excel, setup a spreadsheet such that the first column contains the categories of your data, the second columns, percentages of each category, and the third column cumulative percentages of each category. The example below represents data collected on the number of citations issued by police for various violations (Category) in a particular intersection. Overall, 300 tickets were issued for various traffic violations. The percentage of tickets issued for each violation and the cumulative percentage of tickets issued were calculated and entered into an Excel spreadsheet. If the data is not sorted from high to low, then sort the data from the highest percentage to the lowest. The sequence for sorting is “Data”, “Sort”, “Percent”, “Descending”.

Then, highlight “Categories”, “Percent”, and “Cumulative Percent” Columns. Go to the Chart Wizard, select “Custom Types” and select “Line-Columns”.

In my line of work, I use the Pareto Principle all the time. As an example, at Amazon, I used the Pareto Principle to seperate the value-added time in a process versus the non-value added time. This approach would help direct efforts on where to spend our time to improve a process. The Pareto Chart is a nice and easy way to visually display the data and direct efforts.

In software engineering, to avoid feature creep and to remain focused on the right features, it’s important to use the Pareto Principle to determine which 20% of the features will satisfy at least 80% of the users. In my experience, not enough software organizations use this principle in their software development.

In Human Resources, roughly 20% of the people produce 80% of the results.

In Government, roughly 20% of the group are influential and the other 80% are peripheral.

In word-of-mouth marketing or marketing in general, roughly 20% are the influential, “sneezer” types and the remaining 80% are the slow adopters or followers.

In Project Management, if a schedule slips or a milestone is not met, it must be measured against the 80/20 rule and then quickly recover the project and re-focus on the vital 20%; or, make sure that the milestone kept are part of the vital 20% and if a milestone under the trivial 80% slips, then the team can afford to do that and not freak out that the project will fail.

To apply the Pareto Principle more broadly, as a general rule, it’s important to remember that only 20% of our daily activities matter. Or, put another way, let us focus our energies and time on the 20% that will make an impact on the other 80%.

search terms for this article:

pareto principle chart, pareto, developer of pareto chart, pareto lean, pareto xls, pareto principle examples, stata pareto chart, pareto rule examples, milestone slip chart excel, pareto principle in software testing, supply management pareto principle, weighted pareto analysis, what is pareto hypothesis, value added and non value added examples, pareto principle in management interesting examples, lean pareto, how pareto analysis in excel spreadsheet, pareto chart for toyota, sigma xls, pareto software development, pareto principle software development, pareto principle lean six sigma xls, pareto rule for sw, Pareto Principles, pareto principle in testing, pareto principle used in projects, pareto principle traffic, pareto principle in human resources, pareto principle in excel, pareto diagram toyota, pareto diagrams for software testing, pareto example stata, pareto graph for human resources managers, pareto diagram example of many groups, pareto lean next steps, pareto lean six sigma, pareto principe, pareto principle and chart, pareto principle diagram in principle of management, pareto principle example, pareto efikasnost alokacije, pareto principle features, pareto principle for hr, pareto diagram for marketing, pareto split, stata pareto diagram, stratification pareto, the PARETO phenomenon in Operation management, the pareto principle and design, The Pareto principle graph, time management pareto diagram, toyota of longview, toyota overproduction pareto diagram, toyota pareto, waste analysis mckinsey way, weighted pareto chart for root cause analysis, what is a pareto chart lean six sigma, what is pareto in testing, what is pareto principle in software testing, stata graphs pareto, stata graphs, slip chart example, pareto theory in operations management, paretos principle in toyota, percentage not display in pareto in Minitab, pereto chart of toyota, principle use of pareto diagram, principles and process of pareto analysis, principles of a pareto diagram, principles of operation analysis chart, problem solving test mckinsey, queing theory pareto, sigma flow exemple, significance of cumilitive percentage in pareto chart, six features why pareto is not, six sigma pareto seperate the critical few from the trivial many, whats the pareto phenomenon ?, pareto charts relation to pareto principle, 20 80 rule by pareto in software testing, excell pareto rule, exemple diagrama pareto excel, exemple diagramme pareto plasturgie, feature usage in software 20 80, grafica pareto minitab, how pareto chart in market place, how to construct a pareto chart in minitab, how to create 80-20 chart in excel\], how to display data in minitab pareto, how to do a pareto in minitab, how to do pareto chart in healthcare supply chain, how to get an 80/20 rule with a lot of data excel data, how to make pareto chart in excel, how to use pareto chart in minitab, how to use pareto in call center, excel pareto sortieren, excel pareto, excel 2007 pareto-diagramm erstellen, 20 80 rule lein 6 sigma, 7 wastes spreadsheet, 80 20 pareto principle in testing

Related Articles: