Explore BrainMass

Pareto Analysis of Data

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.

All Other 71
Checker 59
General 58
Service Level 55
Policy/Procedures 40
Price Marking 45
Product Quality 87
Product Request 105
Checkout Queue 33
Stock Condition 170

Solution Summary

A Pareto analysis of data laid out in Excel. Formulas are show.