This article is about how to Return the mean in Microsoft Excel. The universally accepted mean is the arithmetic mean, and Excel uses the mean function to find it. Excel’s mean function is used to generate a number that represents a typical value from a range, distribution, or list of numbers. It is calculated by adding all the numbers in the list and then dividing the total by the number of values in the list.
While you can easily calculate the mean of a small group of simple numbers, there are programs like Microsoft Excel that can calculate the mean of large data sets and reduce human error. Below we have mentioned the steps to return mean in Microsoft Excel.
3 ways to return the mean in Microsoft Excel
Calculate mean in Excel with ribbon option
- To use it, first, open the spreadsheet with your numbers in Microsoft Excel. In your spreadsheet, select the numbers for which you want to find the average.
- On the Excel ribbon at the top, clickHome” tab.
- on top of that”Home” tab, from the “Editing” section, select the down-arrow icon next to the “Sum” option.
- In the expanded menu, click “Average” to find the average for your numbers.
- At the end of the cells you selected, you’ll see the average for your numbers.
- Similarly, you can calculate the average in Excel.
Calculate the mean in Excel including zeros
- To use the function, first, open your spreadsheet with Microsoft Excel. In your spreadsheet, click the cell where you want to display the resulting average.
- In the selected cell, type the following function and press Enter. In the process replace C2 and C5 with the range where your numbers are.
- If your numbers are in non-consecutive cells, enter those cells separately in the average function. Separate the cells with commas as follows:
- If you want to directly use the numbers in the function, enter your numbers in the function below. Separate your numbers with commas.
- After typing the formula press Enter and you will see the average for your numbers in the cell you selected.
Calculate mean excluding zeros in Excel
- First, open your spreadsheet with Microsoft Excel. Then select the cell where you want to display the result.
- In the selected cell, type the following function and press Enter. In this process, replace C2 and C5 in the range where your numbers are.
- Excel will calculate the average, ignoring cells that contain zeros.
We hope you will understand and enjoy this article How to Return the mean in Microsoft Excel. The mean function calculates the mean of the numbers provided as arguments. To calculate the average, Excel adds all the numeric values and divides them by the number of numeric values. AVERAGE takes multiple arguments in the form number1, number2, number3, etc. up A total of 255. Arguments include numbers, cell references, ranges, arrays, and constants. Blank cells and cells containing text or logical values are ignored.
About This Guide?
In this guide, we told you about the How to Return Averages in Microsoft Excel; please read all steps above so that you understand How to Return Averages in Microsoft Excel in case if you need any assistance from us, then contact us.
How this tutorial or guide assisting you?
So in this guide, we discuss the How to Return Averages in Microsoft Excel, which undoubtedly benefits you.
Share this article about How to Return Averages in Microsoft Excel
I hope you like the guide How to Return Averages in Microsoft Excel. In case if you have any queries regards this article/tutorial you may ask us. Also, share your love by sharing this article with your friends and family.
#Return #Averages #Microsoft #Excel