Forum Discussion
Tara Smit
Oct 05, 2017Copper Contributor
How to correct for the frequency when ranking
Hi all, So I will have a database within a few weeks with the following filled in in the columns: - A: dataset number (ranging from 1 to somwhere around 25); - B: scores, of the scores that whe...
SergeiBaklan
Oct 06, 2017Diamond Contributor
Okay, i'll try. Could you please manually add endrank into the latest table to be sure in the desired result?
Tara Smit
Oct 06, 2017Copper Contributor
Here it is.
- Tara SmitOct 06, 2017Copper ContributorThankyou for all the help.
Will post within a few weeks / months what the result is on the real data. - SergeiBaklanOct 06, 2017Diamond Contributor
Great. Let see what it'll be on real data.
- Tara SmitOct 06, 2017Copper Contributor
I think this is the way it should be! I applied the formulas to the short example from previous post, and it gave the same results as what a manually entered.
- SergeiBaklanOct 06, 2017Diamond Contributor
Tara, not sure, but it looks like we shall rank score/frequency - higher score with less answers the better
I applied same logic to your file, please check