How to Calculate Mean Using Keyboard shortcuts
In this method first, you need to select the cells for which you have to calculate the average. Then select the INSERT function from the formulas tab, a dialog box will appear.
Select the AVERAGE function from the dialog and enter the cell range for your list of numbers in the number1 box. For example, if you need values from column A and from row 1 to row 10 then simply enter A1:A10. You can also simply drag and drop the selected cells and click OK. The result will be shown in the cell you have selected.
How to Calculate Mean, Median and Mode in Excel
The mean (also called average) of the data set is calculated by adding all the numbers in the data set and then dividing it by the total number of values in the data set. In this article, we will find out how to calculate the mean in Excel.
Contact Us