Excel 2007 MODE Function

The MODE function, one of Excel's statistical functions, tells you the most frequently occurring value in a list of numbers.

The syntax for the MODE function is:

= MODE ( number1, number2, ... number255 )

Note: Up to 255 numbers can be entered into the function.

Example Using Excel's MODE Function:

Note: For help with this example, see the image above.

1. Enter the following data into cells D1 to D6: 98, 135, 147, 135, 98, 135.
   
   
2. Click on cell E1 - the location where the results will be displayed.
   
   
3. Click on the Formulas tab.
   
   
4. Choose More Functions > Statistical from the ribbon to open the function drop down list.
   
   
5. Click on MODE in the list to bring
   up the function's dialog box.
   
   
6. Drag select cells D1 to D6 in the spreadsheet to enter the range into the dialog box.
   
   
7. Click OK.
   
   
8. The answer 135 should appear in cell E1 since this number appears the most (three times) in the list of data.
   
   
9. When you click on cell E1 the complete function = MODE ( D1 : D6 ) appears in the formula bar above the worksheet.

Note: If the selected data range contains no duplicate data, the MODE function will return a #N/A error.

• Excel 2007 MEDIAN Function
• Excel 2007 AVERAGE Function
• Excel 2007 MAX Function