Rank

This Analytics Edge wizard is used to convert the selected column into a number representing either the rank order or it’s percentile, decile or quartile position.

It is typically used to segment data or to establish a normalized value for further analysis, such as using Filter and Match to obtain details for the top 10%.

Pick Columns – select the columns by position (column letter) or By Name.

Change Column Into – select a ranking option to use.

Rank – convert the value in the selected columns to a rank number starting at 1 and counting up. Duplicate rows will have the same value, and the next number will be skipped.

Percentile – split the values in the column into 100 ordered groups and change the value to a number between 1 and 100.

Decile – split the values in the column into 10 ordered groups and change the value to a number between 1 and 10.

Quartile – split the values in the column into 4 ordered groups and change the value to a number between 1 and 4.

Order – select whether larger values will rank higher (e.g. counting up), or whether larger values will rank lower (e.g. top 10).