by The MODE.SNGL function returns the most frequently occurring, or repetitive, value in an array or range of data.
Syntax:= MODE.SNGL(number1,[number2],…)
The MODE.SNGL function syntax has the following arguments:
- Number1 Required. The first argument for which you want to calculate the mode.
-
Number2, … Optional. Arguments 2 to 254 for which you want to calculate the mode. You can also use a single array or a reference to an array instead of arguments separated by commas.
Example: Let’s look at some Excel MODE.SNGL function examples and explore how to use the MODE.SNGL function as a worksheet function in Microsoft Excel:
Here I have a small list of numbers that represent ranks given by users of services. I want to look up the frequently given rank.
Syntax: =MODE.SNGL(A2:A17)
Result: 95
Remember in the MODE.SNGL function, if there are two or more most frequently occurring values in the supplied data, then it will return the lowest of the values.
Note:
- #N/A! error – Occurs when there are no duplicates in the values provided.
- #VALUE! error – Occurs when the value provided to the function is non-numeric. Non-numeric functions that are part of an array of values are ignored by the MODE.SNGL function.
- Arguments can either be numbers or names, arrays, or references that contain numbers.
- If an array or reference argument contains text, logical values, or empty cells, the values are ignored; however, cells with the value zero are included.
- Arguments that are error values or text that cannot be translated into numbers cause errors.
- The MODE.SNGL function measures central tendency, which is the location of the center of a group of numbers in a statistical distribution.
