Pareto – 80/20 Rule

3.55K viewsFormulas and Functions

Dear all,
What is the best practice for calculation Pareto (80/20 Rule) with matrix in appendix.
Note that several amounts are the same.
Thanks for your help.

Answered question



Hi all!
Denis, look at my version of the model on your data. Since your sales data are not normalized, I have cut off negative, zero and very small sales values ​​by means of the parameter: the lower sales bound (LSB). Try these LSB‘s values: ​​1000, 5000, 10000, 15000, – and look at the changes in the chart and statistics. The main question of the model is: how many customers with positive sales give a total of 80% of revenue.
The Pareto Chart is based on a special matrix.
For convenience, I’ve created two perspectives, switch between them.
Good luck.

Answered question
You are viewing 1 out of 4 answers, click here to view all answers.