# 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 Value1 - 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 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* 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 PERCENTRANK.INC function to return the rank of a value as a percentage (inclusive).* 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}