PERCENTILE.EXC

Returns a percentile value from a data set.

Syntax:

PERCENTILE.EXC(data:array|range, k:number)

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

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

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

If kn/(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.

Revisions:

This function was added in 2.00.