[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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. |
|
number |
The percentile value in the range 0–1, inclusive. If k is not a multiple of 1/(n - 1), PERCENTILE interpolates to determine the value at the kth percentile. |
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:
PERCENTILE({1,3,2,4},0.3) results in 1.9
PERCENTILE({1,3,2,4},0.75) results in 3.25
end example]