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
There are many internet sites that will show you step by step method of Pareto analysis in detail. Here I am providing you the information from Wikipedia. I am also showing you the analysis in Excel. Please let me know if you need anything else.
Pareto analysis is a statistical technique in decision making that is used for ...
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).