Returns a quartile value from a data set.
Syntax:
QUARTILE.EXC(array, q:number)
Returns the qth quartile from the values in the 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
Added in 2.00.