Excel QUARTILE Function

Summary
The Excel QUARTILE function returns the quartile (each of four equal groups) for a given set of data. QUARTILE can return minimum value, first quartile, second quartile, third quartile, and max value.
Purpose
Get the quartile in a data set
Return value
Value for requested quartile
Syntax
=QUARTILE (array, quart)
Arguments
- array - A reference containing data to analyze.
- quart - The quartile value to return.
Usage notes
Use the QUARTILE function to get the quartile for a given set of data. QUARTILE takes two arguments, the array containing numeric data to analyze, and quart, indicating which quartile value to return. The QUARTILE function accepts 5 values for the quart argument, as shown the in the table below.
Quart | Return value |
---|---|
0 | Min value |
1 | First quartile – 25th percentile |
2 | Median value – 50th percentile |
3 | Third quartile – 75th percentile |
4 | Max value |