next up previous contents index
Next: RADIANS Up: A. Function Reference Previous: PV   Contents   Index


QUARTILE

Syntax: QUARTILE(R, Q)

R = Range of cells
Q = Quartile as follows:

0 Minimum value
1 First quartile (25th percentile)
2 Second quartile (50th percentile)
3 Third quartile (75th percentile)
4 Maximum value

QUARTILE finds the quartile Q of the data in range R. This is equivalent to PERCENTILE(R, Q/4).

Examples:

A1..A8 = 1, 2, 4, 7, 8, 9, 10, 12

QUARTILE(A1..A8, 2) = 7.5

QUARTILE(A1..A8, 1) = 3.5

Excel function: QUARTILE


next up previous contents index
Next: RADIANS Up: A. Function Reference Previous: PV   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003