The MODE.SNGL function

The MODE.SNGL function is a statistical function which will return the value that occurs 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, only the first one will be returned.

This is the format of the MODE.SNGL function:

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

Here is an example of the MODE.SNGL function:

=MODE.SNGL(12, 56, 48, 64, 65, 12, 12, 56, 48) = 12 

MODE.SNGL returning the first mode found within the range of cells

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 sale price, the mode can indicate what price points best resonate with your current client base.

=MODE.SNGL(RANGE WITH SALES PRICE PER UNIT)