Exceljet

Quick, clean, and to the point

Excel QUARTILE Function

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