Excel - QUARTILE.INC Function

Quiz

QUARTILE.INC Function

In Microsoft Excel, the three core statistical functions are QUARTILE, QUARTILE.INC and QAURTILE.EXC is used to determine the quartile in the array, having minor differences between these three functions.

The Excel QUARTILE.INC function computes the quartile of a numeric data set, based on percentile values. Unlike the QUARTILE.EXC, you can quickly calculate the 0 and 4^th quartile of the given set of numeric values.

Compatibility

This advanced Excel function is compatible with the following versions of MS Excel −

Excel for Microsoft 365
Excel for Microsoft 365 for Mac
Excel for the web
Excel 2024
Excel 2024 for Mac
Excel 2021
Excel 2021 for Mac
Excel 2019
Excel 2016
Excel 2013
Excel 2010

Syntax

The syntax of the QUARTILE.INC function is as follows −

=QUARTILE.INC(array,quart)

Arguments

You can use the following arguments with the QUARTILE.INC function −

Argument	Description	Required/ Optional
Array	It indicates an array or cell range upon which the quartile value will be retrieved.	Required
Quart	A number ranges from 0 to 4. The 0 denotes the minimal value. Number 1 denotes the first quartile(25th percentile), Number 2 represents the medium value(50^th percentile), Number 3 indicates the third quartile(75^th percentile, and Number 4 specifies the fourth quartile.	Required

Points to Remember

If the decimal point is specified in the quart, it is truncated.
If the array has no data points, then the QUARTILE.INC function returns the #NUM! error.
If quart < 0 or if quart > 4, then the QUARTILE.INC function retrieves the #NUM! error.
If the non-numeric value is specified in the Quart, then the QUARTILE.INC function returns the #VALUE! error.

Examples of QUARTILE.INC Function

Practice the following examples to learn the use of the QUARTILE.INC function in Excel.

Example 1: How to Calculate the QUARTILE of the given Dataset?

In this example, the QUARTILE.INC function is employed to find the first and third quartiles in the dataset.

Solution

Step 1 − First, assume the sample dataset's numeric values are specified in the cell range C2:C12. Set the Quart to 1 and 3 written in the C13 and C15 cells. Double-click on the C14 cell and write the formula =QUARTILE.INC(C2:C12, C13) and press the Enter.

Therefore, the first quartile of the given array is 18.5.

Step 2 − After that, select the C16 and enter the formula

Therefore, the QUARTILE.INC function returns 44.5 representing the third percentile of the given set of data.

Example 2

If the array has no data points, then the QUARTILE.INC function returns the #NUM! error.

Solution

You may enter the formula =PERCENTILE.INC(F2:G6,2) in the C2 cell and hit the Enter tab.

Therefore, the resulting value is #NUM! error.

Example 3

If quart < 0 or if quart > 4, then the QUARTILE.INC function retrieves the #NUM! error.

Solution

Select the C3 cell and write the formula =PERCENTILE.INC({2,3,4},6) and press the Enter tab. Here, the quart value is 6, which is larger than 4.

Therefore, the PERCENTILE.INC function returns the #NUM! error.

Example 4

If the non-numeric value is specified in the Quart, then the QUARTILE.INC function returns the #VALUE! error.

Solution

First, you may write the formula =QUARTILE.INC({1.4,4.5,6.7},"stand") in the C4 cell and press the Enter tab.

Hence, the resulting value is #VALUE! error.

Download Practice Sheet

You can download and use the sample data sheet to practice the QUARTILE.INC function.

Print Page