How to use the average calculator
Type or paste your numbers into the box — separated by commas, spaces or new lines, so a column copied from Excel or Google Sheets works as it is. The big number is the average (the arithmetic mean); below it you get the median, mode, geometric mean, range, quartiles and any outliers.
Anything that is not a number is skipped and listed in a short "ignored" note, so one stray word never blanks the result. Under Go advanced you can add weights, exclude outliers and see the arithmetic, geometric and harmonic means side by side.
The average formula
For 2, 10, 21, 23, 23, 38, 38: the sum is 155 and there are 7 numbers, so the average is 155 ÷ 7 = 22.142857. The median (the middle number once sorted) is 23, and the numbers that repeat the most — the mode — are 23 and 38.
Mean, median or mode?
| Measure | What it tells you | Best for |
|---|---|---|
| Mean (average) | The balance point: sum ÷ count | Fairly even data |
| Median | The middle value once sorted | Skewed data, salaries, house prices |
| Mode | The most frequent value | Repeated or categorical-like data |
| Geometric mean | The n-th root of the product | Growth rates, ratios (positive numbers only) |
Outliers and the average
One extreme value can drag the average a long way. For 12, 14, 15, 15, 16, 17 and 120 the average is 29.8571, but the median is 15 and 120 is an outlier. Without it the average is 14.8333. The calculator flags outliers with the standard 1.5 × IQR rule (a value more than 1.5 interquartile ranges below the first quartile or above the third) and shows the average without them — under Go advanced you can exclude them for good.
Special kinds of average
- Weighted average — when some numbers count more: use the weights box under Go advanced, or the weighted average calculator.
- Batting average — hits ÷ at-bats, or runs ÷ outs in cricket: the batting average calculator.
- Average price per share across several buys: the stock average calculator.
- Average roll of any dice, with the odds of every total: the dice average calculator.
- Average time of durations or clock times: the time average calculator.
- Average of percentages — average the percentages directly only if every group is the same size; otherwise use weights. See the percentage calculator.
To see how spread out the numbers are as well as where the middle is, use the standard deviation calculator.
Common questions
How do you calculate the average?
Add up all the numbers and divide by how many there are. For 2, 10, 21, 23, 23, 38, 38, the sum is 155, there are 7 numbers, and 155 ÷ 7 = 22.142857.
What is the difference between average, mean, median and mode?
"Average" usually means the mean: the sum divided by the count. The median is the middle value after sorting (23 for the example), and the mode is the value that appears most often (23 and 38). The calculator shows all three.
How do I enter my numbers?
Separate them with commas, spaces or new lines, or paste a column from a spreadsheet. Anything that is not a number is skipped and listed as ignored. Write 1000, not 1,000 — a comma separates two numbers.
What is an outlier and how do I remove it?
An outlier is a value far from the rest: more than 1.5 interquartile ranges below Q1 or above Q3. In 12, 14, 15, 15, 16, 17, 120 the value 120 is an outlier — the average falls from 29.86 to 14.83 without it. Open Go advanced and choose "Exclude them" to remove outliers from every result.
How do I find a weighted average?
Open Go advanced and add one weight per number, in the same order. The weighted average is the sum of each number times its weight, divided by the sum of the weights. For 80 and 90 with weights 1 and 3 it is (80 × 1 + 90 × 3) ÷ 4 = 87.5. There is also a dedicated weighted average calculator.
Can I average negative numbers or decimals?
Yes — both work. The geometric and harmonic means need positive numbers, so those rows show a note instead of a value when your list has zero or negative values.
Why is my average different from the median?
The average is pulled toward extreme values and the median is not. When the two differ a lot, the data is skewed or has outliers — the median is then usually the better "typical" value.