Syntax
QUARTILE.EXC(array, quart)
| Parameter | Description |
|---|---|
| array | Parameter of the QUARTILE.EXC function. |
| quart | Parameter of the QUARTILE.EXC function. |
Examples
Exclusive Q1
Formula
=QUARTILE.EXC(B2:B100, 1)
Returns the 25th percentile using the exclusive method. The result may differ slightly from QUARTILE.INC for the same data.
Exclusive median
Formula
=QUARTILE.EXC(A1:A200, 2)
Returns the median using the exclusive method. For quart=2, the result is typically the same as QUARTILE.INC.
IQR exclusive
Formula
=QUARTILE.EXC(C2:C500, 3) - QUARTILE.EXC(C2:C500, 1)
Returns the interquartile range using the exclusive method, which may be slightly wider than the inclusive IQR.
Common Errors
#NUM!
Returned when quart is 0 or 4 (not allowed in exclusive mode), or if the data set has fewer than 4 values.
#VALUE!
Quart is not a valid number.
Tips
Only quart 1, 2, 3 allowed
Unlike QUARTILE.INC, you cannot use 0 (min) or 4 (max). If you need those, use MIN() and MAX() separately.
Needs enough data points
QUARTILE.EXC requires the data set to have more values than the exclusive method can interpolate. Very small data sets (under 4 values) will return errors.
Statistical preference
Some textbooks and statistical software default to the exclusive method. Use .EXC when your analysis needs to match specific academic or regulatory standards.
Try QUARTILE.EXC in Viztab
Import your data and use QUARTILE.EXC with 370+ other formulas. No signup required.
Open Viztab