QUARTILE.INC

Returns a quartile value from a data set.

Syntax:

QUARTILE.INC(array, q:number)

Returns the qth quartile from the values in the array or range of cells.

q must be of one the following values:

0  0% = MIN

1  25% = Q1

2  50% = Q2 (MEDIAN)

3  75% = Q3

4  100% = MAX

Added in 1.36.