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: