QUARTILE

Syntax:

QUARTILE ( array , result-category )

Description: Computes the quartile of a data set.

Arguments:

Name	Type	Description
array	array, reference	The set of numeric values for which the quartile value is to be computed.
result-category	number	When truncated to an integer, specifies which value is to be returned, as follows: Value Value Returned 0 Minimum value 1 First quartile (25th percentile) 2 Median value (50th percentile) 3 Third quartile (75th percentile) 4 Maximum value

 

Return Type and Value: number – The quartile of a data set.

However, if

• array is empty, the return value is unspecified.

• result-category < 0 or result-category > 4, #NUM! is returned.

[Example:

QUARTILE({1,2,4,7,8,9,10,12},1) results in 3.5

end example]