QUARTILE_EXC

QUARTILE_EXC(arg1, arg2) → { number }

Returns the quartile of a data set, based on percentile values from 0..1, exclusive.

Parameters:

Name Type Description
arg1 Array.<number> | ApiRange

The array or cell range of numeric values for which the quartile value will be returned.

arg2 number

The quartile value to return: 1st quartile = 1; median value = 2; 3rd quartile = 3.

Returns:

Type
number