MedCalc
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
working
Skip to main content
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

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