Returns the quartile of a data set based on percentile values from 0 to 1.
구문
QUARTILE(array, quart)인수
array필수
The range of cells or array of numerical values for which you want the quartile value.
quart필수
The specific quartile to return, represented by an integer from 0 to 4.
The QUARTILE function is used to calculate the quartile of a data set, which is useful for analyzing the distribution of data. It identifies the value at a specific quartile point, such as the minimum, median, or maximum, within the provided array.
=QUARTILE({1,2,3,4,5,6,7,8,9,10}, 1)→3.25Returns the first quartile (25th percentile) of the numbers 1 through 10.
Select the cell
Click on the cell where you want the result to appear.
Enter the formula
Type =QUARTILE( and select your data range, followed by the quartile number (0-4).
QUARTILE is a compatibility function that is equivalent to QUARTILE.INC, which includes 0 and 1 in the percentile calculation.