QUARTILE function

QUARTILE(Array, Quart) QUARTILE(Array; Quart)


{ Number }

The unordered array of data.


Number or { Number }

0 to return the minimum value, 1 to return the value below which a quarter of values lie (25th percentile), 2 to return the median value (50th percentile), 3 to return the value below which three quarters of values lie (75th percentile) and 4 to return the maximum value.


Number or { Number }

A specified quartile in an array of numbers.

This function is a compatibility alias for QUARTILE.INC. Use QUARTILE.INC for new projects.