Ranking (statistics)
In statistics, ranking is the data transformation in which numerical or ordinal values are replaced by their rank when the data are sorted. For example, the numerical data 3.4, 5.1, 2.6, 7.3 are observed, the ranks of these data items would be 2, 3, 1 and 4 respectively. For example, the ordinal data hot, cold, warm would be replaced by 3, 1, 2. In these examples, the ranks are assigned to values in ascending order. (In some other cases, descending ranks are used.) Ranks are related to the indexed list of order statistics, which consists of the original dataset rearranged into ascending order.
Use for testing
Some kinds of statistical tests employ calculations based on ranks. Examples include:
- Friedman test
- Kruskal–Wallis test
- Rank products
- Spearman's rank correlation coefficient
- Wilcoxon rank-sum test
- Wilcoxon signed-rank test
- Van der Waerden test
The distribution of values in decreasing order of rank is often of interest when values vary widely in scale; this is the rank-size distribution (or rank-frequency distribution), for example for city sizes or word frequencies. These often follow a power law.
Some ranks can have non-integer values for tied data values. For example, when there is an even number of copies of the same data value, the above described fractional statistical rank of the tied data ends in ½. Percentile rank is another type of statistical ranking.
Computation
Microsoft Excel provides two ranking functions, the Rank.EQ function which assigns competition ranks ("1224") and the Rank.AVG function which assigns fractional ranks ("1 2.5 2.5 4") as described above. The functions have the order argument,[1] which is by default is set to descending, i.e. the largest number will have a rank 1. This is generally uncommon for statistics where the ranking is usually in ascending order, where the smallest number has a rank 1.
Comparison of rankings
A rank correlation can be used to compare two rankings for the same set of objects. For example, Spearman's rank correlation coefficient is useful to measure the statistical dependence between the rankings of athletes in two tournaments. And the Kendall rank correlation coefficient is another approach. Alternatively, intersection/overlap-based approaches offer additional flexibility. One example is the "Rank–rank hypergeometric overlap" approach,[2] which is designed to compare ranking of the genes that are at the "top" of two ordered lists of differentially expressed genes. A similar approach is taken by the "Rank Biased Overlap (RBO)",[3] which also implements an adjustable probability, p, to customize the weight assigned at a desired depth of ranking. These approaches have the advantages of addressing disjoint sets, sets of different sizes, and top-weightedness (taking into account the absolute ranking position, which may be ignored in standard non-weighted rank correlation approaches).
Definition
Let be a set of random variables. By sorting them into order, we have defined their order statistics[4]
If all the values are unique, the rank of variable number is the unique solution to the equation . In the presence of ties, we may either use a midrank (corresponding to the "Fractional Rank" defined above), defined as the average of all indices such that , or the uprank (corresponding to the "Modified Competition Ranking" above) defined by .
References
- "Excel RANK.AVG Help". Office Support. Microsoft. Retrieved 21 January 2021.
- Plaisier, Seema B.; Taschereau, Richard; Wong, Justin A.; Graeber, Thomas G. (September 2010). "Rank–rank hypergeometric overlap: identification of statistically significant overlap between gene-expression signatures". Nucleic Acids Research. 38 (17): e169. doi:10.1093/nar/gkq636. PMC 2943622. PMID 20660011.
- Webber, William; Moffat, Alistair; Zobel, Justin (November 2010). "A Similarity Measure for Indefinite Rankings". ACM Transactions on Information Systems. 28 (4): 1–38. doi:10.1145/1852102.1852106. S2CID 16050561.
- Vaart, A. W. van der (1998). Asymptotic statistics. Cambridge, UK: Cambridge University Press. ISBN 9780521784504.