QUARTILE. INC Function in Excel

This guide provides a practical overview of QUARTILE. INC Function, including its main features, benefits, limitations, and important considerations.

Description: The function returns the quartile of a dataset, with percentile values from 0 to 1 including 0 and 1. Functions supported from Execl 2010 onwards.

Syntax: QUARTILE. INC (array, quart)

Inside:

- array: An array or range containing values that want to find quartiles, a required parameter .

- quart: The position of the quartile to be returned, is the required parameter including the following values:

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

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

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

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

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

Attention:

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

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

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

- The MIN and MAX, MEDIAN functions return the same value as the QUARTILE. INC function with corresponding values quart = 0, quart = 4, quart = 2.

For example:

Locate the units as described in the following data table:

- Determine the position of the 1st percentile. In the cell to calculate enter the formula : = QUARTILE. INC (D6: J6, D7)

- Press Enter -> 1st percentile is:

- The fourth percentile. In the cell to calculate enter the formula: = QUARTILE. INC (D6: J6, D8). Press Enter -> return value is:

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

- Where the quart value = 6> 4 -> the function returns the #NUM! Error value

Above are instructions and some specific examples when using QUARTILE. INC function in Excel.

Good luck!