# How to Find Mean, Median, and Mode on Excel: 3 Easy Methods

### Method 1 – Utilizing AVERAGE Function to Find Mean in Excel

• Choose the C19 cell.
• Write down the following formula by selecting the range from C5 to C17 to calculate the mean.
`=AVERAGE(C5:C17)`
• Click ENTER.

• The following result is for the mean value in the below image.

### Method 2 – Using MEDIAN Function to Calculate Median in Excel

• Pick the C19 cell first.
• Use the range C5 to C17 to determine the median, and note down the formula below.
`=MEDIAN(C5:C17)`
• Press ENTER.

• Observe the final outcome of the median value here.

### Method 3 – Applying MODE Function to Find Mode in Excel

#### 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 C19 first.
• Calculate the mode using the range C5 to C17 and write down the formula below.
`=MODE.SNGL(C5:C17)`
• Click on the CTRL+ ENTER from the keyboard shortcut.

• The below image displays the value of mode in the C19 cell here.

#### 3.2 Using MODE.MULT Function

• Select some cells to use the MODE.MULT function.

• Choose the C19 cell.
• Write down the following formula by choosing the range from C5 to C17 to evaluate the multiple modes of this range.
`=MODE.MULT(C5:C17)`
• Press the CTRL+SHIFT+ENTER from the keyboard.

• There are two modes for this range from C5 to C17 cell.

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

## Related Articles

<< Go Back to Excel for StatisticsÂ |Â Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Taryn Nefdt

Taryn is a Microsoft Certified Professional, who has used Office Applications such as Excel and Access extensively, in her interdisciplinary academic career and work experience. She has a background in biochemistry, Geographical Information Systems (GIS), and biofuels. She enjoys showcasing the functionality of Excel in various disciplines. She has over ten years of experience using Excel and Access to create advanced integrated solutions.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF