QUARTILE.INC

Returns a quartile value from a data set.

Syntax:

QUARTILE.INC( data:Range or Array, q:Number )

Returns the qth quartile from the values in the data range of cells (or array) based on a percentile range of [0.0,1.0] (i.e. inclusive).

q must be of one the following values:

0% MIN
25% Q1
50% Q2 (MEDIAN)
75% Q3
100% MAX

Revisions:

This function was added in Fireworkz 2.00.