PERCENTRANK(x, array)

The PERCENTRANK function calculates the percentage rank of a number in a set of numbers.

The percent rank of a value is a measure of its standing in relation to a set of values. It is always a number from 0 to 1 inclusive. x is the value for which the percentage rank is sought in comparison to the set of numbers in an array or range.

For example,

PERCENTRANK(2, {0, 1, 2, 3, 4})

returns 0.5

PERCENTRANK(2, {1, 2, 3, 4})

returns 0.333333.

See also:

Other statistical functions