Share
Explore BrainMass

Pareto analysis - The 80-20 Rule

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

Solution Preview

Dear Student,

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.

Thanks.

Pareto analysis is a statistical technique in decision making that is used for ...

Solution Summary

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

$2.19