How to Find Mean in Excel (Table of Content)
Introduction to Mean in Excel
The average function is used to calculate the Arithmetic Mean of the given input. It is used to do sum of all arguments and divide it by the count of arguments where the half set of the number will be smaller than the mean, and the remaining set will be greater than the mean. It will return the arithmetic mean of the number based on provided input. It is an in-built Statistical function. A user can give 255 input arguments in the function.
As an example, suppose there is 4 number 5,10,15,20 if a user wants to calculate the mean of the numbers then it will return 12.5 as the result of =AVERAGE (5, 10, 15, 20).
The formula of Mean: It is used to return the mean of the provided number where a half set of the number will be smaller than the number, and the remaining set will be greater than the mean.
The argument of the Function:
- number1: It is a mandatory argument in which functions will take to calculate the mean.
- [number2]: It is an optional argument in the function.
Examples on How to Find Mean in Excel
Here are some examples of how to find mean in excel with the steps and the calculation
Example #1 – How to Calculate the Basic Mean in Excel
Let’s assume there is a user who wants to perform the calculation for all numbers in Excel. Let’s see how we can do this with the average function.
Step 1: Open MS Excel from the start menu >> Go to Sheet1, where the user has kept the data.
Step 2: Now create headers for Mean where we will calculate the mean of the numbers.
Step 3: Now calculate the mean of the given number by average function>> use the equal sign to calculate >> Write in cell C2 and use average>> “=AVERAGE (“
Step 3: Now, it will ask for a number1, which is given in column A >> there are 2 methods to provide input either a user can give one by one or just give the range of data >> select data set from A2 to A11 >> write in cell C2 and use average>> “=AVERAGE (A2: A11) “
Step 4: Now press the enter key >> Mean will be calculated.
Summary of Example 1: As the user wants to perform the mean calculation for all numbers in MS Excel. Easley everything calculated in the above excel example, and the Mean is 27.5 for sales.
Example #2 – How to Calculate Mean if Text Value Exists in the Data Set
Let’s calculate the Mean if there is some text value in the Excel data set. Let’s assume a user wants to perform the calculation for some sales data set in Excel. But there is some text value also there. So, he wants to use count for all, either its text or number. Let’s see how we can do this with the AVERAGE function. Because in the normal AVERAGE function, it will exclude the text value count.
Step 1: Open MS Excel from the start menu >> Go to Sheet2, where the user has kept the data.
Step 2: Now create headers for Mean where we will calculate the mean of the numbers.
Step 3: Now calculate the mean of the given number by average function>> use the equal sign to calculate >> Write in cell D2 and use AVERAGEA>> “=AVERAGEA (“
Step 4: Now, it will ask for a number1, which is given in column B >> there is two open to provide input either a user can give one by one or just give the range of data >> select data set from B2 to B11 >> write in D2 Cell and use average>> “=AVERAGEA (D2: D11) “
Step 5: Now click on the enter button >> Mean will be calculated.
Step 6: Just to compare the AVERAGEA and AVERAGE, in normal average, it will exclude the count for text value so mean will high than the AVERAGE MEAN.
Summary of Example 2: As the user wants to perform the mean calculation for all number in MS Excel. Easley, everything calculated in the above excel example and the Mean is $146377.80 for sales.
Example #3 – How to Calculate Mean for Different Set of Data
Let’s assume a user wants to perform the calculation for some student’s mark data set in MS Excel. There are ten student marks for Math, English, and Science out of 100. Let’s see How to Find Mean in Excel with the AVERAGE function.
Step 1: Open the MS Excel from the start menu >> Go to Sheet3, where the user kept the data.
Step 2: Now create headers for Mean where we will calculate the mean of the numbers.
Step 3: Now calculate the mean of the given number by average function>> use the equal sign to calculate >> Write in F2 Cell and use AVERAGE >> “=AVERAGE (“
Step 3: Now, it will ask for number1 which is given in B, C, and D column >> there is two open to provide input either a user can give one by one or just give the range of data >> Select data set from B2 to D2 >> Write in F2 Cell and use average >> “=AVERAGE (B2: D2) “
Step 4: Now click on the enter button >> Mean will be calculated.
Step 5: Now click on the F2 cell and drag and apply to another cell in the F column.
Summary of Example 3: As the user wants to perform the mean calculation for all number in MS Excel. Easley, everything calculated in the above excel example and the Mean is available in the F column.
Things to Remember About How to Find Mean in Excel
- Microsoft Excel’s AVERAGE function used to calculate the Arithmetic Mean of the given input. A user can give 255 input arguments in the function.
- Half the set of a number will be smaller than the mean, and the remaining set will be greater than the mean.
- If a user calculating the normal average, it will exclude the count for a text value, so AVERAGE Mean will bigger than the AVERAGE MEAN.
- Arguments can be number, name, range or cell references that should contain a number.
- If a user wants to calculate the mean with some condition, then use AVERAGEIF or AVERAGEIFS.
Recommended Articles
This is a guide to How to Find Mean in Excel. Here we discuss How to Find Mean along with examples and a downloadable excel template. You may also look at the following articles to learn more –
23 Online Courses | 9 Hands-on Projects | 110+ Hours | Verifiable Certificate of Completion
4.9
View Course
Related Courses
