Excel Functions Tutorials

- Maths Functions in Excel
- ABS Function in Excel
- AGGREGATE Excel Function
- CEILING Excel Function
- COMBIN Excel Function
- COS Excel Function
- DSUM
- EVEN Function in Excel
- EXPONENTIAL Excel Function
- Excel Matrix Multiplication
- Excel Minus Formula
- FLOOR Function in Excel
- Histogram Formula
- INT Excel Function (Integer)
- LN Excel Function
- LOG Excel Function
- Mode in Excel
- ODD Function in Excel
- POWER Function in Excel
- PRODUCT Excel Function
- PRODUCT Formula in Excel
- PI in Excel
- Quotient in Excel
- Running Total in Excel
- RAND Excel Function
- Rand Excel Formula
- RANDBETWEEN in Excel
- MROUND in Excel
- ROUND in Excel
- ROUND Formula in Excel
- ROUNDDOWN Excel Function
- ROUNDUP Function in Excel
- SIGN Excel Function
- SIN Excel Function
- Square Root in Excel (SQRT)
- SUBTOTAL Excel Function
- SUM Function in Excel
- SUM Formula in Excel
- Excel SUM Shortcut
- SUMIF in Excel
- SUMIFS in Excel
- SUMIF Not Blank
- SUMIFS with Dates
- SUMIF Between Two Dates
- Sumif Text in Excel
- SumIf with Multiple Criteria
- SUMPRODUCT Function in Excel
- SUMPRODUCT Formula in Excel
- SUMPRODUCT with Multiple Criteria
- How to Sum Multiple Rows in Excel?
- TAN Excel Function
- TANH in Excel
- Average vs Weighted Average

- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- Excel Tips (178+)
- VBA (162+)

Related Courses

**Table of Contents**

## What is Mode Formula in Excel?

The mode refers to the most frequently occurring number in a data set. Frequently used in statitstics, it is the value that appears the most number of times in a data set. The mode is also known as ‘modal value’ which refers to the highest count of occurrences in the data group. Similar to the statistical tools mean and median, the mode is a value that represents the entire data set.

In the majority of the cases, there is only one mode. However, in certain cases, there can be more than one mode in a data set. Data set is known as bimodal if there are two modes.

Mode Formula in Excel is represented as follows,

### Explanation of the Mode Formula in Excel

In order to find the mode, you need to collect and organize data so that you can count the frequency of each result. The result which has the highest count of occurrences is the mode. In certain cases, the frequency of each occurrence has already been calculated. In such a case, the value corresponding to the highest frequency is the mode.

### Examples of Mode Formula (with Excel Template)

Let’s see some simple to advanced examples of Mode equation to understand it better.

#### Mode Formula in Excel – Example #1

**Find the mode from the following data: 12, 13, 10, 10, 8, 10, 7, 7, 9, 10**

**Solution:** We will first organize the data so that the calculation of mode becomes easy. The data is as follows: 7, 7, 8, 9, 10, 10, 10, 10, 12, 13.

Using the above-given information we will do the calculation of mode as follows,

Therefore, calculation using mode formula in excel will be as follows,

**Mode will be –**

Hence, mode =** 10**

We can observe that the number 7 occurs twice in the data set, the numbers 8 and 9 occur only once in the data set, the number 10 occurs four times in the set, the numbers 12 and 13 occur only once in the mentioned data set.

4.9 (1,353 ratings)

We need to look for the value that has been repeated the most number of times*.* We find that the frequency of the number 10 has been the most in this set.

**Note**: Even by merely inspecting the data, some people will be able to locate the mode, which is 10.

#### Mode Formula in Excel – Example #2

**Tom is the owner of a shoe store. He is facing a typical business problem. Certain popular shoe sizes go out of stock too soon. Hence, customers complain that the shoe size they require is not available for purchase. Tom wants to find out which is the most popular shoe size so that he can cater to his clients. Calculate the mode in excel from the following data to help Tom determine the most popular shoe size: Shoe Sizes: 6, 8, 7, 7, 9, 7, 10, 8, 7, 9.**

**Solution: **We will first organize the data so that the calculation of mode becomes easy. The organized data is as follows: 6, 7, 7, 7, 7, 8, 8, 9, 9, 10

Below is given data for calculation of mode in excel of a shoe store.

Therefore, calculation ousing mode formula will be as follows,

**Mode of shoe store will be –**

Hence, mode = **7**

We find that shoe size 6 occurs once, 7 occurs four times, 8 occurs twice, 9 occurs twice and 10 occurs once. From this observation, we can infer that the shoe size 7 occurs the most number of times (four times).

Clients purchase number of shoes of size 7 and hence Tom would have to ensure that this shoe size is always in stock due to higher demand.

#### Mode Formula in Excel – Example #3

**Martha Smith is a wheat merchant. Her employee points out that the majority of customers demand wheat in bags of a certain weight as it is convenient for them to carry. Find out what is the weight of bags demanded by most customers from the following data:**

Below is given data for calculation of the weight of bags

Therefore, calculation of maximum frequency will be as follows,

**Maximum frequency will be –**

Maximum frequency =**32**

We need to find out the highest frequency from the above weights. It can be seen that the highest frequency is 32 and the weight that corresponds to the highest frequency is 10 kg. Hence, the mode is 10 kg.

Therefore, the weight of bags demanded by most customers is 10 kg.

Note: It is important to note that 32 (highest frequency) is not the mode. The weight that corresponds to the highest frequency that is 10 kg is the mode. 32 is merely the highest number of occurrences.

#### Mode Formula in Excel – Example #4

**The Statistical Department of a town was of the view that the people in the town have too many children. It commissioned a survey to find out the number of children that the couples had. The surveyors went to each house and asked the people for information related to the number of children that they had. The results of the sample survey showing the number of children that each person has are as follows: 3, 2, 0, 1, 3, 4, 2, 6, 2, 2, 4, 2. Calculate the mode in excel from this data.**

**Solution**: In Excel, there is an inbuilt formula for a mode that can be used to calculate the mode of a group of numbers. Select a blank cell and type this formula =MODE.SNGL(B2: B13) (B2: B13 indicates the range you want to calculate mode from). The mode is 2 children.

Using the above-given information we will do the calculation of mode as follows,

Therefore, calculation using mode formula in excel will be as follows,

**Mode will be –**

**Mode = 2**

**Note:** The formula MODE(Range of Cells) can also be used. It is a Compatibility function for older versions of Excel. However, Excel recommends the use of MODE.SNGL function.

### Relevance and Uses of Mode Formula in Excel

The mode is an easy statistical tool that can be used for a measure of central tendency. It is very simple to calculate the mode equation. In certain cases, it can even be located by merely inspecting the data. The mode is not affected by outliers, which refer to extremely large

The mode can also be used for qualitative data and labels. Qualitative data contains attributes such as good/bad/average or high/low or male/female etc. For instance, let us assume 3 people rated the quality of restaurant food as ‘good’, 2 as ‘average’ and 7 as ‘bad’. In such a case, the bad quality of food is the mode as it has the most number of occurrences. Please note that mean cannot be calculated in such a case involving qualitative data. Hence, the mode is used.

While we are analyzing the prices of goods sold, most of the goods are sold at a particular price point. It may to futile to calculate mean in such a case. The price that most customers paid is useful in framing the pricing policy of products.

### Recommended Articles

This has been a guide to Mode Formula in Excel. Here we discuss how to calculate Mode in Excel along with the practical examples and downloadable excel template. You can learn more about accounting from the following articles –

- Outlier Formula
- Formula of Quartile Deviation
- Quartile Formula
- Moving Average in Excel
- QUARTILE Function in Excel
- MEDIAN in Excel
- FORECAST in Excel

- 35+ Courses
- 120+ Hours
- Full Lifetime Access
- Certificate of Completion