Returns a percentile value from a data set.
Syntax:
PERCENTILE.EXC( data:Range or Array, k:Number )
Returns the (100×k)th percentile from the values in the data range of cells (or array).
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 Fireworkz 2.00.