The Excel function: QUARTILE
Syntax
QUARTILE(array,quart)
The QUARTILE function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):
- Array Required. The array or cell range of numeric values for which you want the quartile value.
- Quart Required. Indicates which value to return.
| If quart equals | QUARTILE returns |
|---|---|
| 0 | Minimum value |
| 1 | First quartile (25th percentile) |
| 2 | Median value (50th percentile) |
| 3 | Third quartile (75th percentile) |
| 4 | Maximum value |