CalcThis CalcThis
Mean · median · mode · outliers

Average Calculator

Paste any list of numbers — commas, spaces, new lines or a spreadsheet column — and get the average with the median, mode, range, quartiles and outliers in one go. The numbers 2, 10, 21, 23, 23, 38, 38 average 22.142857.

Your numbers

Average (mean)
—
Enter or paste at least one number.
Average
—

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

Average = sum of the numbers ÷ how many there are (x₁ + x₂ + … + xₙ) ÷ n

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?

MeasureWhat it tells youBest for
Mean (average)The balance point: sum ÷ countFairly even data
MedianThe middle value once sortedSkewed data, salaries, house prices
ModeThe most frequent valueRepeated or categorical-like data
Geometric meanThe n-th root of the productGrowth 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

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.