PERCENTILE.EXC Function

The PERCENTILE.EXC 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, exclusive.

Syntax

PERCENTILE.EXC(array, k)

The PERCENTILE.EXC 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 0 but less than 1.

Notes

How to apply the PERCENTILE.EXC function.

Examples

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