Description

Find the rank of a given value within a list of values as a percentage of the number of values in the list.

Type

NUMERIC

Arguments

Type

Meaning

1

LIST

a list of numeric values

2

NUMERIC

the value for which to determine the rank

Evaluation

This function provides a measure of the relative standing of a value within a data set.

If the value whose percent rank is being determined, x, is one of the input values, then the return value is computed by:

Otherwise, interpolation is used to combine the percent ranks for the closest data points on either size of x.

If the input values are viewed as a sample from some distribution, then PercentRank can be viewed as a smooth estimate of the empirical cumulative distribution function.

Comments

Note, this function produces the same results as Excel’s PercentRank function.