QUARTILE

QUARTILE the k-th quartile of the data points

Synopsis

QUARTILE(array,quart)

Arguments

array: data points

quart: a number from 0 to 4, indicating which quartile to calculate

Note

If array is empty, this function returns a #NUM! error. If quart < 0 or quart > 4, this function returns a #NUM! error. If quart = 0, the smallest value of array to be returned. If quart is not an integer, it is truncated.

Microsoft Excel Compatibility

This function is Excel compatible.

See also

LARGE, MAX, MEDIAN, MIN, PERCENTILE, SMALL.