A Pareto analysis is performed in Excel to determine the percentage of total complaints represented by the most common categories. Pareto analysis is a statistical technique in decision making that is used for selection of a limited number of tasks that produce significant overall effect (Wikipedia).
Construct a Pareto analysis of the data and determine the percentage of total complaints represented by the two most common categories.
Over a 6 mo period:
Stock Condition: 170
Checkout Queue: 33
Product request: 105
Product Quality: 87
Price Marking: 45
Service Level: 55
All other: 71
...ection of a limited number of tasks that produce significant overall effect. It uses the Pareto principle - the idea that by doing 20% of work you can generate 80% of the advantage of doing the entire job. Or in terms of quality improvement, a large majority of problems (80%) are produced by a few key causes (20%).
Steps to identify the important causes ...