MODE.MULT

Formulas / MODE.MULT
Calculate the most frequently occurring numbers in a data set.
=MODE.MULT(number1, [number2, ...])
  • number1 - required, first number argument
  • number2, ... - [OPTIONAL] additional number arguments, can be numbers, arrays, or references containing numbers

Examples

  • =MODE.MULT(A2:A11)

    This example uses the MODE.MULT function to find the modes of a data set with numbers 1-10. The example formula is above. This will return 1, 2, and 3 as the modes because they each appear 3 times in the data set.

  • =MODE.MULT(A2:A13)

    This example uses the MODE.MULT function to find the modes of a data set with numbers 1-10 and some repeats. The example formula is above. This will return 1, 2, and 3 as the modes because they each appear 3 times in the data set.

  • =MODE.MULT(A2:A14)

    This example uses the MODE.MULT function to find the modes of a data set with numbers 1-10 and some different numbers. The example formula is above. This will return 1, 2, and 3 as the modes because they each appear 3 times in the data set, while the other numbers appear less than 3 times.

  • =MODE.MULT(A2:A15)

    This example uses the MODE.MULT function to find the modes of a data set with numbers 1-10 and some different numbers and some repeats. The example formula is above. This will return 1, 2, and 3 as the modes because they each appear 3 times in the data set, while the other numbers appear less than 3 times.


Summary

The MODE.MULT function in Sourcetable is used to return an array of the most frequently occurring numbers in a numeric data set. It ignores empty cells, text values, and logical values TRUE and FALSE and will return a single result if there is only one mode in the data.

  • The MODE.MULT function returns an array of the most frequently occurring numbers in a numeric data set.
  • It ignores empty cells, text values, and logical values TRUE and FALSE.
  • The MODE function accepts up to 254 arguments; these can be numbers, names, arrays, or references.

Frequently Asked Questions

What is the MODE.MULT function?
The MODE.MULT function is one of Sourcetable's statistical functions. It is used to return an array of the most frequently occurring, or repetitive values in a range of data.
What types of arguments can be used with the MODE.MULT function?
The arguments for the MODE.MULT function can be numbers, arrays, or references.
Are all of the arguments in the MODE.MULT function numbers?
Yes, all of the arguments in the MODE.MULT function must be numbers.
Does the MODE.MULT function ignore certain types of data?
Yes, the MODE.MULT function ignores text, logical values, and empty cells.

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