How to find mean in Excel ?
|
Excel
|
6 months ago
|
Excel
6 Steps
This document will teach you how to calculate the mean, or average, of a set of numbers in Excel. You'll learn how to use the AVERAGE function, as well as a quick shortcut using the AutoSum button. This document is perfect for anyone who needs to calculate averages in Excel, from students to business professionals.
How to find mean in Excel ?
|
Excel
|
Excel
6 Steps
1
Start your Microsoft Excel
Open the application where you want to calculate the mean.
2
Input your "Data" in a column.
For example, enter numbers in cells A1 to A5: (10,20,30...)
3
Click on a "Blank" cell where you want the mean to appear.
For instance, click on cell B1.
4
In the selected "Cell", type the formula "=AVERAGE(A1:A5)".
This formula tells Excel to calculate the average of the values in cells A1 through A5.
5
Hit the "Enter" key on your keyboard.
6
Excel will compute the "Mean" and display the result in the selected cell (B1).
For the example data, it should show 30.
