PERCENTILE.EXC
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive
Syntax
PERCENTILE.EXC(array, k)
Parameters
- array: Required. The array or range of data that defines relative standing
- k: Required. The percentile value between 0 and 1, exclusive
Example
=PERCENTILE.EXC(A1:A10, 0.25)