Skip to main content

PERCENTILE.INC function

The PERCENTILE.INC function is one of the statistical functions. It is used to return the k-th percentile of values in a range, where k is in the range 0..1, inclusive.

Syntax​

PERCENTILE.INC(array, k)

The PERCENTILE.INC function has the following arguments:

ArgumentDescription
arrayThe selected range of cells for which you want to calculate the k-th percentile.
kThe percentile value, a numeric value greater than or equal to 0 but less than or equal to 1.

Notes​

How to apply the PERCENTILE.INC function.

Examples​

The figure below displays the result returned by the PERCENTILE.INC function.

PERCENTILE.INC Function