QUARTILE(quart, array)

The QUARTILE function calculates the quartile of an array or range of numbers.

quart is either 0, 1, 2, 3 or 4, and represents either the zero (minimum), 25th, 50th (median), 75th or 100th (maximum) percentile respectively.

For example, the 3rd quartile of a data set {12, 9, 11, 7, 4, 15} is given using the formula:

QUARTILE(3, {12, 9, 11, 7, 4, 15})

which returns 11.75. This is equivalent to using the Percentile function (see PERCENTILE):

PERCENTILE(75%, {12, 9, 11, 7, 4, 15})

Note that using quart = 0, 2, or 4 has the same effect as using the functions MIN, MEDIAN or MAX respectively.

See:

MIN

MEDIAN

MAX

Other statistical functions