QUARTILE.EXC function

The QUARTILE.EXC function returns value nearest to a given quartile of a dataset, exclusive of 0 and 4.

Parts of a QUARTILE.EXC function

QUARTILE.EXC(data, quartile_number)

Part	Description
`data`	The array or range containing the dataset to consider.
`quartile_number`	This is which quartile value to return 1 returns the value in data closest to the first quartile (25% mark) 2 returns the value in data closest to the median (50% mark) 3 returns the value in data closest to the third quartile (75% mark)

Sample formulas

QUARTILE.EXC(A2:A100, 3)

QUARTILE.EXC(A2:A100, B2)

Notes

If the quartile_number is not an integer, the number is truncated.
The quartile_number must be between 0 and 4, exclusive.
Different from QUARTILE.INC, QUARTILE.EXC calculates quartile based on a quartile range exclusive of 0th and 4th quartile.

Examples

	A
1	data
2	6
3	7
4	15
5	36
6	39
7	40
8	41
9	42
10	43
11	47
12	49

	A	B	C
1	Quartile	Result	Formula
2	1	15	`=QUARTILE.EXC(A2:A12, 1)`
3	2	40	`=QUARTILE.EXC(A2:A12, 2)`
4	3	43	`=QUARTILE.EXC(A2:A12, 3)`

Related functions

PERCENTILE: Returns the value at a given percentile of a dataset.
PERCENTILE.EXC: The PERCENTILE.EXC function returns the value at a given percentile of a dataset, exclusive of 0 and 1.
MEDIAN: Returns the median value in a numeric dataset.
QUARTILE: Returns a value nearest to a specified quartile of a dataset.

Need more help?

Try these next steps:

Post to the help community Get answers from community members

Statistical

Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search

Clear search

Close search

Google apps

Main menu