MODE function
MODE returns the most common value in a data set. If there are several values with the same frequency, it returns the smallest value. An error occurs when a value does not appear twice.
Syntax
MODE (number 1,number 2,...number 30)
number 1, number 2, ...number 30 are numerical values or ranges.
Example
Given the array A1:A11 as follows:
A | |
---|---|
1 | 12 |
2 | 8 |
3 | 24 |
4 | 11 |
5 | 5 |
6 | 20 |
7 | 16 |
8 | 9 |
9 | 7 |
10 | 16 |
11 | 33 |
=MODE(A1:A11) returns 16 as this value occurs twice in the array.