PERCENTILE_EXC

PERCENTILE_EXC(arg1, arg2) → { number }

Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.

Parameters:

Name Type Description
arg1 Array.<number> | ApiRange

The array or range of data that defines relative standing.

arg2 number

The percentile value that is greater than 0 but less than 1.

Returns:

Type
number