Paste and go
Separate numbers with commas, spaces, line breaks or tabs; a column copied from Excel or Google Sheets works as-is. Anything that is not a number is skipped, and the tool tells you what it left out. Because commas separate values, write 1000 rather than 1,000.
You get the mean, median, mode, maximum, minimum, range, sum, count, population and sample standard deviation, variance, geometric mean and harmonic mean together. Copy results puts them on your clipboard as a two-column table that pastes cleanly into a spreadsheet.
Worked example: test scores
Scores of 85, 92, 78, 90 and 88 give:
- Sum 433 ÷ 5 = mean 86.6
- Sorted: 78, 85, 88, 90, 92, so the middle (3rd) value is the median, 88
- Highest minus lowest = range 14
- Squared distances from the mean add up to 119.2; √(119.2 ÷ 5) ≈ 4.88 is the population standard deviation (√(119.2 ÷ 4) ≈ 5.46 for a sample)
With an even count, the median is the average of the two middle values. For 3, 7, 7, 2, 9, 10 the mean is 38 ÷ 6 ≈ 6.33, the sorted list is 2, 3, 7, 7, 9, 10, the median is (7 + 7) ÷ 2 = 7, and 7 is also the mode because it appears twice.
Mean or median?
The mean uses every value but one extreme number can drag it a long way. For skewed data such as incomes or house prices, the median is often the better picture of a typical value. Standard deviation measures spread: two classes can share an average, but the one with the smaller standard deviation has scores bunched more tightly. Use the population version when your numbers are the whole group and the sample version when they are a sample standing in for a larger one.
The geometric mean suits things that compound, like growth rates or investment returns; the harmonic mean suits rates such as speeds or unit prices. Both need every value to be above zero.
Weighted average
When items count differently, such as courses with different credit hours or a midterm worth 40% and a final worth 60%, use the weighted average tab:
Weighted average = Σ(value × weight) ÷ Σ weights
English 90 (3 credits), Math 80 (4 credits) and History 95 (2 credits) give (270 + 320 + 190) ÷ 9 = 780 ÷ 9 ≈ 86.67, lower than the simple average of 88.33 because the lowest score carries the most credits. To turn letter grades into a grade point average, use the GPA calculator.