Syntax. QUARTILE.EXC(array,quart)
Definition. This function returns the quartile of a data group only based on 0 to 1 exclusive.
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
If array is empty, QUARTILE.EXC() returns the #NUM!
error value.
If quart isn’t an integer, the decimal places are truncated. If quart is 0 or 4, the QUARTILE.EXC() function returns the #NUM!
error. MIN(), MEDIAN(), or MAX() return the same value as QUARTILE.EXC() if the quartile is 0, 2, or 4.
Background. You will find more information in the description of QUARTILE().
Example. You will find more information about the use of this function in the description of QUARTILE().
LARGE(), MAX(), MEDIAN(), MIN(), PERCENTILE(), PERCENTILE.EXC(), PERCENTILE.INC(), PERCENTRANK(), PERCENTRANK.EXC(), PERCENTRANK.INC(), SMALL()
Sample Files
Use the QUARTILE.EXC worksheet in the Average.xlsx sample file. The sample files are found in the Chapter12 folder. For more information about the sample files, see the section titled Using the Sample Files.
3.145.9.148