I'm trying to calculate the relative ranking of a number of sellers using the following values:
- Total Product Sales
- Total Items Sold
- Total Product Visits
I want to be able to assign a weighting to each number to reflect how important I think each value is, but since the values aren't similar, how do I adjust for that?
For example, say I decide that the relative weighting should be something like this:
- Total Product Sales (5)
- Total Items Sold (3)
- Total Product Visits (1)
and the corresponding values are:
$10,000
15
450
I'm not sure how to make this work so that I can compare one seller to another. Please note that this is not a homework problem, but a situation in my business that I would like to get right.
Thanks for any pointers!
- Total Product Sales
- Total Items Sold
- Total Product Visits
I want to be able to assign a weighting to each number to reflect how important I think each value is, but since the values aren't similar, how do I adjust for that?
For example, say I decide that the relative weighting should be something like this:
- Total Product Sales (5)
- Total Items Sold (3)
- Total Product Visits (1)
and the corresponding values are:
$10,000
15
450
I'm not sure how to make this work so that I can compare one seller to another. Please note that this is not a homework problem, but a situation in my business that I would like to get right.
Thanks for any pointers!