Quick Navigation

QUARTILE.INC Function

Excel 2010+

Summary

The QUARTILE.INC function calculates quartile values from a dataset using the inclusive method, which includes the minimum and maximum values as quartiles 0 and 4. This statistical function helps divide data into four equal parts for analysis of distributions, outliers, and performance metrics.

Syntax

QUARTILE.INC(array, quart)

Parameters

Parameter	Type	Required	Description
array	`Range/Array`	Yes	Numeric data range or array for quartile calculation
quart	`Number`	Yes	Quartile number: 0 (min), 1 (25th), 2 (median), 3 (75th), 4 (max)

Using the QUARTILE.INC Function

QUARTILE.INC excels in statistical analysis by providing precise quartile calculations for data distribution analysis. Use it to identify Q1 (25th percentile), median (Q2), Q3 (75th percentile), or boundaries (min/max) to understand data spread, detect outliers, and create box plots.

Common QUARTILE.INC Examples

Find First Quartile (Q1)

=QUARTILE.INC(A2:A10,1)

Returns 25th percentile (first quartile) from sales data in A2:A10. For dataset {1,2,4,7,8,9,10,12}, result is 3.5.

Calculate Median (Q2)

=QUARTILE.INC(B2:B20,2)

Returns dataset median value, equivalent to MEDIAN function.

Identify Third Quartile (Q3)

=QUARTILE.INC(C2:C15,3)

Returns 75th percentile for upper quartile analysis.

Frequently Asked Questions

QUARTILE.INC includes minimum (0) and maximum (4) values and supports quart=0-4. QUARTILE.EXC excludes endpoints and only supports quart=1-3.

QUARTILE.INC returns #NUM! error if quart < 0 or > 4.

No, empty arrays return #NUM! error.

Common Errors and Solutions

#NUM! Error

Cause: quart value < 0 or > 4, or array is empty

Solution: Ensure quart is 0,1,2,3, or 4 and array contains numeric data

#VALUE! Error

Cause: Non-numeric data in array

Solution: Clean data or use array of numbers only

Wrong quartile value

Cause: Non-integer quart truncated incorrectly

Solution: Use integer values 0-4 for quart parameter

Notes

MIN, MEDIAN, MAX functions return same results as QUARTILE.INC(array,0), QUARTILE.INC(array,2), QUARTILE.INC(array,4)
Non-integer quart values are truncated to integers
Perfect for box plot creation (Q1, Median, Q3)
Interpolation used between data points for precise results

Compatibility

Available in: Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in: Excel 2007, Excel 2003, Earlier versions

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2010+