How To Find Mode In Excel With Examples and Steps

In this tutorial, you will learn how to find Mode in excel with examples and simple steps. Thus we will describe different kinds of modes and use them in some instances.

Basically, we’ll describe first what is mode, thus organizations, and businesses use statistical data in decision-making and insights for their financial aspects

What is Mode?

Generally, a Mode is a frequently occurring number in a data set. A mode is simply a number that can easily find by counting how many times it occurs in a data set. Moreover, it is useful in statistical aspects which you can determine what is most popular item or rating in a survey, the most common grades students have.

Additionally, a data set can either have no mode, unimode ad two or more modes.

For example:

Kind of ModesValue
None1, 2, 3, 4, 6, 8, 9.
Unimodal: One mode found1, 2, 3, 3, 4, 5.
Bimodal: Two modes found1, 1, 2, 3, 4, 4, 5.
Trimodal: Three modes found1, 1, 2, 3, 3, 4, 5, 5.
Multimodal: More than one (two, three or more)1, 1, 2, 3, 3, 4, 5, 5, 7, 8, 9, 9

Note: Sometimes the mode is shortened to “mod”; Don’t confuse this with a calculus modulo function.

What is the mode function in Excel?

Excel’s mode function is similar to how it works in the median as measure of central tendency. For instance, in groups of numbers (5, 6, 7, 8, 9, 10) there is no mode because it frequently occurs once. Where in the set of numbers (10,10, 20, 30, 40) 10 is the mode because it appears twice.

Correspondingly, you may consider these several types of modes: No mode, Unimode, Bimodal, trimodal, and multimodal.

Another thing there are things to remember when using mode function in excel:

  • #NUM! error – Happens if there are no duplicates; hence, there is no mode within the supplied values.
  • #VALUE! error – Appears if a value supplied directly to the MODE is non-numeric and not part of an array. Non-numeric functions that are part of an array of values are ignored by the MODE function.
  • In Excel 2010, the MODE.SNGL function replaced the MODE function. However, current versions of excel still have the Mode function in order to provide compatibility with earlier versions. However, it’s possible that MODE function will not be available in the future so better to learn and use MODE.SNGL.



MODE Function Syntax Arguments

number1: Required. The first number argument for which you want to calculate the mode.

number2, …: Optional. Number arguments 2 to 255 for which you want to calculate the mode. You can also use a single array or a reference to an array instead of arguments separated by commas.

how to find the mode in excel

To find the Mode in Microsoft Excel, you can apply referencing by constant values. Therefore you can write the function as:

=MODE(first number, second number, …)

So this formula explains that your mode is from the input number or values in the function specifically if your reference is like (1, 3, 3,4,6,7). Therefore the functions will return 3 as the mode because the number appears frequently.

In addition, if the data you input has unknown number of modes you can use the MODE.MULT function as follow:

=MODE.MULT(first number, second number, …)

Aside from calculating modes using constant value referencing, you can also use reference which is a range of cells. So can use the given formula below:

=MODE(cell name:cell name)

Considering this method, you can yield mode in your worksheet without inputting constant values. If you expect multiple modes, this method can also use MODE.MULT function. This displays multiple modes if a dataset has them in the cell you designate and the cells below it, and you might write it as follows:

=MODE.MULT(cell name:cell name)

how to find multiple modes in excel

To understand the uses of the MODE.MULT function, let’s consider a few examples:

Suppose we are given the following data:


The formula to use is:


We get the result below:


Note: The MODE.MULT function returns an array of results and must be entered as an array formula. To confirm the function Press Ctrl+Shift+Enter, to return each selected cell a mode value if it does not exist.

how to find mean median and mode in excel

Average Function in Excel (Mean)

The average function in Excel is simple and often used especially in obtaining student grades. So, all you need to do is enter the formula and the range of cells. For instance the mean of the students below in their subjects.

Try this: =Average(F2:F44)


Median in Excel

The median function however is less complicated all you have to remember is when the given data set count is an odd number the middle value of the set is the median. On the other hand, if the data set count is even just get the average of the two middle values.

So we use =MEDIAN(F2:F44) to determine the median of the student average.


Mode in Excel

Meanwhile, if you want to know the element that occurs the most, the MODE function is a help. This is very crucial in working on a large amount of data and you want to know the frequently occurring value.

In our figure below, we use =MODE(F2:F44) and the mode of student average is 85.25.



In summary, finding mode in Excel is not that complicated. All you have to do is find the frequently appearing element on the data set. We hope you’ve learned and understood the concept of statistical function in Excel.

If you have more queries and suggestions regarding this topic, feel free to comment!

1 thought on “How To Find Mode In Excel With Examples and Steps”

Leave a Comment