A simple calculator can be used to take out an average value or most commonly known as, central tendency for any data. The usual method of calculating this value is by finding the sum of all the number in all different fields and then dividing the total by the number of fields. For instance, you score 5,6, and 7 in three tests out of 10 total for each. Now if you have to find the average for these numbers, you will add 5,6 and 7 and divide it by 3, since there are three tests. The average for this example will be 6.
Similarly, when you want to find the central tendency for certain data, Microsoft Excel gives you a few sets of formulas which will help you find the basic average values that anyone might require. Some of the functions namely are, AVERAGE, to find the median of value, you can use the MEDIAN function, and MODE to find the most occurring value. These formulas will definitely help you make your life a lot easier as you will not find the need to use a calculator or manually calculate anything. Just use the Functions on Excel and you are good to go.
Different Ways of Finding the Average Value on Excel
Using the Average Function on Excel
The Function for finding an average value on Excel can be achieved in two different ways. The function will be the same in both the cases. The only difference is the way we write the numbers or use the cell numbers instead to calculate the average. But before that let’s see the data we will use for this example.
I entered the data for three tests here. Now, using the AVERAGE function on Excel in three different ways, we will find the average for these values. The AVERAGE function appears on the cell right after you start typing the word ‘Average’ after the ‘=’.
- =AVERAGE(number 1,number 2,…number n)
In this method, you will simply write down the numbers that you want to find an average for. Since the numbers we are using for this example are 5,6, and 7, I will write these in the formula and press the enter key after closing the brackets.
- =AVERAGE(cell number for the first number: cell number for the last number)
Here, you will use the colon to select the tabs that you want to calculate an average for just how we use the colon to sum different cells and the cells in between. Look at the image below to see how I used this method to calculate the average.
Both of the above-mentioned methods of using the AVERAGE function on Excel are super easy. Either way, you will get the correct answer.
Finding the Average Mathematically
This method of calculating the average does not involve the AVERAGE function on Excel. For this method, you simply use the cell space to write down the numbers how you do it mathematically and then press the enter key to find the answer. The way we are going to write the numbers however something you must be very particular about as that is going to determine your answer.
- Total Numbers Achieved Divided by Total Fields
Make sure you begin writing the numbers with the ‘=’ sign, which is a very crucial part of calculations on Excel. After typing the Excel, open the bracket, write the sum of the three numbers or scores achieved in this examples case, close the bracket, and then divide the total by the number of fields or subjects. Look at the image below for a better understanding.
The same method can be used in another way. Instead of writing the numbers of the scores, you can add the cell numbers instead so that any changes made in the scores can automatically get adjusted in the cell for the total. For this, for instance, instead of writing the number 5, you will type in a2, which is the cell number for this numeric.
Use the AVERAGE Function Instead of Calculating it Mathematically
Using the AVERAGE function is a better method of calculating an average. Since we are humans, we are bound to make careless mistakes. Using the AVERAGE function will reduce the chances of such mistakes.