QUARTILE

Name

QUARTILE —
QUARTILE(array,quart)

Description

QUARTILE function returns the quartile of the given data points.

If quart is equal to: QUARTILE returns:

0 the smallest value of @array.

1 the first quartile

2 the second quartile

3 the third quartile

4 the largest value of @array.

If @array is empty, QUARTILE returns #NUM! error. If @quart < 0 or @quart > 4, QUARTILE returns #NUM! error. If @quart is not an integer, it is truncated.

See also

LARGE , MAX , MEDIAN , MIN , PERCENTILE , SMALL