MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values in an array or data range in Excel

MODE.MULT function - The function returns a vertical array of the most common values in Excel
The MODE function (returns the value with the most frequent occurrence in an array or data range) in Excel

The following article introduces you to the MODE.SNGL function - one of the functions in the group of statistical functions that is very popular in Excel.

MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values in an array or data range in Excel Picture 1

Description: The function returns the most frequent value, or the most repeated value in an array or data range. Support functions from Excel 2010 onwards.

Syntax: MODE.SNGL (number1, [number2], .)

Inside:

- number1, [number2], .): The values that you want to find the median, where number1 is the required parameter, other values are optional and contain up to 254 number parameters .

Attention:

- The value of the argument must be a number, name, array or reference containing numbers.

- Arguments that are text or error values cannot be converted to a numeric type -> cause the function to cause an error .

- If the argument is a reference array containing text values or logic -> these values are ignored, but the value 0 is still counted.

- If the data set does not contain repeating data -> the function returns the # N / A error value .

For example:

Find the most common value among the values in the data table below:

MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values in an array or data range in Excel Picture 2

- In the cell to calculate enter the formula : = MODE.SNGL (D6: D15)

MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values in an array or data range in Excel Picture 3

- Press Enter -> the most common value is:

MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values in an array or data range in Excel Picture 4

- Where the most common number of values overlaps -> the function returns the value that appears first:

MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values in an array or data range in Excel Picture 5

- In this example, the values 5, 4, 3 are the values with the most and the same number of occurrences in the data table, but the value 5 appears first -> the function returns the value 5.

MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values in an array or data range in Excel Picture 6

- In case the array does not contain a repeating value -> the function returns the # N / A error value

MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values in an array or data range in Excel Picture 7

Above are instructions and some specific examples when using MODE.SNGL function in Excel.

Good luck!

Jessica Tanner

Update 19 May 2020

You should read it

May be interested

PROB function - The function returns the probability that values in a range are between two limits in Excel
prob function: the function returns the probability that values in a range are between two limits. syntax: prob (x_range, prob_range, [lower_limit], [upper_limit])
PERCENTILE function - The function returns the kth percentile in Excel
in mathematical computing, the percentile is a frequently applied process to study the percentile of values in a defined data set. the following article details how to use the percentile function to calculate the kth percentile value.
PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel
percentrank.inc function: the function returns the rank of a value in a dataset as a percentage including values 0 and 1. the function supports excel 2010 and later versions. syntax: percentrank.inc (array, x, [significance])
PERCENTRANK.EXC function - The function returns the rank of a value in a dataset as a percentage excluding values 0 and 1 in Excel
percentrank.exc function: the function returns the rank of a value in a dataset as a percentage excluding values 0 and 1. the function supports excel 2010 and later versions. syntax: percentrank.exc (array, x, [significance])
LOOKUP function searches in Excel
the lookup () function returns a value from a data range consisting of 1 column or 1 row, or from an array. the lookup () function is an improvement of the two functions vlookup () and hlookup () because it has the additional function to distinguish the search area as rows or columns.
Instructions for using Index function in Excel
index is a function that returns an array in excel. when using the index function, you get the values in a cell between the column and the row.
LOGEST - The function returns an array of data that describes an exponential curve that fits the data given in Excel
logest: the function returns the data array that describes the exponential curve that fits the given data. - the equation of the curve is: y = b * m ^ x or y = (b * (m1 ^ x1) * (m2 ^ x2) * _) syntax: logest (known_ys, [known_xs], [const], [ stats])
TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel
trimmean function: the function returns the average of the inside of the data set. the function calculates by removing which percentage of the value is in the first or last boundary of the data set. syntax: trimmean (array, percent)
RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values with the same rank in Excel
rank.eq function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the highest rank. support functions from execl 2010 version onwards.
How to use the SUMIF function in Excel
the sumif function in excel is a function used to compute values in a specified range. the sumif function can be used for summing cells based on the date, data and text that are connected to the specified area.