Returns a quartile value from a data set.
Syntax:
QUARTILE.EXC(data:array|range, q:number)
Returns the qth quartile from the values in the data array (or range of cells) based on a percentile range of (0,1) (i.e. exclusive).
q must be of one the following values:
1 | 25% | Q1 |
2 | 50% | Q2 (MEDIAN) |
3 | 75% | Q3 |
Revisions:
This function was added in 2.00.