I want to use the rank-function with the best treatment of ties (called the ‘mean’ option). This option keeps the MCE value of the tie-variable equal to (2*range+1)/2.I cannot find if this option is available from the documentation. Hs anybody an easy solution?
Dick
Really needed should be tie-breaking only if there are accompanying data, and a kind of sort is intended.
Basically you need to disambiguate the rank by one or more additional criteria.
For sorting based on the resulting ranks, you may omit additional data, and choose whether you want to get the sort “stable” or “antistable”. Done in a spreadsheet the disambiguation can then use (mostly) the row number as the second criterion.
To include this disambiguation with the original ranking isn’t always simple (and sometimes not clearly applicable).
Therefore you may better use a helper column: First the ranking accepting ties, then the disambiguated ranks.
This is demonstrated in the example:
disambiguatedRanking.ods (105.0 KB)