QUARTILE
Description
Returns the quartile of the specified list of values. The specified values must be numeric;
if a unit is included as part of a number, the function ignores it.
Syntax
QUARTILE(
array
,
quart
)
- array: The list of values to calculate the quartile for.
- quart: The quartile to calculate. 1 = 25th percentile; 2 = 50th percentile; 3 = 75th percentile; 4 = 100th percentile (the function returns the maximum value). Specifying 0 causes the function to return the minimum value.
Example
Formula | Result |
|---|---|
=QUARTILE({55,91,11},2) | 55 |