“Your class average looks fine, but does that tell the whole story?” or “someone asked about the spread of your data - where do you even start?” Relying on the mean alone can lead you to the wrong conclusion.
In this article, we explain how to find the mean, median and standard deviation with formulas and worked examples, so you can read scores, sales and measurements accurately.
Three measures that summarize data
When you summarize a list of numbers, three measures come up again and again:
| Measure | What it shows | Best for |
|---|---|---|
| Mean | The “center” of the data | Data without outliers |
| Median | The middle value when sorted | Data with outliers |
| Standard deviation | How spread out the data is | Comparing stability and risk |
These are called descriptive statistics. Let’s take them one at a time.
How to find the mean
The mean is the sum of all values divided by the count:
Mean = sum of values ÷ countTake five test scores: 85, 92, 78, 90, 88. The sum is 433, so the mean is 433 ÷ 5 = 86.6.
The mean is easy to compute and share, and it treats every value equally. The trade-off: extreme values (outliers) pull it strongly in one direction.
How to find the median
The median is the middle value after sorting the data from smallest to largest.
With an odd count, it is the middle item: sorted, our scores are 78, 85, 88, 90, 92, so the median is 88.
With an even count, average the two middle values: for 1, 2, 3, 4 the median is (2 + 3) ÷ 2 = 2.5. Because the median only cares about position, extreme values cannot drag it away.
When the mean and median disagree
With outliers the two can diverge dramatically. Consider five incomes: 3.0, 3.5, 4.0, 4.5 and 50 (millions of yen).
- Mean: (3.0 + 3.5 + 4.0 + 4.5 + 50) ÷ 5 = 13M
- Median: the third value = 4.0M
The mean describes almost nobody - four of the five earn 3-4.5M. With outliers, the median reflects reality far better.
A useful habit: Compute both the mean and the median. If they differ a lot, suspect outliers. Checking both is the foundation of good data analysis.
How to find the standard deviation
The standard deviation measures how far the data spreads around the mean - in short, the size of the variation.
Same average, different spread
Two classes both average 80 points:
- Class A: 78, 79, 80, 81, 82 - everyone scored almost the same
- Class B: 60, 70, 80, 90, 100 - scores are all over the place
Both average 80, but Class B has the larger standard deviation. Small means values cluster near the mean; large means they spread widely. In quality control and investing, this spread is watched as “risk”.
The calculation steps
The standard deviation takes four steps: subtract the mean from each value, square the differences, average them (the variance), then take the square root.
For 85, 92, 78, 90, 88 (mean 86.6), the differences are -1.6, 5.4, -8.6, 3.4 and 1.4. The variance is about 23.84 and the standard deviation about 4.88 points. With so many steps, a calculator is safer for real data work.
Population vs sample: The variance can divide by the count (population standard deviation) or by count − 1 (sample standard deviation). Use the population form when you have all the data, and the sample form when estimating a larger population from a sample. This article and the Tools Hub calculator use the population form (divide by n).
Worked example: reading a week of sales
Consider a week of daily sales (in units of 10,000 yen): 12, 15, 11, 14, 13, 90, 12 - one big campaign day.
- Mean: 167 ÷ 7 ≈ 23.9
- Median: sorted as 11, 12, 12, 13, 14, 15, 90, so the fourth value is 13
- Standard deviation: about 27.1 because of the wide spread
The mean suggests “about 24 per day”, but most days sit between 11 and 15 with a single 90. The median of 13 is far more honest about the typical level. The routine: start with the mean for the big picture, compare with the median for outliers, then read the standard deviation for the spread.
How to calculate the statistics
With the Tools Hub statistics calculator, paste your data and all seven statistics appear at once.
Paste your numbers
Separate values with newlines, commas or spaces - pasting straight from a spreadsheet works too.
Read the results
Count, sum, mean, median, min, max and standard deviation update in real time.
Copy and use
Copy the whole summary into your report or notes in one click.
The tool introduced in this article
Statistics Calculator
Paste numbers to get the mean, median and standard deviation together. All in your browser - nothing is sent anywhere.
Using the three measures together
In practice, combine all three: the mean for the overall level, the median to verify reality when outliers exist, and the standard deviation to compare stability.
Summary
- Mean = sum ÷ count (treats every value equally)
- Median = the middle value when sorted (resistant to outliers)
- Standard deviation = the size of the spread (small means clustered)
- A big gap between mean and median hints at outliers
- The standard deviation is the square root of the variance, with population and sample variants
- The Tools Hub calculator produces all seven statistics at once
Next time you summarize data, use the formulas above or the Tools Hub statistics calculator.
FAQ
When should I use the mean vs the median?
Use the mean for data without outliers and the median when extreme values exist. Checking both and comparing is the safest approach.
What does a large standard deviation tell me?
It shows the data spreads widely from the mean. With equal means, a larger standard deviation means less consistency.
What is the standard deviation formula?
It is the square root of the variance (the average of squared differences from the mean). The population form divides by n; the sample form divides by n − 1.
Can I paste data from a spreadsheet?
Yes. Tab and newline separators work, as do thousands separators and full-width commas. For multiple columns, paste and aggregate one column at a time.
