PERCENTILE.EXC

Returns a percentile value from a data set.

Syntax:

PERCENTILE.EXC(array, k:number)

Returns the (100*k)th percentile from the values in the array or range of cells.

k must be a decimal fraction in the range (0.0,1.0) (i.e. exclusive).

Where k ≤ 1/(N+1) the minimum value will be returned (here N is the number of values).

Where k ≥ N/(N+1) the maximum value will be returned.

This behaviour is as recommended by the default NIST method for calculating percentiles. Some other spreadsheets would give an error in these cases.

Added in 2.00.