WorksheetFunction.Percentile_Inc method (Excel)
Returns the k-th percentile of values in a range. Use this function to establish a threshold of acceptance. For example, you can examine candidates who score above the 90th percentile.
Syntax
expression.Percentile_Inc (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, Percentile_Inc returns the #NUM! error value.
If k is nonnumeric, Percentile_Inc returns the #VALUE! error value.
If k is < 0 or if k > 1, Percentile_Inc returns the #NUM! error value.
If k is not a multiple of 1/(n - 1), Percentile_Inc interpolates to determine the value at the k-th percentile.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.