QUARTILE.INC
Returns the quartile of a data set.
=QUARTILE.INC(array, quart)This static page keeps the function indexed for search, while the spreadsheet app handles interactive exploration and saved formulas.
What the function does
Overview
Returns the quartile of a data set.
The QUARTILE.INC function calculates the quartile of a specified data set based on a percentile range of 0 to 1, inclusive. Unlike QUARTILE.EXC, which excludes the extreme values from its percentile calculation, QUARTILE.INC includes the full range from the minimum value (quart 0) to the maximum value (quart 4). This function is essential for descriptive statistics and creating box-and-whisker plots to visualize data distribution, variance, and central tendency. Best practices involve ensuring the data array contains only numeric values, as text or logical values are ignored during calculation. If the 'quart' argument is not an integer, Excel truncates it toward zero. It is particularly useful when you need the exact boundaries of your data set included in your statistical summary.
Quick reference
Syntax
=QUARTILE.INC(array, quart)Inputs
Arguments
Example: B2:B100
Example: 1
Formula patterns
Examples
Calculate the 25th percentile (Lower Quartile)
=QUARTILE.INC(A2:A100, 1)Find the median value using the second quartile
=QUARTILE.INC(A2:A100, 2)Extract the maximum value from a dataset
=QUARTILE.INC(B2:B50, 4)Avoid these issues
Common Errors
#NUM!
Cause: The 'quart' argument is less than 0 or greater than 4, or the provided array is empty.
Fix: Ensure the 'quart' value is an integer between 0 and 4 and that the referenced range contains numeric data.
#VALUE!
Cause: The 'quart' argument is non-numeric.
Fix: Verify that the cell reference or value used for the 'quart' argument is a number.
Platform support
Compatibility
Source: Microsoft Support
Common questions
Frequently Asked Questions
Returns the quartile of a data set.
array: Data range quart: Quartile number (0-4)
#NUM!: Ensure the 'quart' value is an integer between 0 and 4 and that the referenced range contains numeric data. #VALUE!: Verify that the cell reference or value used for the 'quart' argument is a number.