How to use
- 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.
- Weighted average: enter one “value, weight” pair per line. For a GPA, that’s “grade points, credits”.
- 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.