QUARTILE
Syntax:
QUARTILE ( array , result-category )
Description: Computes the quartile of a data set.
Arguments:
Name |
Type |
Description |
||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
array |
array, reference |
The set of numeric values for which the quartile value is to be computed. |
||||||||||||
result-category |
number |
When truncated to an integer, specifies which value is to be returned, as follows:
|
Return Type and Value: number – The quartile of a data set.
However, if
array is empty, the return value is unspecified.
result-category < 0 or result-category > 4,
#NUM!
is returned.
example: