The Excel MODE Function

Related Functions:
AVERAGE Function
MEDIAN Function

MODE & MODE.SNGL Functions

In Excel 2010, the MODE function has been renamed as MODE.SNGL.

Although it has been replaced, the Mode function is still available in Excel 2010 (stored in the list of compatibility functions), to allow compatibility with earlier versions of Excel.

Basic Description

The Excel MODE function returns the statistical mode (the most frequently occurring value) of a list of supplied numbers. If there are 2 or more most frequently occurring values in the supplied data, the function returns the lowest of these values

The format of the function is :

MODE( number1, [number2], ... )

where the number arguments are a set of one or more numeric values, or arrays of numeric values, for which you want to calculate the mode. In Excel 2007 and Excel 2010, you can supply up to 255 number arguments to the Mode function, but in Excel 2003, the function can only accept up to 30 number arguments.

Text and logical values within a supplied array are ignored by the function.


Mode Function Examples

The following example shows the Mode function, used to calculate the mode of the set of values in cells A1 - A10.

The data has two statistical modes, 3 and 4, and so the Mode.Sngl function returns the lowest of these two values.

 Formulas:
  A B
1         1 =MODE( A1:A10 )
2 1  
3 2  
4 2  
5 3  
6 3  
7 3  
8 4  
9 4  
10 4  
 Results:
  A B
1         1         3   - Returns the lowest of the two Modes, 3 and 4
2 1  
3 2  
4 2  
5 3  
6 3  
7 3  
8 4  
9 4  
10 4  

Further information and examples of the Excel Mode function can be found on the Microsoft Office website.


Mode Function Errors

If you get an error from the Excel Mode function this is likely to be one of the following:

Common Errors
#NUM! - Occurs if there are no duplicates (and there is therefore no mode) within the supplied values
#VALUE! - Occurs if a value that is supplied directly to the function (i.e. not part of an array of supplied values) is non-numeric.

Return to the Excel Statistical Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014 ExcelFunctions.net