The most frequent number

Today, we want to find the most fre­quent value/number.

From sta­tis­ti­cal point of view, we want to find a dom­i­nant. This task is quite easy in Excel, how­ev­er there are some nuances. It’s easy thanks to the MODE func­tion. We can use it to find a sin­gle dom­i­nant. In this func­tion, we just select the range, and Excel will quick­ly cal­cu­late it for us (Fig. 1)

=MODE(A2:A9)

We have to remem­ber that while using the MODE or MODE.SNGL func­tion, Excel will return only one num­ber. It means that we can­not be sure that only this num­ber is the most fre­quent one. There is a way out, as we also have the MODE.MULT func­tion (Fig. 2)

=MODE.MULT(A2:A9)

After using this func­tion, we can see that in our exam­ple there are two most fre­quent num­bers: 5 and ‑1. The MODE func­tion showed only the num­ber that appeared at the begin­ning of the range. When I change the order of the two first num­bers in the range, we can see that now the MODE.SNGL func­tion returns ‑1. The MODE.MULT func­tion will still return two num­ber, how­ev­er in dif­fer­ent order (Fig. 3). 

When we use the MODE.SNGL func­tion in a range where there isn’t any most fre­quent num­bers and each num­ber occurs only once, the func­tion will return the #N/A error. In our range of Wages, each wage appears only once (Fig. 4)

https://www.youtube.com/watch?v=XZs8lwM7Oqg