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:

PERCENTRANK({12,6,7,9,3,8},4) results in 0.066
PERCENTRANK({12,6,7,9,3,8},5) results in 0.133

end example]