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: