Related Functions:

The QUARTILE.INC function returns the quartile of a data set, based on percentile values from 0…1, inclusive.

• This function was introduced in Excel 2010 and so is not available in earlier versions.
• The QUARTILE.INC function replaces the QUARTILE function included in earlier versions of Excel.

### Syntax

=QUARTILE.INC(array,quart)

#### Arguments

Argument Description
array The range of data values for which you want to calculate the specified quartile
quart An integer between 0 and 4, representing the required quartile

If quart equals QUARTILE.INC returns
0 Minimum value
1 First quartile (25th percentile)
2 Median value (50th percentile)
3 Third quartile (75th percentile)
4 Maximum value

#### Examples

A B C D E
1 Data   Formula Result Notes
2 9   =QUARTILE.INC(A2:A10,3) 32 The third quartile (75th percentile) of the data
3 37
4 20
5 6
6 16
7 26
8 32
9 32
14

Note: The Quartile.Inc function is closely related to the PERCENTILE.INC such that:

• The 1st quartile is the same as the 25th percentile
• The 2nd quartile is the same as the 50th percentile
• The 3rd quartile is the same as the 75th percentile
• The 4th quartile is the same as the 100th percentile – the maximum value in the range

#### Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied value of quart cannot be interpreted as a numeric value
#NUM! Occurs if either:

 • the supplied value of quart is is < 0 or > 4 • the supplied array is empty

The 1st, 2nd, 3rd or 4th quartile of a range of data is the value that 25%, 50%, 75% or 100% (respectively) of the data values fall within.

The QUARTILE.INC and QUARTILE.EXC functions both find a requested quartile of a supplied data set. The difference between these two functions is that the QUARTILE.INC function bases its calculation on a percentile range of 0 to 1 inclusive, while the QUARTILE.EXE function bases its calculation on a percentile range of 0 to 1 exclusive.