Forum Discussion
How to correct for the frequency when ranking
Tara,
See columns H and I in attached.
As for emails my impression that's just collection of addresses.
Was thinking the same about the emails, so this was my solution.
Don't think the above is the solution. With that formula [B4+C4/100) I only add C4/100 to the rank from column B4. That's not correcting for the frequency.
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?