PERCENTILE
Syntax:
PERCENTILE ( array , k )
Description: Computes the kth percentile of a set of values in a range.
Arguments:
Name |
Type |
Description |
---|---|---|
array |
array, reference |
The set of numerical data that defines relative standing. |
k |
number |
The percentile value in the range 0–1, inclusive. If k is not a multiple of 1/(n - 1), |
Return Type and Value: number – The kth percentile of a set of values in a range.
However, if
array is empty, the return value is unspecified.
k is < 0 or k > 1,
#NUM!
is returned.
example: