Purpose
Get the quartile in a data set
Return value
Value for requested quartile
Syntax
=QUARTILE(array,quart)- array - A reference containing data to analyze.
- quart - The quartile value to return.
Using the QUARTILE function
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 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 |
QUARTILE function examples
Highlight data by quartile
The QUARTILE function is automatic, and will calculate the 1st quartile with an input of 1, the 2nd quartile with an input of 2, and the 3rd quartile with an input of 3. With an input of 0, quartile returns the minimum value in the data. The trick in this case is to arrange the conditional...
Related functions
MIN Function
The Excel MIN function returns the smallest numeric value in the data provided. The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.
MAX Function
The Excel MAX function returns the largest numeric value in the data provided. MAX ignores empty cells, the logical values TRUE and FALSE, and text values.
MEDIAN Function
The Excel MEDIAN function returns the median (middle number) in the supplied set of data. For example, =MEDIAN(1,2,3,4,5) returns 3.
