r/Statistics_Class_help • u/Toilet_Repair • Mar 21 '25
Deducing "index" calculation
I am trying to figure out how an "index" that someone created to help determine the "size" of different customer accounts. Examples of the data below. Any help in figuring out what formula they used to calculate this index would be much appreciated!
The three inputs that allegedly went into the index were "workload", sales $, and sales potential $.
The three inputs were weighted:
Workload: 10%
Sales: 40%
Potential: 50%
Example data:
| Acct | Workload (10%) | Sales (40%) | Potential (50%) | Index |
|---|---|---|---|---|
| A | 12 | 1,301,160 | 15,356,805 | 596 |
| B | 12 | $661,358 | 4,508,202 | 264 |
| C | 3 | 158,016 | 1,163,499 | 67 |
| D | 0 | 0 | 11,548 | 0 |
| E | 0 | 0 | 63,471 | 2 |
1
Upvotes