Average Calculator
Paste a list of numbers to get all four measures of centre and spread at once. They frequently disagree, and the disagreement is usually the most informative thing about your data.
Formula
- xᵢ
- = each individual value
- n
- = how many values there are
- Σ
- = the sum of all values
With an even count there is no single middle value, so the median is the mean of the two central numbers.
How to use this calculator
- Paste your numbers into the box. Commas, spaces and line breaks all work as separators, so a column copied from a spreadsheet pastes straight in.
- Press Calculate. All four measures appear at once, along with the sum and count.
- Compare the mean and median. If they are far apart, your data is skewed and the mean alone will mislead.
- Check the mode line — “no mode” simply means no value repeats, which is common with continuous measurements.
Worked example
Seven support tickets resolved in minutes
Resolution times of 12, 15, 15, 18, 21, 24 and 90 minutes. One ticket took far longer than the rest, which is exactly the situation where the choice of average changes the story.
- Sum: 12+15+15+18+21+24+90 = 195
- Mean: 195 ÷ 7 = 27.86
- Sorted middle value: 18
- Mode: 15 (appears twice)
Answer: Mean 27.86, median 18, mode 15, range 78. The mean is higher than every value except the outlier.
Four measures, four different questions
The mean is the balancing point of the data: if the values were weights on a ruler, it is where the ruler balances. It uses every value, which makes it efficient and also makes it vulnerable — one extreme number drags it.
The median is the middle of the sorted list. Half the data is above it, half below. It ignores how far away the extremes are, so it survives outliers intact. This is why income, house prices and response times are almost always reported as medians.
The mode is the most common value. It is the only average that works on categories rather than numbers, and the only one that can be plural — a data set can have two or more modes, or none at all.
The range is not a measure of centre at all. It describes spread, using only the two most extreme observations, which makes it the least stable summary in statistics but a useful quick check for data-entry errors.
When the mean lies
In the example above, six of seven tickets resolved in under 25 minutes, yet the mean is 27.86 — higher than all but one. Reporting "average resolution time: 28 minutes" describes no ticket that actually happened.
This is the classic failure mode of the mean, and it appears everywhere real data is skewed. Salaries in a company with one very senior executive, page-load times with a few timeouts, order values with one bulk purchase. The rule of thumb: if the mean and median differ by more than about 10–15% of the median, look at your data before quoting the mean.
| Data | Mean | Median | Better summary |
|---|---|---|---|
| 12, 15, 15, 18, 21, 24, 90 | 27.86 | 18 | Median — one large outlier |
| 20, 21, 22, 23, 24 | 22 | 22 | Either — symmetric data |
| 1, 1, 1, 1, 96 | 20 | 1 | Median — extreme skew |
| 5, 10, 15, 20, 25 | 15 | 15 | Either — evenly spaced |
Even counts, ties and other awkward cases
With an even number of values there is no single middle, so the median is the average of the two central numbers. For 10, 20, 30, 40 the median is (20 + 30) ÷ 2 = 25 — a value that does not appear in the data, which is normal and correct.
Modes can tie. If two values both appear three times and nothing appears more often, the data is bimodal and both are reported. This calculator lists all tied modes rather than arbitrarily picking one, because a bimodal distribution usually means two different populations have been mixed together — and that is worth noticing.
Averages that are not the arithmetic mean
The arithmetic mean is the wrong tool for some kinds of data. Rates of growth compound, so a sequence of +50% and −50% averages to 0% arithmetically but actually loses 25% — the geometric mean handles that correctly. Speeds over a fixed distance need the harmonic mean: driving out at 30 mph and back at 60 mph averages 40 mph, not 45.
And when values carry different importance — course credits, portfolio sizes, survey strata — a weighted average is required. Using a plain mean there silently treats a 1-credit course as equal to a 5-credit one.
Important considerations
- The mean uses every value and is sensitive to outliers; the median is not.
- A single extreme value can move the mean past most of the data.
- Continuous measurements often have no mode, which is not a problem.
- The range depends entirely on two observations and is unstable in small samples.
- For skewed data, report the median and the range or interquartile range together.
Common mistakes to avoid
- Quoting only the mean for skewed data. It can sit outside the range where most observations actually fall.
- Averaging percentages or rates arithmetically. Growth rates need a geometric mean, speeds a harmonic mean.
- Averaging values of unequal weight. Use a weighted average when items differ in importance or size.
- Averaging averages. The mean of two group means is only correct if the groups are the same size.
- Ignoring the range as a data check. An implausible maximum is often a typo, not a finding.
Frequently asked questions
How do I calculate the average of numbers?
Add all the values together, then divide by how many there are. For 12, 15 and 18: (12 + 15 + 18) ÷ 3 = 15. That is the arithmetic mean, which is what "average" usually means.
What is the difference between mean, median and mode?
The mean is the sum divided by the count. The median is the middle value once the data is sorted. The mode is the value that occurs most often. They coincide in symmetric data and diverge as data becomes skewed.
Which average should I use?
Use the mean for roughly symmetric data with no extreme values. Use the median when the data is skewed or contains outliers — incomes, prices, durations. Use the mode for categories, or when you want the most typical single value.
What if there is no mode?
That simply means no value repeats, which is normal for measured data. The calculator reports "no mode" rather than inventing one. If several values tie for the highest count, all of them are listed.
How do I find the median of an even number of values?
Take the two middle values of the sorted list and average them. For 10, 20, 30, 40 the median is (20 + 30) ÷ 2 = 25, even though 25 is not in the data.
Can I paste a column from a spreadsheet?
Yes. Line breaks, commas, spaces and semicolons are all treated as separators, so a copied spreadsheet column works without any cleanup.
Related calculators
Tools people usually open alongside this one.
Weighted Average Calculator
Average values that carry different importance — credits, portfolio sizes, category weights.
Open calculator
Median Calculator
The middle value of a data set, with quartiles and the interquartile range.
Open calculator
Geometric Mean Calculator
The right average for growth rates and ratios — the nth root of the product.
Open calculator
Harmonic Mean Calculator
The correct average when rates apply over a fixed distance, quantity or budget.
Open calculator
Percentage of Total Calculator
Convert a list of numbers into percentage shares of their total.
Open calculator