PERCENTRANK

Syntax:

PERCENTRANK ( array , x [ , significance ] )

Description: Computes the rank of a value in a data set as a percentage of the data set.

Arguments:

Name

Type

Description

array

array, reference

array is the set of numerical data that defines relative standing.

x

number

The value for which the rank is to be computed. If x does not match one of the values in array, PERCENTRANK interpolates to return the correct percentage rank.

significance

number

The number of significant digits for the returned percentage value. If omitted, a value of 3 is used.

Return Type and Value: number – The rank of a value in a data set as a percentage of the data set.

However, if

  • array is empty, the return value is unspecified.

  • significance < 1, #NUM! is returned.

example: