MODE(list)

The MODE function calculates the mode of a list of numbers. The mode is the most frequently occurring number in the list.

If all the numbers occur with equal frequency then an error message is returned. However, if a subset of the numbers occur with greater frequency than the others, then the first number in the subset is returned.

For example:

MODE(4, 5, 9, 2, 9)  returns 9

MODE(4, 5, 2, 9, 2, 9)  returns 2

MODE(1, 2, 3, 4, 5)  returns an error message

MODE will return an error message if any of the list values or values held in a range are non-numeric.

See also:

Other statistical functions