272 min – Apple iWork '09 User Manual
Page 272

Examples
=MEDIAN(1, 2, 3, 4, 5) returns 3.
=MEDIAN(1, 2, 3, 4, 5, 6) returns 3.5.
=MEDIAN(5, 5, 5, 5, 6) returns 5.
Related Topics
For related functions and additional information, see:
“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
MIN
The MIN function returns the smallest number in a collection.
MIN(value, value…)
Â
value: A value. value can contain any value type.
Â
value…: Optionally include one or more additional values.
Usage Notes
If
Â
value does not evaluate to a date or number, it is not included in the result.
To determine the smallest of any type of value in a collection, use the MINA
Â
function.
Examples
=MIN(5, 5, 5, 5, 6) returns 5.
=MIN(1, 2, 3, 4, 5) returns 1.
Related Topics
For related functions and additional information, see:
272
Chapter 10
Statistical Functions