MODE
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.