Description Computes the value corresponding to the specified quartile in a specified array of numbers.
Syntax QUARTILE (array, quartilerank)
| Argument | Description |
|---|---|
| array | A list of numbers, in the form of a range reference or array constant. Text and logical values are ignored. |
| quartilerank | An integer in the set {0, 1, 2, 3, 4} that specifies in which of the quartile divisions you want to find a value. Decimal values are rounded down to the nearest integer.Text in the argument list that converts to one of the numbers in the set will be evaluated as a number; otherwise the function will return the #VALUE! error. Text referenced in cells will return the #VALUE! error. Logical values are evaluated as 1 if TRUE and 0 if FALSE. |
Remarks To determine the value, the function sorts array in ascending order. Then the function divides array into four parts or quartiles. The lowest value in the array is assigned the 0th quartile and the highest value is the 4th quartile. If the array contains an odd number of values, the middle value is assigned the 2nd quartile; otherwise, a value halfway between the two middle values is calculated and assigned the 2nd quartile. Values corresponding to the 1st and 3rd quartiles are either assigned or calculated in the same manner.
The function returns the value it assigned to or calculated for the quartilerank value you chose.
Examples This function returns 57:
This function returns 5:
See Also PERCENTILE, PERCENTRANK
