Probably a simple question. I am tracking a team's players donation ratio over various periods of time. Ratio is (IN) / (OUT). If I have multiple players with zero IN's, yet each with different amounts of OUT's, and I want to sort (rank) them by IN:OUT ratio, what is the best way to sort (rank) all of the players with a zero ratio? Am I off-base by simply adding 1 to all numerators of zero, and then calculating the ratio? Ultimate goal is to identify players with highest ratios. Will I lose accuracy in ranking when IN (or OUT) levels are extremely low, or conversely, extremely high? Simple example below (AdjustedRatio is numerator (IN) +1). TIA!
<tbody>
</tbody>
IN | OUT | TrueRatio | TR_Rank | AdjustedRatio | AR_Rank | |
Alpha1 | 0 | 863 | 0.00000 | 14 | 0.0012 | 16 |
Alpha2 | 0 | 51 | 0.00000 | 14 | 0.0196 | 13 |
Alpha3 | 0 | 128 | 0.00000 | 14 | 0.0078 | 15 |
Alpha4 | 5 | 500 | 0.01000 | 13 | 0.0120 | 14 |
Bravo1 | 78 | 259 | 0.30116 | 7 | 0.3050 | 7 |
Bravo2 | 15 | 383 | 0.03916 | 11 | 0.0418 | 11 |
Bravo3 | 8 | 202 | 0.03960 | 10 | 0.0446 | 10 |
Charlie1 | 65 | 270 | 0.24074 | 8 | 0.2444 | 8 |
Charlie2 | 15 | 383 | 0.03916 | 11 | 0.0418 | 11 |
Charlie3 | 139 | 708 | 0.19633 | 9 | 0.1977 | 9 |
Delta1 | 160 | 364 | 0.43956 | 5 | 0.4423 | 5 |
Delta2 | 139 | 424 | 0.32783 | 6 | 0.3302 | 6 |
Delta3 | 392 | 557 | 0.70377 | 3 | 0.7056 | 3 |
Echo1 | 1,620 | 555 | 2.91892 | 2 | 2.9207 | 2 |
Echo2 | 3,441 | 220 | 15.64091 | 1 | 15.6455 | 1 |
Echo3 | 392 | 557 | 0.70377 | 3 | 0.7056 | 3 |
<tbody>
</tbody>
Last edited: