Average Calculator
This average calculator takes any list of numbers, typed or pasted straight from a spreadsheet column, and returns the mean alongside the sum, count, median, mode, range and standard deviation. It plots every value and shows the sum ÷ count working underneath.
How to use the average calculator
- Type or paste your numbers into the box. Commas, spaces, tabs, semicolons and line breaks all count as separators, so a column copied out of a spreadsheet drops straight in without cleaning.
- The results update as you type. There is nothing to submit.
- Read the mean at the top. The line under it shows the actual addition and the division that produced it.
- Look at the panel below for the sum, count, median, mode, range, minimum, maximum and sample standard deviation of the same list.
- Use the Type of average control to switch from the arithmetic mean to a geometric or harmonic mean when your numbers are growth factors or rates.
Every value you enter is plotted as a dot, with the mean drawn across the chart as a dashed line. That picture is often more informative than the number: if the dots sit in a tight band the mean describes them well, and if one dot is far off to the right the mean has been dragged toward it.
Anything in the box that is not a number is ignored, and the calculator tells you how many items it skipped. Currency symbols and stray labels will not break the list.
The average formula
In statistics notation that is written x̄ = Σx ÷ n. The symbol Σx means the sum of all the values, n is how many there are, and x̄ (“x bar”) is the mean.
Two details decide most answers. First, n counts every entry, including zeros and repeats. A zero is a real data point and it pulls the mean down; a blank cell is not a data point at all and should be left out. Second, negative values are added like any other number, so a list can average to a negative or to zero.
The mean has one property worth remembering: the distances from the mean cancel out. Add up how far each value sits above the mean and how far each sits below, and the two totals match exactly. That is why a single extreme value moves the mean so much, and why the mean is not always the summary you want.
Worked examples
Example: five test scores
A student scores 78, 92, 85, 61 and 94. Add the five scores, then divide by five.
The mean is 82. The median of the same set is 85, and the gap between them is the 61 pulling the mean down.
Example: a pasted column of seven numbers
Seven values come out of a spreadsheet: 10, 2, 38, 23, 38, 23, 21.
The mean is about 22.14. The panel also reports a median of 23, two modes (23 and 38, each appearing twice), a range of 36, and a sample standard deviation of about 13.28. A standard deviation that large next to a mean of 22 tells you the values are spread wide, which the chart confirms.
Mean, median or mode: which one describes your data
All three are averages, and they answer different questions. The mean is the balance point. The median is the middle value once the list is sorted. The mode is the value that shows up most often.
They agree when data is symmetric and disagree when it is skewed. Five salaries make the point:
Nobody in that group earns anything close to $79,200. Four of the five earn less than half of it. The median of $38,000 describes a typical person in the list; the mean describes the total divided evenly, which is a different and often less useful idea. This is why house prices, household incomes, response times and rents are almost always reported as medians. If your data is skewed, run it through the median calculator as well and compare.
| Average | What it tells you | Use it when | Breaks down when |
|---|---|---|---|
| Mean | The balance point of all values | Data is roughly symmetric; you need a total to divide up | One or two extreme values dominate |
| Median | The middle of the sorted list | Data is skewed: incomes, prices, wait times | You need the result to add back to a total |
| Mode | The most common value | Categories or repeated whole values: shoe sizes, ratings | Every value is unique, or several tie |
The mode is the only one of the three that works on things that are not numbers, and the only one that can be missing entirely. A list where nothing repeats has no mode; a list can also have two or three modes at once, as the seven-number example above does.
When to use a geometric or harmonic mean
The arithmetic mean adds. Some quantities multiply or divide instead, and averaging them by adding gives an answer that is simply wrong.
Geometric mean: growth rates, returns and ratios
An investment gains 10%, then loses 20%, then gains 30%. The arithmetic mean of +10, −20 and +30 is 6.67% a year. Check it against what actually happened by multiplying the growth factors:
The geometric mean is 4.59%, and compounding 4.59% for three years does return to 1.144. Compounding the arithmetic 6.67% would give 1.214, overstating the result badly. Switch the type of average to Geometric and enter the growth factors (1.10, 0.80, 1.30) rather than the percentages. Every value has to be greater than zero, which is why factors work and raw percent changes do not.
Harmonic mean: speeds and rates
You drive to a town at 60 mph and come back along the same road at 30 mph. The average speed is not 45 mph, because you spend twice as long on the slow leg.
Forty is the harmonic mean, and the check confirms it. Use the harmonic mean whenever the numbers are rates measured over the same distance, the same job or the same amount of work: miles per hour over equal distances, price-to-earnings ratios, items per hour for workers doing the same task.
Why the average of averages is usually wrong
Two classes take the same test. Class A has 20 students and averages 70. Class B has 5 students and averages 90. The combined average is not 80.
Averaging 70 and 90 treats the five-student class as if it were the same size as the twenty-student one. The correct answer, 74, sits much closer to Class A because Class A holds four times as many students.
This turns up constantly: monthly conversion rates averaged across months with wildly different traffic, average cost per unit across purchase batches of different sizes, average rating across products with different review counts. The rule is simple. You can average averages only when each group has the same count. Otherwise you either go back to the raw numbers, or you weight each average by its group size using the weighted average calculator.
Common mistakes
- Averaging averages of different-sized groups. Weight them by group size instead, or go back to the underlying values.
- Treating a blank as a zero. A missing reading should be left out of the list. A genuine zero should be typed in. The two give different counts and different means.
- Using the mean when one value dominates. One $250,000 salary in a list of five makes the mean describe nobody. Report the median as well.
- Adding percent changes or speeds. Growth factors need a geometric mean; rates over equal distances need a harmonic mean.
- Mixing units. Averaging 90 (seconds) with 2 (minutes) gives a meaningless number. Convert first.
- Rounding partway through. Round the final mean, not the values going in. If you need a specific number of decimals, take the full mean to the rounding calculator at the end.
- Reading the wrong standard deviation. The figure shown here is the sample standard deviation, dividing by
n − 1. If your list is the entire population rather than a sample from it, the population figure is slightly smaller. - Comparing an average to a reference value by subtraction alone. A 3-unit gap means very different things at 10 and at 1,000. The percent error calculator puts that gap in proportion.
Frequently asked questions
What is the average of 2, 4 and 9?
The average is 5. Add the three numbers to get 2 + 4 + 9 = 15, then divide by how many there are: 15 ÷ 3 = 5. Notice that 5 does not appear in the original list. An average is a summary of the set, not one of its members, and it very often lands between the values rather than on one.
What is the average of 10, 2, 38, 23, 38, 23 and 21?
About 22.14. The seven values add to 155, and 155 ÷ 7 = 22.142857…. The same list has a median of 23, a range of 36, and two modes: 23 and 38 each appear twice. The mean sits below the median here because the two small values, 10 and 2, pull it down more than the pair of 38s pushes it up.
Is the average the same as the mean?
In everyday use, yes. When someone says “the average,” they almost always mean the arithmetic mean: add everything, divide by the count. In statistics, “average” is a broader word that also covers the median, the mode, and the geometric and harmonic means. That is why this page reports all of them, so you can see whether the mean is really the right summary for your numbers.
What is the average of the numbers 1 to 10?
5.5. The numbers 1 through 10 add to 55, and 55 ÷ 10 = 5.5. For any evenly spaced run of numbers there is a shortcut: average the first and last values. (1 + 10) ÷ 2 = 5.5 gives the same answer without adding anything up, and it works for 1 to 100 (50.5) or for 20, 30, 40, 50 (35) just as well.
How do you average percentages?
Only average percentages directly when each one comes from the same size group. A 40% rate from 10 trials and a 60% rate from 10 trials do average to 50%. If the groups differ, go back to the counts: 2 successes out of 5 and 90 out of 150 give 92 ÷ 155 = 59.4%, not the 65% you get by averaging 40% and 60%.
Can the average be a number that is not in the list?
Yes, and it usually is. The average of 4 and 5 is 4.5. The average of three whole numbers is often a repeating decimal. The mean is a balance point, not a selection, so it does not have to be a value you actually recorded. If you need the answer to be a real member of the set, use the median or the mode instead.
How do you find the average of negative numbers?
Exactly the same way, keeping the signs. For −4, 2, 9 and −1: −4 + 2 + 9 − 1 = 6, then 6 ÷ 4 = 1.5. The mean of a list containing negatives can be positive, negative or zero. Type the minus signs directly into the box; they parse correctly whether you separate values with commas, spaces or line breaks.
Is the standard deviation shown here the sample or population one?
It is the sample standard deviation, which divides the squared deviations by n − 1 rather than n. For 2, 4, 4, 4, 5, 5, 7, 9 the mean is 5 and the squared deviations add to 32, giving 32 ÷ 7 = 4.571 and a sample standard deviation of about 2.14. The population version divides by 8 instead and gives exactly 2.
Related calculators
Put this calculator on your own site (free)
Copy this into any page. The calculator stays up to date on its own, works on mobile, and carries a small credit link back here.
https://fourfunctioncalculator.com/average-calculator/