Excel Average Function
The Excel AVERAGE function helps you get the average sum of the selected numbers provided on an Excel spreadsheet. This is fairly a common function in the Excel app and it is typified as the Statistical Function. The Excel AVERAGE function is really an easy way to get straight to the Average sum on any Excel task.
AVERAGE( number1, [number2], ... [number_n] )
The Excel Average Function is quite useful when you want to mark out a line of basic expectation from an outcome. A perfect instance of this is trying to get the average expected score of students. In a group of students with varying exam scores, you want to get the average score that applies to all of them.
The average score in this instance will be the expected average mark the students in the group should get. The easiest way to do this is through the simple method of the Excel Average function.
Using the situation provided above, let’s make an Excel spreadsheet of a class of 9 pupils with different scores with the aim of getting the average score of all students.
Make sure the all the data are entered correctly and in the appropriate cell before attempting to use the Average function.
Figure 1. Input data for AVERAGE function
Properly highlight the cells you want to get the average score on. In the table shown above, we want to get the average function on cells B2 to B9. That means the whole of cells B2, B3, B4, B5, B6, B7, B8, and B9.
Figure 2. Highlight the cells to get the average score
Go to the Formulas Menu as shown in the table above, pick the submenu AutoSum, a drop-down menu will appear, then click on average to get the average score. Doing this will give your average score on B10.
Figure 3. Using Average function example
- You can provide Numbers as any of many forms, including numbers, named ranges, ranges, or cell references that have numeric characteristics in them.
- The AVERAGE function does not consider empty cells and instinctively ignores them.