QUARTILE.EXC

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:

25% Q1
50% Q2 (MEDIAN)
75% Q3

Revisions:

This function was added in 2.00.