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:

Argument	Description
array	The selected range of cells for which you want to calculate the k-th percentile.
k	The 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.