Returns the quartiles of the data set. Quartiles are commonly used to group populations in sales and measurement data.
For example, you can use the function QUARTILE to find the income values of the top 25% of the population.
Syntax
QUARTILE(array,quart)
Array Array or numeric cell range where the quartile values need to be obtained.
Quart determines which quartile value to return .
Description
￭If the array is empty, QUARTILE returns the error value #NUM!.
￭ if quart
￭If quart is not an integer, it will be truncated.
￭The MIN, MEDIAN, and MAX functions return the same values as the QUARTILE function when quart is equal to 0, 2, and 4 respectively.
When we calculate sales, we often use QUARTILE function.
Its function is to return the quartiles of the data set, quartiles are often used to group the population in sales and measurement data.
For example, you can use the function QUARTILE to find the income values of the top 25% of the population.
Let's practice it in this form to help everyone understand
￭ Select cell B2, click Insert function, find the QUARTILE function, and click OK.
Here we need to enter two values.
"Array" needs to be filled in the numerical area used to calculate the quartile points.
"Quartile" needs to be filled with a number, which means that the quartile parameter value is to be returned, between 0 and 4.
0 represents the minimum value, 1 represents the first quartile (value at 25%)
2 represents the median (50% value)
3 represents the third quartile (value at 75%)
4 represents the maximum value
If the parameter value of "quartile" is empty, or the parameter is less than 0 or greater than 4, the #NUM! error value will be returned.
￭ We select "array" to fill in column A data, and select "quartile" parameter value to fill in C1.
Click OK to get the quartile values in this data table.
￭ Position the cursor at the lower right corner of cell D2, and when the + word appears, select the drop-down fill cell to obtain the values of all quartiles of the table data in batches.
支付宝扫一扫 
评论列表（196条）
测试