MODE (most frequently occurring value)

<< Click to Display Table of Contents >>

MODE (most frequently occurring value)

Note: MODE is supplemented by the new identical function MODE.SNGL, which is available in newer versions of Microsoft Excel (2010 or later).

Syntax:

MODE(Number1 [, Number2, Number3 ...])

Description:

This returns the mode of a data set.

The mode is the value that occurs most frequently in a set of numbers.

Number1, Number2, etc., are the numbers to be evaluated.

If the given numbers contain more than one mode, their smallest mode will be returned.

If the given numbers do not contain any value occurring more than once, a #N/A error value will be returned.

Example:

MODE(1, 2, 4, 4, 4, 2, 1) returns 4

MODE(1, 2, 4, 4, 2, 1) returns 1 (if there are multiple modes, the smallest one is returned)

MODE(1, 4, 2) returns #N/A because no value occurs more than once.

See also:

MODE.SNGL, MEDIAN, NORM.DIST/NORMDIST