MODE.SNGL
Formulas / MODE.SNGLFind the most frequently occurring number in a set of numbers.
MODE.SNGL(number1, [number2], [number3], [number4], [number5], [number6], [number7], [number8], [number9], [number10], [number11], [number12], [number13], [number14], [number15], [number16], [number17], [number18], [number19], [number20], [number21], [number22], [number23], [number24], [number25], [number26], [number27], [number28], [number29], [number30], [number31], [number32], [number33], [number34], [number35], [number36], [number37], [number38], [number39], [number40], [number41], [number42], [number43], [number44], [number45], [number46], [number47], [number48], [number49], [number50])
- number1 - required, first argument
- number2, ... - [OPTIONAL] additional arguments, can be numbers, arrays, or references
Examples
MODE.SNGL(A2:A7)The MODE.SNGL function can be used to find the most frequent value in a range of numbers. For example, if the range of numbers A2:A7 is 3, 6, 5, 7, 4, 4, the formula will return the number 4 since it is the most frequently occurring number in the range.
MODE.SNGL(A2:A7)The MODE.SNGL function can also be used to find the most frequent text in a range. For example, if the range of text A2:A7 is “Banana, Apple, Orange, Pear, Apple, Orange “, this will return the text “Apple†since it is the most frequently occurring text in the range.
MODE.SNGL(A2:A7)The MODE.SNGL function will return the first value in the range if there is a tie for the most frequently occurring value. For example, if the range of numbers A2:A7 is “3, 6, 5, 5, 4, 4 “, this will return the number 5 since it is the first value that occurs twice in the range.
MODE.SNGL(A2:A7)The MODE.SNGL function will return the #N/A error if there is not a single most frequently occurring value in the range. For example, if the range of numbers A2:A7 is “3, 4, 5, 6, 7, 8 “, this will return #N/A.
Summary
The MODE.SNGL function is a statistical function in Sourcetable that returns the most frequently occurring number in a data set. It can take numerical arguments or references to numerical arrays as arguments, and ignores text, logical values, and empty cells that are in references. This function was introduced in MS Excel 2010.
- The MODE.SNGL function takes up to 254 arguments and can be numbers, names, arrays, or references.
- The function ignores empty cells, text values, and logical values TRUE and FALSE.
- It returns an #N/A error if there are no duplicate numbers in the data set.
Frequently Asked Questions
What is the MODE.SNGL Function?
What does the MODE.SNGL Function do?
What is the Central Tendency of a Data Set?
What Happens if the Data Set Does Not Contain Duplicate Data Points?
