VPERCRANKR function

Description

VPERCRANKR(variable,group) returns the percentile rank of a value. An optional filter can be specified.

Example

In cell C3, the function VPERCRANKR(variable,group) returns 50 because the value 15 for Variable (in column A) is the median (50th percentile) of the Variable in group 1.

In cell C5, the function returns 90 because the value 25 for Variable is the 90th percentile of the Variable in group 1.

Note

This function calculates a statistic on a variable. Be careful when you use this function in cells of the columns that correspond to the variable, because this actually adds a value to the variable which can lead to unexpected and faulty results. You can exclude the cell to avoid this.

Related functions

• Statistical spreadsheet functions on variables