Below is a table of data collected over a six-month period in a local grocery store. Construct a Pareto analysis of the data and determine the percentage of total complaints represented by the two most common categories.
Stock Condition 170
Product Request 105
Product Quality 87
All other 71
Service Level 55
Price Marking 45
Checkout Queue 33
Step-by-step Guide in Pareto Chart construction.
1. Arrange the data from highest to lowest.
2. Compute for the cumulative data and ...
The solution contains a spreadsheet file utilizing a Pareto Chart in identifying complaints that need to be prioritized.