QUARTILE function
Summary
Returns the quartile of a data set
Syntax
QUARTILE(array,quart)
The QUARTILE function syntax has the following arguments:
• Array Required. The array or cell range of numeric values for which you want the quartile value.
• Quart Required. Indicates which value to return.
0 | Minimum value
1 | First quartile (25th percentile)
2 | Median value (50th percentile)
3 | Third quartile (75th percentile)
4 | Maximum value
• Array Required. The array or cell range of numeric values for which you want the quartile value.
• Quart Required. Indicates which value to return.
0 | Minimum value
1 | First quartile (25th percentile)
2 | Median value (50th percentile)
3 | Third quartile (75th percentile)
4 | Maximum value
Example
=QUARTILE(A2:A9,1)