FREE CHEAT SHEET
All the key points in one handy PDF
Plus, collect a FREE copy of our 30 Excel Power Tips
ENTER YOUR DETAILS FOR IMMEDIATE ACCESS
There are many situations where it’s useful to calculate an average. For example,
Of course there are situations where it is not useful. For example (and I don’t mean to be rude)
And don’t you think it’s odd that
How does that work? We can’t all be right, can we!
You may remember from your maths lessons at school that there are 3 types of average: MEDIAN, MODE and MEAN.
The simplest and most common way to calculate the average value for a set of numbers is to use Excel’s AVERAGE function. This function uses the MEAN method which totals the data then divides the answer by the number of values.
The structure of the AVERAGE function is
This function totals all items within the brackets then divides by the number of items. It can be selected from the AutoSum drop down menu, or by typing it directly into the cell.
If you have values in cells A1 to A11.
To use the AutoSum tool to calculate the average:
Or if you want to write the formula manually:
Using either technique you should end up with
The second method is to use Excel’s MEDIAN function. This function looks at the sorted sequence of data (behind the scenes) then selects the middle value.
The structure of the MEDIAN function is
=MEDIAN (number1, number 2 …)
The third and final method is to use Excel’s MODE function. This function looks at the sorted sequence of data (behind the scenes) then selects the most common value.
Think of the ‘MO’. The MOde function selects the MOst common value.
The structure of the MODE function is
=MODE (number1, number 2 …)
Pulling everything together, here’s how the 3 different functions compare:
Please share your thoughts and feedback in the comments below, and if you found this post useful, please share a link on your social networks.
Cheers. Here's to your learning and success. Enjoy the rest of your day.
Please log in again. The login page will open in a new window. After logging in you can close it and return to this page.