Difference between revisions of "Documentation/How Tos/Calc: MODE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
|||
| Line 2: | Line 2: | ||
== MODE == | == MODE == | ||
| − | Returns the most common value in a | + | Returns the most common value in a set of numbers. |
=== Syntax: === | === Syntax: === | ||
Revision as of 18:57, 18 June 2008
MODE
Returns the most common value in a set of numbers.
Syntax:
MODE(number1; number2; ... number30)
- number1 to number30 are up to 30 numbers or ranges/arrays containing numbers.
- MODE returns the number that occurs most often, or if more than one number occurs that many times, the smallest such number. If no number occurs more than once, MODE returns an error.
- Advanced topic: MODE evaluates its parameters as array formulas - see the examples.
Example:
MODE(A1:A4)
- where cells A1:A4 contain 1, 3, 2, 3 returns 3, the number occurring most often.
MODE(3; 7; 3; 9; 9; 3; 5; 1; 9; 5)
- returns 3. The number 9 occurs the same number of times, but 3 is smaller.
Advanced topic: Evaluation as an array formula:
MODE(ABS({1; 1; 1; 2; 2; -2; -2}))
- returns 2. The ABS function normally takes a single number, but here it is given an array. MODE forces the formula to be an array formula, so that the absolute value of each number in the array is found, and given to MODE as the array {1; 1; 1; 2; 2; 2; 2}. The most common value is now 2.
