Formulas and Functions

Chapter 10 Statistical Functions 285
Examples
=QUARTILE({5, 6, 9, 3, 7, 11, 8, 2, 14}, 0) returns 2, the smallest value.
=QUARTILE({5, 6, 9, 3, 7, 11, 8, 2, 14}, 1) returns 5, the 25th percentile or rst quartile.
=QUARTILE({5, 6, 9, 3, 7, 11, 8, 2, 14}, 2) returns 7, the 50th percentile or second quartile.
=QUARTILE({5, 6, 9, 3, 7, 11, 8, 2, 14}, 3) returns 9, the 75th percentile or third quartile.
=QUARTILE({5, 6, 9, 3, 7, 11, 8, 2, 14}, 0) returns 14, the largest value.
Related Topics
For related functions and additional information, see:
“FREQUENCY” on page 257
“MAX” on page 270
“MEDIAN” on page 271
“MIN” on page 272
“PERCENTILE” on page 279
“PERCENTRANK” on page 280
“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
RANK
The RANK function returns the rank of a number within a range of numbers.
RANK(num-date-dur, num-date-dur-set, largest-is-high)
 num-date-dur: A value. num-date-dur is a number value, a date/time value, or a
duration value.
 num-date-dur-set: A collection of values. num-date-dur-set is a collection
containing number, date, or duration values. All values must be of the same type.