Ranking Description
Various methods are used to rank data. We have chosen three which should meet the needs of most users. The data can be downloaded (see the CSV option) by the user for use of alternate ranking methods, if needed.
The first method in MRCC ranking products is “Standard Ranking” where ties are assigned the same rank and then subsequent ranks are skipped so that the next rank is unaffected by the ties (or lack of ties) ahead of it. The second method is “Dense Ranking” where ties are assigned the same rank but no ranks are skipped which can be thought of as ranking the distinct values rather than the occurrence of each value. The third method is “Ordinal Ranking” where ties are ignored and each value gets a unique rank value which is useful for calculations of medians and other percentiles (quartiles, sextiles, …).
A simple and short example is shown below:
| Year | Value | Standard Rank | Dense Rank | Ordinal Rank |
|---|---|---|---|---|
| 2008 | 0.43 | 1 | 1 | 1 |
| 2010 | 0.27 | 2 | 2 | 2 |
| 2003 | 0.12 | 3 | 3 | 3 |
| 2009 | 0.12 | 3 | 3 | 4 |
| 2012 | 0.03 | 5 | 4 | 5 |
| 2001 | 0.01 | 6 | 5 | 6 |
| 2002 | 0.01 | 6 | 5 | 7 |
| 2007 | 0.01 | 6 | 5 | 8 |
| 2011 | T | 9 | 6 | 9 |
| 2014 | T | 9 | 6 | 10 |
| 2004 | 0.00 | 11 | 7 | 11 |
| 2005 | 0.00 | 11 | 7 | 12 |
| 2006 | 0.00 | 11 | 7 | 13 |
| 2013 | 0.00 | 11 | 7 | 14 |