How to calculate Modal?

The modal is the number that most often appears. We are going to learn how to calculate the modal with these simple steps.

Data preparation

Spread out the numbers in the same role, for your convenience.

modal data

Note: The spread numbers should have at least 2 numbers that are the same.

Modal calculations

Click on a blank column, and type in =MODE(choose all the columns with numbers, ex. a5:a15), and then press enter. In this case, 4 is the modal.

modal formula

Note: Use =Mode.Mult(columns ex. C1:C34) if there are more than two modals.

Modal formula in this example is =MODE(A1:A10)

You can download a free Modal Calculator template here