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, |
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: