QUARTILE functions are used to find the various quartiles of a data set. A quartile is just a quantile.
Purpose of Excel QUARTILE Function
Get quartile of a set
Return value
Returns the quartile of a data set.
Syntax
=QUARTILE(array,quart)
Arguments
| Arguments | Description | Remarks |
| array | The range for which you need quartile value. | Mandatory |
| quart | Indicates which value to get. | Mandatory |
Usage notes
- It can be used as a worksheet function.
- It returns a numeric value.
- It was first introduced in Excel 2000, and is now available in all subsequent versions of excel.
- If the value of Quartile parameter is greater than 4 or less than 0 the function returns a #NUM! Error.
- QUARTILE function #VALUE! Error if the given value of quart is non-numeric.
Availability
Since 2000 for Windows.
Since 2011 for Mac.