How to Calculate Mode Using Excel

1. Add the numbers in the first column of your Excel 2007 document. For example, add the numbers 9,6,5,9,4,9,2 and 1 in A2, A3, A4, A5, A6, A7, A8 and A9.
2. For this example, click on the 'A11' cell. This is the cell where you will calculate the mode. When you calculate another mode, choose any cell at the bottom of the list of numbers you are using.
3. Click 'Insert Function' on the top, left-hand side of the Excel spreadsheet. The 'Insert Function' window will pop open. With Microsoft Excel 2007, click on the 'Formulas' tab and then 'Insert Function.'
4. Click on the drop-down menu of 'Or select a category.' Select 'Statistical' from the drop-down menu.
5. Scroll down the 'Select a function' window. Choose 'MODE,' which is the function of mode.
6. Click 'OK.' The 'Functions Arguments' window will pop open. Ensure that on 'Number 1' cell, A2:A9 is populated. If A2:A9 is not populated, enter A2:A9 manually. Click 'OK.'
7. The mode has been successfully calculated. In this example, the calculated value of the mode is 9.