C koi Pareto law?

Definition and application of the Pareto law (law as of 80/20 or ABC).

The Pareto principle, also known as Law 80/20 is a remarkable proportion highlighted by Vilfredo Pareto (1848-1923). He watched the early twentieth ^century that 20% of the Italian population owned 80% of national wealth, hence the name of the law 80-20 or 20-80.

This law reads as follows: "80% of effects are generated by only 20% of cases" or for those who prefer the complementary version (law 20/80), "20% of cases generate 80% of adverse ".

This proportion is remarkable in that it can focus its energy, its necessarily limited resources or time on a few fundamental causes that have a major impact, rather than get lost in the treatment of many causes for marginal effects . (The Anglo-Americans say "essential few, trivial many").

A digraph Pareto looks like this:

The method is as follows:   

• Identify the problem to solve.
• Make a data collection or use of existing data.
• Classify data into categories and provide a "Miscellaneous" category for categories with few elements.
• Total the data in each category and determine the percentages of the total.
• Classify these percentages decreasing value, the category "Miscellaneous" is still in last place.
• calculate the cumulative percentage
• determining a suitable scale to draw the graph.
• place the categories on the abscissa on the graph, starting with the largest
• plot the cumulative percentages
• distinguish three classes A, B and C which are distributed as follows:
  • Class A: items accumulating 80% of the observed effect
  • Class B: items accumulating the next 15%
  • Class C: items accumulating the remaining 5%

Example

Service indicators are Incident Management Informatiqes to red, the service is overloaded. Training activities will be planned. A Pareto chart can quickly view the topics of training

Data:

• Sort items by decreasing value depending on the amount of rework.
• To the summation results in the same order.
• Calculate percentages.
• Choose the scale. by reason of easier reading, the graph will fit into a square.
• Report items on the abscissa.
• Report values ​​in ordinates: quantity to the left and the cumulative percentages on the right.
• Plot the curve and determine the areas A, B and C.

Step 1: Table	Step 2: the diagram

Conclusion

The training must cover the installation of a printer, word processing.
This example is not perfect. To be most effective, the response time should have been taken into account.
In addition, the package default applications installed on each workstation is reviewing to avoid having to install applications thereafter.

Sources:

Download a tutorial to implement a Pareto chart in Excel without VBA.