MODE.MULT
Formulas / MODE.MULTCalculate 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?
What types of arguments can be used with the MODE.MULT function?
Are all of the arguments in the MODE.MULT function numbers?
Does the MODE.MULT function ignore certain types of data?
