MODE.SNGL

Formulas / MODE.SNGL
Find 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?
The MODE.SNGL function is a statistical tool used to measure the central tendency of a data set. It returns the most frequently occurring value in an array or range of data.
What does the MODE.SNGL Function do?
The MODE.SNGL function returns the most frequently occurring value in an array or range of data. It can also be used to calculate the median, average, and most frequent number in a group of numbers.
What is the Central Tendency of a Data Set?
The central tendency of a group of numbers in a statistical distribution is located in the center of the group. The MODE.SNGL function measures the central tendency of a data set.
What Happens if the Data Set Does Not Contain Duplicate Data Points?
If the data set does not contain any duplicate data points, the MODE.SNGL function will return a #N/A error.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV