MODE function

The MODE function is one of the statistical functions. It is used to analyze the range of data and return the most frequently occurring value.

Syntax

MODE(number1, [number2], ...)

The MODE function has the following arguments:

Argument	Description
number1/2/n	Up to 255 numeric values for which you want to find the most frequently occurring value.

Notes

If there is no repetitive value in the argument list, the function will return the #VALUE! error.

How to apply the MODE function.

Examples

The figure below displays the result returned by the MODE function.