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
https://brainmass.com/business/business-math/pareto-analysis-the-80-20-rule-245329
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).