Syntax
QUARTILE.INC(array, quart)
| Parameter | Description |
|---|---|
| array | Parameter of the QUARTILE.INC function. |
| quart | Parameter of the QUARTILE.INC function. |
Examples
Salary Q3
Formula
=QUARTILE.INC(C2:C300, 3)
Returns the 75th percentile salary. Employees above this value are in the top quartile of earners.
Median via quartile
Formula
=QUARTILE.INC(B2:B100, 2)
Returns the median (50th percentile), identical to MEDIAN(B2:B100).
Minimum via quartile
Formula
=QUARTILE.INC(A1:A50, 0)
Returns the minimum value, same as MIN(A1:A50). Quart=0 gives the minimum, quart=4 gives the maximum.
Common Errors
#NUM!
Quart must be an integer from 0 to 4. Values like 1.5 or 5 will cause this error. Also occurs if the array has no numbers.
#VALUE!
Occurs when quart is non-numeric.
Tips
Identical to QUARTILE
QUARTILE.INC produces the same results as QUARTILE. Use .INC for consistency with the newer function naming convention.
Compare with QUARTILE.EXC
QUARTILE.EXC excludes the 0th and 4th quartile (min/max), and uses a slightly different interpolation. For most business use cases, .INC is the standard choice.
Grade boundaries
Use Q1, Q2, Q3 as grade boundaries: below Q1 = needs improvement, Q1-Q2 = developing, Q2-Q3 = proficient, above Q3 = advanced.
Try QUARTILE.INC in Viztab
Import your data and use QUARTILE.INC with 370+ other formulas. No signup required.
Open Viztab