QUARTILE.EXC

QUARTILE.EXC(array, quart)

Returns the quartile of a data set (exclusive).

array	The array or cell range of numeric values.
quart	The number to indicate the quartile you want to return: 1 - First Quartile (25th percentile) 2 - Median Value (50th percentile) 3 - Third Quartile (75th percentile)

REMARKS

* For an illustrated example refer to the page under Advanced Functions
* If "array" is empty, then #NUM! is returned.
* If "quart" is not an integer, it is truncated.
* If "quart" <= 0, then #NUM! is returned.
* If "quart" >= 4, then #NUM! is returned.
* You can use the QUARTILE.INC function to return the quartile of a data set (inclusive).
* You can use the PERCENTILE.INC function to return the value from a data set that corresponds to a particular percentage (inclusive).
* You can use the PERCENTILE.EXC function to return the value from a data set that corresponds to a particular percentage (exclusive).
* You can use the PERCENTRANK.EXC function to return the rank of a value as a percentage (exclusive).
* You can use the AGGREGATE function to exclude hidden cells.
* This function was added in Excel 2010 to replace the QUARTILE function.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=QUARTILE.EXC({1, 2, 3, 4, 5, 6, 7, 8}, 0) = #NUM!
2	=QUARTILE.EXC({6, 4, 8, 2, 5, 1, 7, 3}, 0) = #NUM!
3	=QUARTILE.EXC({1, 2, 3, 4, 5, 6, 7, 8}, 4) = #NUM!
4	=QUARTILE.EXC({6, 4, 8, 2, 5, 1, 7, 3}, 4) = #NUM!
5	=QUARTILE.EXC({1, 2, 3, 4, 5, 6, 7, 8}, 1) = 2.3
6	=QUARTILE.EXC({1, 2, 3, 4, 5, 6, 7, 8}, 2) = 4.5
7	=QUARTILE.EXC({1, 2, 3, 4, 5, 6, 7, 8}, 3) = 6.8
8	=QUARTILE.EXC({1}, 5) = #NUM!
9	=QUARTILE.EXC({1}, "some text") = #VALUE!