Mean & Median Calculator
＋More features: weighted mean, trimmed mean, target-average calculation
Weighted mean (weighted average)
Enter one “value,weight” pair per line to calculate a weighted average — for example a grade where the midterm has weight 2 and the final has weight 3.
Mean without the max and min (trimmed mean)
To avoid being pulled by extreme values, this removes one highest and one lowest value from the numbers entered above and averages the rest.
What do I need next time to reach a target average?
Treating the numbers above as your results so far, this works out the value you need in one more round to reach a target average.
Paste numbers such as test scores or sales figures and instantly see the mean and median — the sum, max and min are shown at the same time. Handy for grading and tidying up records.
How to use
- Enter the numbers separated by commas, spaces or line breaks (pasting a column from Excel works too).
- The moment you paste (or type), the count, sum, mean, median, max and min appear. No button needed.
How it is calculated
- Mean = sum ÷ count
- Median = the middle value when sorted in ascending order (with an even count, the average of the two middle values)
- Example: for 10, 10, 20 the mean is 13.3 but the median is 10. With big outliers in the data, the median is often closer to the “typical” feel.
Sources and assumptions
- Calculations based on the standard statistical definitions (arithmetic mean and median).
Assumptions and notes
- If anything that is not a number is mixed in, you get an error (remove units such as “points” before pasting).
- Up to 10,000 numbers can be calculated at once.
Frequently asked questions
Mean or median — which should I look at?
If the data has no extreme values (outliers), the mean is enough. For data where a few very large values mix in, such as incomes or housing prices, the median matches the feel of the “middle” better. Looking at both is recommended.
Can I use a single column copied from Excel?
Yes. It is recognized as line-break-separated, so select the column, copy it and paste it as is.
Can it also calculate hensachi (deviation scores)?
For hensachi, use the hensachi (deviation score) calculator on this site — you can find it from “All tools”. Paste a list of scores there for a batch calculation.