次の方法で共有


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

Version Added: Excel 2010

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.

See Also

Concepts

WorksheetFunction Object Members

WorksheetFunction Object