MODE.SNGL Function

Basic Description

The Excel MODE.SNGL 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 Mode.Sngl function is new in Excel 2010 and so is not available in earlier versions of Excel. However, the function is simply a renamed version of the Mode function that is available in earlier versions of Excel.

Syntax: MODE.SNGL( number1, [number2], … )

where the number arguments are up to 255 numeric values, or arrays of numeric values, for which you want to calculate the mode.

 

Mode.Sngl Function Examples

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

There are 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.SNGL( 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

 

Mode.Sngl Function Errors

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

#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.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment