Microsoft Excel Logo

Finding the mean comes in handy when processing and analyzing all kinds of data. With Microsoft Excel’s AVERAGE function, you can quickly and easily find the mean for your values. We’ll show you how to use the function in your spreadsheets.

How Microsoft Excel Calculates the Mean

By definition, the mean for a data set is the sum of all the values in the set divided by the count of those values.

For example, if your data set contains 1, 2, 3, 4, and 5, the mean for this data set is 3. You can find it with the following formula.

(1+2+3+4+5)/5

You could type out formulas like that yourself, but Excel’s AVERAGE function helps you perform this calculation with ease.

Find the Mean Using a Function in Microsoft Excel

In our example, we’ll find the mean for the values in the “Score” column, and display the answer in the C9 cell.

Advertisement

We’ll start by clicking the C9 cell where we want to display the resulting mean.

Click the C9 cell in Excel.

In the C9 cell, we’ll type the following function. This function finds the mean for the values in all the cells between C2 and C6 (both these cells included).

=AVERAGE(C2:C6)

Enter the AVERAGE function in the C9 cell in Excel.

Press Enter and the result will appear in the C9 cell.

The resulting mean in the C9 cell in Excel.

You can use the AVERAGE function to find the mean for any values in your spreadsheet. Enjoy!


Getting the mean will come in handy if you ever need Excel to calculate uncertainty.

RELATED: How to Get Microsoft Excel to Calculate Uncertainty

Profile Photo for Mahesh Makvana Mahesh Makvana
Mahesh Makvana is a freelance tech writer who specializes in writing how-to guides. He has been writing tech tutorials for over a decade now. He’s written for some of the prominent tech sites including MakeUseOf, MakeTechEasier, and Online Tech Tips.
Read Full Bio »

The above article may contain affiliate links, which help support How-To Geek.