Statistics calculator
Average and Median Calculator
When you collect a set of figures, such as the salaries quoted in several adverts for the role you want, two numbers summarise them: the average and the median. This calculator gives both, along with the lowest and highest values, so you can see whether one unusual figure is distorting the picture.
The formula
Formula
average = sum of the numbers ÷ how many numbers there are; median = the middle value once the numbers are sorted (the average of the two middle values when the count is even)
- numbers
- the list of values, separated by commas, spaces or new lines
- average (mean)
- the total of all the values divided by how many there are
- median
- the value in the middle of the sorted list, with half of the values at or below it
- lowest and highest
- the smallest and the largest value in the list
- range
- highest − lowest
- how many numbers
- the count of values read from the list
Explained in full: Average (Mean) Formula, Median Formula.
How to use it
Type or paste plain numbers separated by commas, spaces or line breaks. Leave out currency symbols and, importantly, thousands separators: write 42000, because 42,000 would be read as two numbers, 42 and 0. Check the "How many numbers" line against your own count to be sure the list was read as you intended.
Make the figures comparable before you enter them. Salaries should all be for the same period (yearly, not a mixture of yearly and monthly), in the same currency, and for roughly the same role and location. Where an advert gives a band, use its midpoint or enter both ends, and do the same for every advert.
Then compare the two results. If the average and the median are close, the values are spread fairly evenly and either number describes them. If the average is well above the median, a few high values are pulling it up, and the median is the better guide to what is typical. In a pay discussion, the median of a carefully chosen set of adverts is easier to defend than the average; the guide to salary negotiation explains how to use such a figure.
Worked example
The default list is five salaries taken from job adverts: 42000, 45000, 47500, 52000 and 88000.
- Add the values: 42000 + 45000 + 47500 + 52000 + 88000 = 274500.
- Divide by how many there are: 274500 ÷ 5 = 54900. The average is 54,900.
- Sort the list (it is already in order) and take the middle value. With five numbers the middle one is the third, 47500. The median is 47,500.
- The lowest value is 42,000 and the highest is 88,000. Range: 88000 − 42000 = 46,000.
- Compare the two: the average is 7,400 above the median because the single value of 88000 pulls it up. Four of the five salaries are below the average, so the median describes this set better.
What the calculator shows for these inputs:
| Average (mean) | 54,900 |
|---|---|
| Median (middle value) | 47,500 |
| Lowest | 42,000 |
| Highest | 88,000 |
| Range | 46,000 |
| How many numbers | 5 |
Assumptions
- Every number in the list counts equally; if some should count more than others, a weighted average is the right tool.
- The values measure the same thing in the same units, so that adding them makes sense.
- A comma, a space or a line break always separates two numbers.
Limitations
- A small set of adverts is not market data: five or ten figures describe those adverts and nothing wider.
- The average is sensitive to extreme values, and the calculator does not remove or flag outliers for you.
- Numbers typed with thousands separators are split into separate values without a warning, so check the count.
- Advertised salaries can differ from what is finally paid, and adverts that give no figure are missing from any list you build.
Questions and answers
Should I use the average or the median for salaries?
The median, in most cases. A list of pay figures often includes a few high values that lift the average above what a typical person in the role earns. The median is not affected by how extreme those values are, only by how many of them there are.
What happens when there is an even number of values?
There is no single middle value, so the median is the average of the two in the middle. For 40000, 44000, 48000 and 60000 the middle pair is 44000 and 48000, and the median is 46000.
Why are my results obviously wrong?
The usual cause is a thousands separator or a currency symbol in the list. A comma inside a number splits it in two, and a symbol stops the entry being read as a number. Remove both, and confirm that the "How many numbers" line matches the number of values you meant to enter.
How many figures do I need for a useful result?
More is better, but relevance matters more than quantity. Eight adverts for the same role, level and area tell you more than thirty mixed ones. Treat the result as a description of the adverts you found, and say so if you quote it.