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
Policy/Procedures: 40
Service Level: 55
General: 58
Checker: 59
All other: 71

© SolutionLibrary Inc. solutionlibary.com 9836dcf9d7 https://solutionlibrary.com/business/business-math/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-7fih

Solution Preview

...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 ...