Formulas and Functions

“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 specied, 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 rst 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:
“AVERAGE” on page 231
“MEDIAN” on page 271
“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