QUARTILE

QUARTILE(array, quart)

Returns the quartile of a data set (inclusive).

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

REMARKS

* QUARTILE.INC was added in Excel 2010 to replace this function.
* For an illustrated example refer to the page under Advanced Functions
* The function returns the same values as the PERCENTILE function.
* The values in the array do not have to be sorted into ascending order.
* If "array" is empty , then #NUM! is returned.
* If "array" contains more than 8,191 data points, 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.
* If "quart" = 0, then this is equivalent to the MIN function.
* If "quart" = 1, then this is equivalent to the 25th percentile.
* If "quart" = 2, then this is equivalent to the MEDIAN function.
* If "quart" = 3, then this is equivalent to the 75th percentile.
* If "quart" = 4, then this is equivalent to the MAX function.
* You can use the QUARTILE.EXC function to
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

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

1 - What is the smallest value in the list {1,2,3,4,5,6,7,8}.
2 - What is the smallest value in the list {6,4,8,2,5,1,7,3}
3 - What is the largest value in the list {1,2,3,4,5,6,7,8}.
4 - What is the largest value in the list {6,4,8,2,5,1,7,3}
5 - What is the 25th percentile in the list {1,2,3,4,5,6,7,8}
6 - What is the 50th percentile in the list {1,2,3,4,5,6,7,8}
7 - What is the 75th percentile in the list {1,2,3,4,5,6,7,8}