QUARTILE function - The function returns the quartile of a dataset in Excel

The quartile is an indispensable value in the field of surveying and sales, it helps you evaluate certain criteria in a set. The following article details how to use QUARTILE function, the function returns the quartile of a dataset.

Description: The function returns the quartile of a dataset. It is applied in survey and sales data.

Syntax: QUARTILE (array, quart) .

Inside:

- array: The data set (by array or range of cells) wants to find the quartile value, is a required parameter.

- quart: Specifies the value to return, is a required parameter. There are the following levels:

+ quart = 0: Quartiles at minimum.

+ quart = 1: The first quartile (25th percentile).

+ quart = 2: Quartile at average value (50th percentile).

+ quart = 3: Quartile at the third value (75th percentile).

+ quart = 4: Quartile at maximum value.

Attention:

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

- If quart is decimal => function takes integer value of quart.

- If quart is outside the value set {0, 1, 2, 3, 4} => the function returns the #NUM! Error value

- In case quart = 0 => has the same value as MIN function, quart = 2 => has the same value for MEDIAN function, quart = 4 = same value for MAX function.

For example:

- Calculate the percentile value of the following data set:

QUARTILE function - The function returns the quartile of a dataset in Excel Picture 1

1. Minimum percentile

In the cell to calculate enter the formula: = QUARTILE (B13: B17, C13) .

QUARTILE function - The function returns the quartile of a dataset in Excel Picture 2

The minimum percentile has the same value as the MIN function:

QUARTILE function - The function returns the quartile of a dataset in Excel Picture 3

2. 25th percentile (quarty = 1)

In the cell to calculate enter the formula: = QUARTILE (B13: B17, C14) .

QUARTILE function - The function returns the quartile of a dataset in Excel Picture 4

3. 50th percentile

In the cell to calculate enter the formula: = QUARTILE (B13: B17, C15) .

QUARTILE function - The function returns the quartile of a dataset in Excel Picture 5

The 50th percentile has the same value as the MEDIAN function.

QUARTILE function - The function returns the quartile of a dataset in Excel Picture 6

4. 75th percentile

In the cell to calculate enter the formula: = QUARTILE (B13: B17, C16) .

QUARTILE function - The function returns the quartile of a dataset in Excel Picture 7

5. Percentage with maximum value

Enter the formula: = QUARTILE (B13: B17, C17) .

QUARTILE function - The function returns the quartile of a dataset in Excel Picture 8

Maximum percentile value equal to the MAX function value:

QUARTILE function - The function returns the quartile of a dataset in Excel Picture 9

The above is a detailed guide of usage and special cases of Quarty function.

Good luck!