WorksheetFunction.Percentile_Inc Method (Excel)
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 examine candidates who score above the 90th percentile.
Version Information
추가된 버전: Excel 2010
Syntax
식 .Percentile_Inc(Arg1, Arg2)
식 A variable that represents a WorksheetFunction object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Arg1 |
필수 |
Variant |
Array - The array or range of data that defines relative standing. |
Arg2 |
필수 |
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.