Forum Discussion
How to correct for the frequency when ranking
I have my file added to this message, was easier then emailing it and in that way other can look at is aswel. The numbers will change, I just want the formulas to work before I have my final data.
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: