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. * 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. * For an illustrated example refer to the page under Advanced Functions. * For the Microsoft documentation refer to support.office.com 

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} 
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top