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

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


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

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999