PERCENTILE.EXC
Description
Returns the kth percentile for the specified list of values and value of k.
Syntax
PERCENTILE.EXC(
array1
,
k
)
- array1: The list of values to calculate the kth percentile for. Similar to PERCENTILE() and PERCENTILE.INC(), but k must be in the range 0 to 1, exclusive.
- k: The percentile value, where 0 < k < 1.