The MODE.MULT function

The MODE.MULT function is a statistical function which will return the values that occur most frequently from a set of values, or range of cells. If there is more than one value that occurs the same number of times, they will all be displayed as long as it is submitted as an array formula over a large enough range of cells.

This is the format of the MODE.MULT function:

=MODE.MULT(VALUE 1, VALUE 2, etc…)

Here is an example of the MODE.MULT function:

=MODE.MULT(12, 56, 48, 64, 65, 12, 56, 48) = {12, 56, 48} 

MODE.MULT returning the three found modes within the data, and returning an error for the non-existing fourth mode

This function is valuable when taking on any statistical analysis with a large sample size. The mode of a sample of data should be able to signal something about the data being looked at. While it may not provide a definitive answer, it can lead to more critical analysis.

An example of a functional implementation of this would be during an analysis taking the baseline measurements of all variables within the data. This would include the minimum, maximum, median, average, and mode(s). In the case of a variable such as articles per transactions, the modes can indicate an important shopping trend which you can use to your advantage.

=MODE.MULT(RANGE WITH ARTICLES PER TRANSACTION)