1. Home
  2. Calculate
  3. Average Calculator

Average Calculator

Mean, median, mode and standard deviation, plus weighted averages.

Runs in your browser · No upload
Separate with commas, spaces or new lines. You can paste a spreadsheet column.
Mean (average)
80
Sum 640 ÷ Count 8
Count
8
Sum
640
Median
82.5
Mode
70, 85
Minimum
65
Maximum
95
Range
30
Population SD σ
10
Sample SD s
10.69045
Population variance σ²
100
Sample variance s²
114.285714

How to use

  1. Average & stats: paste numbers separated by commas, spaces or new lines. The mean, median, standard deviation and more appear right away. A column copied from a spreadsheet works too.
  2. Weighted average: enter one “value, weight” pair per line. For a GPA, that’s “grade points, credits”.
  3. Anything that isn’t a number is skipped, and the tool tells you how many items it ignored. If your data uses thousands separators like 1,234, tick Read commas as thousands separators.

What each statistic means

Using the sample data 70, 85, 90, 65, 85, 80, 95, 70 (8 values):

Statistic How it’s calculated Result
Mean sum ÷ count 640 ÷ 8 = 80
Median the middle value once sorted (the average of the two middle values when the count is even) (80 + 85) ÷ 2 = 82.5
Mode the most frequent value; none if every value appears once 70, 85 (twice each)
Range maximum − minimum 95 − 65 = 30
Population variance σ² sum of squared deviations ÷ n 800 ÷ 8 = 100
Sample variance s² sum of squared deviations ÷ (n − 1) 800 ÷ 7 = 114.29
Standard deviation square root of the variance σ = 10, s = 10.69

Population vs. sample standard deviation

Use the population figure (divide by n) when your data covers the whole group, such as every student in a class. Use the sample figure (divide by n − 1) when your data is a sample you’re using to estimate a larger group, such as 100 survey responses standing in for all your customers. In Excel and Google Sheets these are STDEV.P and STDEV.S, and VAR.P and VAR.S for variance.

Weighted average (GPA)

Weighted average = Σ(value × weight) ÷ Σweight

Course Grade points Credits
Biology 4.0 4
History 3.7 3
Art 3.0 2
Seminar 2.0 1

(4.0×4 + 3.7×3 + 3.0×2 + 2.0×1) ÷ 10 = 35.1 ÷ 10 = 3.51. The simple mean of the four grades is 3.175. The weighted figure is higher because the four-credit course counts for more. Grade scales and the way pass/fail courses count vary by school, so check your school’s rules.

Things to watch

  • Outliers pull the mean. Salaries of 42k, 45k, 48k, 51k and 300k average 97.2k, but the median is 48k. For lopsided data, look at the median too.
  • With only one value, the sample variance and sample standard deviation are undefined and show as “-”.
  • To see how much one average changed from another, use the percent change calculator. To compare parts of a whole, try the ratio calculator.

FAQ

Does this match Excel’s AVERAGE?

Yes. The mean matches AVERAGE, the median matches MEDIAN and the modes match MODE.MULT. The weighted average equals =SUMPRODUCT(values, weights)/SUM(weights).

Why are there several modes?

If two or more values tie for the highest count, they’re all modes. If every value appears only once, there’s no mode.

The numbers you enter are calculated in your browser and never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.