Author: Oscar Cronquist Article last updated on November 13, 2018

The QUARTILE.EXC function returns the quartile of a data set, use the QUARTILE.EXC function to divide data into groups.

This function was introduced in Excel 2010 has replaced the old QUARTILE function

Formula in cell D3:

=QUARTILE.EXC(B3:B11,1)

Excel Function Syntax

QUARTILE.EXC(array, quart)

Arguments

array Required. The cell values for which you want to calculate the quartile value.
quart Required. Indicates which value to return, see table below.

 

Quart parameters
0 Minimum value.
1 First quartile (25th percentile).
2 Median quartile (50th percentile).
3 Third quartile (75th percentile).
4 Maximum value.

Comments

The QUARTILE function returns #NUM! value if

  • quart < 0 (zero)
  • quart > 4

The QUARTILE function returns the same value as:

The following Box and Whisker chart shows the first quartile 47.5.