Finding a means to determine the “typical” value is something you might frequently do while evaluating numerical data. You can use the so-called measures of central tendency for this purpose, which represent a single value designating the middle or center of a statistical distribution or, more precisely, the central location inside a data set. They are sometimes categorized as summary statistics. **Mean**, **Median**, and **Mode **are the three primary metrics for assessing central tendency. Each of them provides a distinct indication of a typical value and depending on the situation, some measures are more appropriate to use than others. They are all valid measurements of the central position. In this article, we will show you how to find the **Mean**, **Median**, and **Mode **on Excel.

**Table of Contents**hide

**Download Practice Workbook**

You may download the following Excel workbook for a better understanding and to practice yourself.

## 3 Handy Approaches to Find Mean, Median, and Mode on Excel

The terms “measures of central tendency” are frequently used to describe the mean, median, and mode, which provide details about a distribution’s center. In the following methods, you will learn to calculate the **Mean **using* the AVERAGE function*, determine the

**Median**utilizing

*and evaluate the Mode applying*

**the MEDIAN function****the MODE.SNGL function**and

**the MODE.MULT function**in

**Excel**. Let’s suppose we have a sample data set.

### 1. Utilizing AVERAGE Function to Find Mean in Excel

The average of a set of numbers is referred to as the arithmetic mean, and it is calculated by adding all the numbers in the data set and then dividing by the count of the actual numbers in the data set. With the average, the advantage is that all the numbers in the data set are incorporated in the final computation. The disadvantage of the average is that very large or very small values can distort the average value. These values are referred to as outliers, and they have the most significant impact on the average value.

- Firstly, choose the
cell.*C19* - Then, write down the following formula by selecting the range from
to*C5*to calculate the mean.*C17*

`=AVERAGE(C5:C17)`

- Besides, click
.*ENTER*

- Finally, you will see the following result for the mean value in the below image.

### 2. Using MEDIAN Function to Calculate Median in Excel

The **median** describes the value which is at the center of the data set, basically. Half the numbers are greater than the median and the other half are less than the median. The median is not affected by outliers as much as the average is, which is an advantage. However, for very large data sets such as those obtained from a census, the median can take a long time to compute.

- Pick the
cell first.*C19* - Then, use the range
to*C5*to determine the median, and note down the formula below.*C17*

`=MEDIAN(C5:C17)`

- Additionally, press
**ENTER**

- As a result, you will observe the final outcome of the median value here.

**Similar Readings**

**How to Use VAR Function in Excel (4 Examples)****Use PROB Function in Excel (3 Examples)****How to Use Excel STDEV Function (3 Easy Examples)****Use Excel GROWTH Function (4 Easy Methods)****How to Use Excel FREQUENCY Function (6 Examples)**

### 3. Applying MODE Function to Find Mode in Excel

The mode describes the value which occurs most often in a specific datase**t.** Later versions of **Excel** have two * MODE functions*, namely

**the MODE.SNGL function**and

**the MODE.MULT function**. The advantage of the mode is that it is not affected by outliers as dramatically as the average either. However, at times, a data set may not contain a mode.

#### 3.1 Inserting MODE.SNGL Function

**The MODE.SNGL function** returns a single value, and this value is the most frequent value in the dataset.

- Select cell
first.*C19* - After that, calculate the mode using the range
to*C5*and write down the formula below.*C17*

`=MODE.SNGL(C5:C17)`

- Then, click on the
from the keyboard shortcut**CTRL**+**ENTER****.**

- Consequently, the below image displays the value of mode in the
cell here.*C19*

#### 3.2 Using MODE.MULT Function

**The MODE.MULT** function returns a vertical **array **of the most frequently occurring values in a set. Sometimes data sets have more than one mode, so **the MODE.MULT function** accommodates this situation.

- Here, select some cells to use
**the MODE.MULT function**.

- Firstly, choose the
cell.*C19* - Then, write down the following formula by choosing the range from
to*C5*to evaluate the multiple modes of this range.*C17*

`=MODE.MULT(C5:C17)`

- After that, press the
from the keyboard.**CTRL+SHIFT+ENTER**

- Lastly, you will notice here that there are two modes for this range from
to*C5*cell.*C17*

**Read More:** **How to Use MODE Function in Excel (4 Examples)**

## Conclusion

In this article, we’ve covered 4 handy approaches to calculating mean, median, and mode in** Excel. **sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on **Excel**, you may visit our website, **ExcelDemy**. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.

## Related Articles

**How to Use MAX Function in Excel (6 Examples)****Use SMALL Function in Excel (4 Common Examples)****How to Use COUNTIFS Function in Excel (4 Examples)****Use COUNTA Function in Excel (3 Suitable Examples)****How to Use Different Types of COUNT Functions in Excel (5 Ways)****How to Use PERCENTILE Function in Excel (With an Example)**