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.