Forum Discussion
How to correct for the frequency when ranking
Hi Tara,
Perhaps i didn't understand the logic, let me to clarify. Assume we have two values for score repeated several times, standard rank for them will be
Let add frequency for each record. My understanding - records with score 12 instead of one rank 1 will have two ranks depends on frequency, same for records with next score
Above samples are without any formulas, to illustrate what we'd like to receive. Could you please update it adding into the NewRank what shall be an answer.
Part of the second image is right. The 15 - 4 - 3 row scored higher, what means that this would be rank 1. Because, for the frequency, it had the lowest score. I believe it has to be this:
Tara, thank you. So i didn't understand the logic correctly.
So , the lowest frequency (4) has the lowest rank, if the frequency is the same lower rank has the record with lower score. Correct?
No problem!
Exactly, that's correct. The lowest score has the lowest rank. I'm getting confused all the time by myself, so I have this as an example:
A or D has to have the lowest rank, because it always gets "1" or "2", where the B/C gets also "2" or "3".
C should be the highest rank (4), because it has "3" four out of five times and one "1", which is relatively less high ranking than B, with "3" from one out of three times.
Not good at this at all, that's why I needed some help.
Okay, i'll try. Could you please manually add endrank into the latest table to be sure in the desired result?