Formulas and Functions

Related Topics
For related functions and additional information, see:
“BINOMDIST” on page 238
“CRITBINOM” on page 252
“NEGBINOMDIST” on page 275
“PERMUT” on page 281
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
QUARTILE
The QUARTILE function returns the value for the specied quartile of a given data
collection.
QUARTILE(num-set, quartile-num)
 num-set: A collection of numbers. num-set is a collection containing number values.
 quartile-num: Species the desired quartile.
smallest (0): Returns the smallest value.
rst(1):Returns the rst quartile (25th percentile).
second (2): Returns the second quartile (50th percentile).
third (3): Returns the third quartile (75th percentile).
largest (4): Returns the largest value.
Usage Notes
MIN, MEDIAN, and MAX return the same value as QUARTILE when  quartile-num is
equal to 0, 2, and 4, respectively.
284 Chapter 10 Statistical Functions