QUARTILE function
QUARTILE splits data into four parts for quick spread checks and returns the quartile you ask for. It is a compatibility function; QUARTILE.INC and QUARTILE.EXC replace it.
Example
Read it as a sentence: find the value at the first quartile of A1:A8, which gives 4.
Excel shows 4
A
1
2
2
4
3
4
4
4
5
5
6
5
7
7
8
9
Data
Syntax
QUARTILE(array, quart)
-
array(required) - The data.
-
quart(required) - 0 minimum, 1 first quartile, 2 median, 3 third quartile, 4 maximum.
Returns: The requested quartile.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=QUARTILE({1,2},1) | 1.25 | Small set (exc) |
=QUARTILE(Data!A1:A8,1) | 4 | Quart 1 |
=QUARTILE(Data!A1:A8,0) | 2 | Quart 0 |
=QUARTILE(Data!A1:A8,2) | 4.5 | Quart 2 |
=QUARTILE(Data!A1:A8,4) | 9 | Quart 4 |
=QUARTILE(Data!A1:A8,1.9) | 4 | Fractional quart truncated |
=QUARTILE(Data!A1:A8,5) | #NUM! | Quart 5 |
=QUARTILE(Data!A1:A8,-1) | #NUM! | Quart -1 |
The Data sheet these formulas read
A cell that starts with = holds that formula.
A
1
2
2
4
3
4
4
4
5
5
6
5
7
7
8
9
Data
Watch out for
- Superseded by QUARTILE.INC / QUARTILE.EXC; use that in new workbooks.
- Behaves like QUARTILE.INC.
Where it works
- Excel
- QUARTILE is in every version of Excel from 2007 on. Compatibility function: still works in every version, but newer replacements exist.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Compatibility functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .