The MODE function returns the most frequent value in a group of numbers.
This function is useful in statistical analysis when you need to determine the most common value in a sample.
Syntax
MODE(value1, [value2, ...])
Argument |
Description |
Permitted values |
|---|---|---|
value1 |
First value or range |
Number, cell reference, or range |
[value2, ...] |
(optional) Additional values or ranges |
Number, cell reference, or range |
Examples of use
Search for mode in the range
If you have data in cells A1:A7, for example, [3, 5, 3, 2, 8, 5, 3], you can find the modulus as follows:
=MODE(A1:A7)
This formula will return 3, as this value occurs most frequently.
Searching for mode among individual numbers
=MODE(1, 2, 2, 3, 4)
This formula will return 2, as it occurs twice.
Combining ranges
=MODE(A1:A10, B1:B10)
It will find the mode among the values in the specified ranges.
Notes
If there are no duplicate values in the data set, the function will return the #N/A error.