The MODE.SNGL function is one of the three Excel functions that measure Central Tendency. The other two are the AVERAGE and MEDIAN functions. It calculates the most frequent value in a data set. It has the same syntax as the MODE function.
In statistics the Mode measure of central tendency is the only one that can be used with non-numeric values. Not in Excel though. Excel requires it to use numeric values.
The syntax of the function is the following:
MODE.SNGL(n1, [n2], …)
n1, n2, … : They are the for which you want to calculate the Mode.
n2, … : Optional arguments that can be up to a maximum of 255
IMPORTANT NOTICE:
Since Excel 2016 the MODE function has been replaced by the MODE.MULT function and MODE.SNGL function. The MODE function still exists for backwards compatibility but it is better to stop using it because it may not be available in future Excel versions.