KDLadage
Explorer
...hmmm another thought...
What about something like this:
(MEAN * MODE) / 3
Mean would have a mid-point of 3.
Mode would also have a mid-point of 3.
Thus, a product with a mean and mode of 3 each would have a rating of 3.00
However, the use of MODE in the equation would keep a single outlier from shifting the equation too much. In the case of a product with multiple modes, the average of the modes would be used...
What about something like this:
(MEAN * MODE) / 3
Mean would have a mid-point of 3.
Mode would also have a mid-point of 3.
Thus, a product with a mean and mode of 3 each would have a rating of 3.00
However, the use of MODE in the equation would keep a single outlier from shifting the equation too much. In the case of a product with multiple modes, the average of the modes would be used...