Show menu

VPERCRANKR function

Description

VPERCRANKR(variable,group) returns the percentile rank of a value.

Example

VPERCRANKR function

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

Share on Facebook Share on Twitter

This site uses cookies to store information on your computer. More info...