1. Computing

Excel 2007 MODE Function

Find the Most Common Number in a List of Data

By

Excel 2007 MODE Function

Excel 2007 MODE Function

© Ted French

Note: As of Excel 2010, the MODE function has been replaced by the MODE.SNGL and MODE.MULT functions.

The mode, which is the most frequently occurring value in a list of numbers, is usually considered, along with the mean and median, to be a measure of the average value for that list.

Using the MODE function in Excel makes it easy to find the value that occurs most often.

The MODE Function's Syntax and Arguments

A function's syntax refers to the layout of the function and includes the function's name, brackets, and arguments.

The syntax for the MODE function is:

= MODE ( Number1, Number2, ... Number255 )

Number - (required) the values (to a maximum of 255) for which you want to calculate the mode. This argument can contain the actual numbers - separated by commas - or it can be a cell reference to the location of the data in the worksheet.

Example Using Excel's MODE Function:

  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 open the function's dialog box

  6. Highlight cells D1 to D6 in the worksheet to enter the range into the dialog box

  7. Click OK to complete the function and close the dialog box

  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.

©2014 About.com. All rights reserved.