The MODE 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.
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(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 this function has been replaced by the MODE.MULT function and MODE.SNGL function. The function still exists for backwards compatibility but it is better to stop using it because it may not be available in future Excel versions.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of the three measures of Central Tendency:
Calculate the central tendency of the values in the cell range B3:M6 using the most common measures of central tendency.
Calculate the central tendency using the average measure in the cell B9, the median measure in B10 and the mode measure in B11.