WorksheetFunction.Percentile Method
| Excel Developer Reference |
Returns the k-th percentile of values in a range. You can use this function to establish a threshold of acceptance. For example, you can decide to examine candidates who score above the 90th percentile.
Syntax
expression.Percentile(Arg1, Arg2)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Arg1 | Required | Variant | Array - the array or range of data that defines relative standing. |
| Arg2 | Required | Double | K - the percentile value in the range 0..1, inclusive. |
Return Value
Double
Remarks
- If array is empty or contains more than 8,191 data points, PERCENTILE returns the #NUM! error value.
- If k is nonnumeric, PERCENTILE returns the #VALUE! error value.
- If k is < 0 or if k > 1, PERCENTILE returns the #NUM! error value.
- If k is not a multiple of 1/(n - 1), PERCENTILE interpolates to determine the value at the k-th percentile.
See Also