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.

See Wikipedia for more information on quartile.