MODE Function
The MODE function is a premade function in Excel, which is used to find the number seen most times.
This function always returns a single number.
It is typed =MODE.SNGL
It returns the most occurring number in a range or array.
Note: The mode is a type of average value, which describes where most of the data is located. You can read more about mode in the: Statistics Mode Tutorial.
Let's have a look at an example where we help the Pokemon trainers to calculate the mode of numbers of Pokeballs.
How to use the =MODE function, step by step:
- Select a cell (
B10) - Type
=MODE - Double click the MODE.SNGL command
- Select a range (
B2:E7) - Hit enter
text
Trainer Pokeball Great Ball Ultraball Master Ball
Iva 10 4 1 1
Liam 12 3 0 1
Jenny 15 1 3 1
Iben 4 2 6 0
Adora 10 4 1 1
Kasper 9 2 1 0
MODE
text
It returns the number 1 which is seen 7x times. The closest number to it is 3 and 4 which are seen 3x times each.