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.
|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
|2||9||=QUARTILE.INC(A2:A10,3)||32||The third quartile (75th percentile) of the data|
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 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.