Originally Posted by
cross777 I have the following problem
I have 3 options with different ranks:
A=3
B=0
C=0
I would like to normalize them to 0..1 scale.
The problem is that actually the value 0 is "better" than value 3, so I would reverse the values beforehand and use 1/A, 1/B and 1/C instead.
So the normalized weigh for A on the 0..1 scale would be:
(1/A)/((1/A)+(1/B)+(1/C))
For B:
(1/B)/((1/A)+(1/B)+(1/C))
For C:
(1/C)/((1/A)+(1/B)+(1/C))
However if A, B or C are zeros there can not be any reverse value. How to normalize in this case?
Thank you.