Buzz
Quartiles are indispensable in surveys and sales, helping you evaluate specific criteria within a dataset. This article provides a detailed guide on using the QUARTILE function, returning quartiles of the dataset.
Description: The function returns quartiles of the dataset, widely applied in survey and sales data analysis.
Syntax: QUARTILE(array, quart).
In this context:
- array: The dataset (in an array or range format) from which the quartile value is to be found, is a mandatory parameter.
- quart: Specifies the level at which the returned value is, is a mandatory parameter. It has the following levels:
+ quart = 0: Minimum quartile value.
+ quart = 1: First quartile (25th percentile).
+ quart = 2: Quartile at the median (50th percentile).
+ quart = 3: Quartile at the 3rd value (75th percentile).
+ quart = 4: Quartile at the maximum value.
Important Note:
- If the array parameter is empty => the function returns #NUM!
- If quart is a decimal number => the function takes the integer value of quart.
- If quart is outside the set of values { 0, 1, 2, 3, 4} => the function returns the error value #NUM!
- When quart = 0 => equivalent to the MIN function, quart = 2 => equivalent to the MEDIAN function, quart = 4 => equivalent to the MAX function.
Example:
- Calculate the quartile values for the following dataset:
1. Minimum Quartile
In the cell where calculation is needed, enter the formula: =QUARTILE(B13:B17,C13).
The minimum quartile has the same value as the MIN function:
2. 25th Quartile (quart = 1)
In the cell where calculation is needed, enter the formula: =QUARTILE(B13:B17,C14).
3. 50th Quartile
In the cell where calculation is needed, enter the formula: =QUARTILE(B13:B17,C15).
50th Quartile has the same value as the MEDIAN function.
4. 75th Quartile
In the cell where calculation is needed, enter the formula: =QUARTILE(B13:B17,C16).
5. Maximum Quartile
Enter the formula: =QUARTILE(B13:B17,C17).
The maximum quartile value is exactly equal to the MAX function value:
Here is a detailed guide on how to use and special cases of the Quartile function.
Wishing you all success!
