Mode, 274 mode – Apple iWork '09 User Manual
Page 274
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
MODE
The MODE function returns the most frequently occurring value in a collection of
numbers.
MODE(num-date-dur, num-date-dur…)
Â
num-date-dur: A value. num-date-dur is a number value, a date/time value, or a
duration value.
Â
num-date-dur…: Optionally include one or more additional values. If more than
one num-date-dur value is specified, all must be of the same type.
Usage Notes
If more than one number occurs the maximum multiple times in the arguments,
Â
MODE returns the first such number.
If no value occurs more than once, the function returns an error.
Â
Examples
=MODE(5, 5, 5, 5, 6) returns 5.
=MODE(1, 2, 3, 4, 5) returns an error.
=MODE(2, 2, 4, 6, 6) returns 2.
=MODE(6, 6, 4, 2, 2) returns 6.
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
274
Chapter 10
Statistical Functions