QUARTILE_INC

QUARTILE_INC(arg1, arg2) → { number }

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

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: minimum value = 0; 1st quartile = 1; median value = 2; 3rd quartile = 3; maximum value = 4.

Returns:

Type
number