QUARTILE function
QUARTILE(Array,
Quart) QUARTILE(Array;
Quart)
Array
{ Number }
The unordered array of data.
Quart
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.
Returns
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.