Export (0) Print
Expand All
Expand Minimize

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 Added: Excel 2010

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

  • 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.

Show:
© 2014 Microsoft