Statistical
QUARTILE.INC function: split salaries or deal sizes into Q1, median, and Q3 bands
Calculate the 25th, 50th, and 75th inclusive quartile cutoffs and interquartile range (IQR) with QUARTILE.INC.
Understand quart codes 0 through 4
QUARTILE.INC(array, quart) calculates quartile cutoffs for a numeric sample using inclusive 0..1 interpolation (matching PERCENTILE.INC at 0%, 25%, 50%, 75%, and 100%).
Subtracting Q1 (quart = 1) from Q3 (quart = 3) gives the Interquartile Range (IQR), a classic outlier-resistant measure of middle-50% spread.
| quart Argument | Meaning | Result on [120, 160, 200, 280, 360] |
|---|---|---|
| 0 | Minimum value (0th percentile) | 120 |
| 1 | First quartile Q1 (25th percentile) | 160 |
| 2 | Median Q2 (50th percentile) | 200 |
| 3 | Third quartile Q3 (75th percentile) | 280 |
| 4 | Maximum value (100th percentile) | 360 |
Compute Q1, Q3, and Interquartile Range (Q3 - Q1)
Across five sorted deals (120, 160, 200, 280, 360), Q1 = 160 and Q3 = 280, yielding an IQR of 280 - 160 = 120.
=QUARTILE.INC(B2:B6, 3) - QUARTILE.INC(B2:B6, 1)quart outside 0..4 returns #NUM!
quart is truncated to an integer first. If that integer is below 0 or above 4, such as 5, the function returns #NUM!.
=QUARTILE.INC(B2:B6, 5)Try the example
Use the original values or change them to test your understanding.