QUARTILE.INC Function - Calculates quartiles of a dataset, including values 0 and 1 in Excel.

Buzz

Ngày cập nhật gần nhất: 15/4/2026

This article introduces you to the QUARTILE.INC function, one of the frequently used statistical functions in Excel.

Description: The function returns quartiles of a dataset, covering values from 0 to 1. It is supported from Excel 2010 onwards.

Syntax: QUARTILE.INC(array, quart), where array is an array or range containing values to find quartiles, and quart is the position of the quartile to return.

In this context:

- array: An array or range containing the values to find quartiles, a mandatory parameter.

- quart: The position of the quartile to return, a mandatory parameter with the following values:

+ quart = 0 -> the function returns the minimum value.

+ quart = 1 -> the function returns the first quartile (25th percentile).

+ quart = 2 -> the function returns the median (50th percentile).

+ quart = 3 -> the function returns the third quartile (75th percentile).

+ quart = 4 -> the function returns the maximum value.

Note:

- If quart is not an integer -> it is truncated to an integer.

- If array is empty -> the function returns the error value #NUM!

- If quart > 4 or quart < 0 -> the function returns the error value #NUM!

- The MIN and MAX, MEDIAN functions return values similar to the QUARTILE.INC function with corresponding values for quart = 0, quart = 4, quart = 2.

Example:

Identify the positions of quartiles based on the description in the data table below:

- Identify the position of the first quartile. In the cell where you want to calculate, enter the formula: =QUARTILE.INC(D6:J6,D7)

- Press Enter -> the 1st quartile is:

- 4th quartile. In the cell where you want to calculate, enter the formula: =QUARTILE.INC(D6:J6,D8). Press Enter -> the returned value is:

- In the case of quart = 0 -> the function still calculates normally.

- In the case of quart = 6 > 4 -> the function returns an error value #NUM!

Here is a guide and some specific examples of using the QUARTILE.INC function in Excel.

Wishing you success!

Frequently Asked Questions

What is the purpose of the QUARTILE.INC function in Excel?

The QUARTILE.INC function in Excel is designed to return quartiles of a dataset, providing values that range from 0 to 1. It helps users analyze data distributions effectively by calculating minimum, maximum, and various percentile values.

How do you use the QUARTILE.INC function syntax correctly?

To use the QUARTILE.INC function, the syntax is QUARTILE.INC(array, quart). Here, 'array' refers to the range of values, while 'quart' indicates the specific quartile position you want to retrieve, such as 0 for the minimum or 4 for the maximum.

What happens if the quart parameter exceeds the limits in QUARTILE.INC?

If the quart parameter is greater than 4 or less than 0, the QUARTILE.INC function returns the error value #NUM!. This indicates that the specified quartile position is out of the valid range.

Can you provide an example of using QUARTILE.INC in Excel?

Certainly! For instance, to find the first quartile of a dataset in cells D6 to J6, you would enter the formula =QUARTILE.INC(D6:J6,1). Press Enter, and it will return the value for the 25th percentile based on the dataset.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]