QUARTILE.EXC

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.