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.

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.

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

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