XLSTAT - Coding by Ranks
How to use coding by rank
This tool is used to recode a table with n observations and p quantitative variables into a table containing ranks, the ranks being determined variable by variable.
Coding in ranks lets you convert a table of continuous quantitative variables into discrete quantitative variables if only the order relationship is relevant and not the values themselves.
XLSTAT options for coding by ranks
Two strategies are possible for taking tied values into account: either they are assigned to the mean rank or they are assigned to the lowest rank of the tied values.
This analysis is available in the XLStat-Basic addin for Microsoft Excel™