QUARTILE

Returns the quartile of a data set. Quartiles divide the data set into four equal parts.

Parameter List

Syntax
QUARTILE(rangequart)
range

The array or range of data to consider. For example: A1:A100.

quart

The quartile to return. 0 is min, 1 is 1st quartile (25% percentile), 2 is 2nd (50%), 3 is 3rd (75%), 4 is max.

Examples

QUARTILE(A1:A5, 2) returns 30, the 2nd quartile of the range A1:A5.