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 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.
Revisions:
This function was added in 2.00.