Mean, Median, Mode Calculator
Paste your list. You get the mean, median, mode and range together, and the sorted list that the median comes from.
https://flxcode.com/mean-median-mode-calculator/
Paste a column or row from Excel, Google Sheets or a CSV file, or type numbers separated by spaces, commas or new lines. A header word is ignored.
Example Mean, median, mode and range
Mean
Read 9 numbers.
| Mean | 5.11111 |
|---|---|
| Median | 5 |
| Mode | 7 |
| Range (max − min) | 7 |
| Smallest | 2 |
| Largest | 9 |
| Count (n) | 9 |
| Sum | 46 |
The steps, with your numbers
Mean: Σx / n = 46 / 9 = 5.11111
Sorted: 2, 2, 3, …, 7, 9
Median: with 9 numbers the middle one is number 5, which is 5
Mode: 7 appears 3 times, more than any other value
Range: 9 − 2 = 7
No ads. No account. Nothing you type or record is uploaded. We count page events with a daily code. Check it.
Problem or idea? Email us
Quick start
- Paste or type the numbers.
- The mean is the headline number. Mode, median and range are in the table.
- The steps show the sorted list, which position the median is at, and how many times the mode appears.
The four measures
| Measure | How to find it | Tells you |
|---|---|---|
| Mean | Add all, divide by the count | The balance point of the data |
| Median | Sort, take the middle (or average the middle two) | The typical value, ignoring extremes |
| Mode | The most frequent value | The most common value |
| Range | Largest minus smallest | How far the data stretch |
Worked examples
| Numbers | Mean | Median | Mode | Range | Note |
|---|---|---|---|---|---|
| 3 7 7 2 9 4 7 5 2 | 5.11111 | 5 | 7 | 7 | The default list. 7 appears three times. |
| 1 2 3 4 5 6 | 3.5 | 3.5 | none | 5 | An even count: the median is the average of the middle two. |
| 4 4 9 9 12 | 7.6 | 9 | 4 and 9 | 8 | Two modes, 4 and 9. |
| 32 35 36 38 40 250 | 71.8333 | 37 | none | 218 | One huge value pulls the mean far above the median. |
| 5 6 8 9 | 7 | 7 | none | 4 | No value repeats, so no mode. |
Which one to report
Use the mean for roughly symmetric data without outliers. Use the median when the data are skewed or have extreme values. Use the mode for categories or counts, such as the most common shoe size. When the mean and median are far apart, as in the fourth row above where they are 71.8333 and 37, the data are skewed and the mean alone misleads.
To see how spread out the numbers are, add the standard deviation. For the quartiles and outliers, use the quartile calculator.
Numbers this uses
Every constant the tool uses is listed here with its source. Where a number varies, you can edit it in the tool.
- Even count is the median is the average of the two middle values. Standard definition, same as MEDIAN in Excel.
- Mode is every value that ties for the highest count. If all counts are 1 the tool reports no mode, like MODE.SNGL returning an error.
- Equality is values must match exactly. 2 and 2.0 are the same, 2 and 2.0001 are not.
Common mistakes
- Finding the median without sorting first.
- Reporting a mode when no value repeats.
- Giving the mean of data that has a data-entry error such as an extra zero. Check the largest and smallest values.
Nothing you type or paste is uploaded. We count events without cookies (details).
FAQ
What is the difference between mean, median and mode?
The mean is the sum divided by the count. The median is the middle value of the sorted list. The mode is the value that appears most often. For 3, 7, 7, 2, 9, 4, 7, 5, 2 they are 5.11111, 5 and 7.
How do I find the median of an even number of values?
Sort the numbers and average the two in the middle. For 1, 2, 3, 4, 5, 6 the middle two are 3 and 4, so the median is 3.5.
Can there be more than one mode, or none?
Yes to both. In 4, 4, 9, 9, 12 both 4 and 9 appear twice, so there are two modes. In 5, 6, 8, 9 every value appears once, so there is no mode. The tool lists every mode it finds.
When is the median better than the mean?
When a few extreme values pull the mean away from the typical value. In 32, 35, 36, 38, 40, 250 the mean is 71.8333 but the median is 37. Incomes and house prices are reported as medians for this reason.
What is the range?
The largest value minus the smallest. It is a rough measure of spread. For the default list it is 7. One extreme value changes it a lot, so the standard deviation or the interquartile range is a steadier choice.
How do I do this in Excel or Google Sheets?
Use =AVERAGE(A1:A10), =MEDIAN(A1:A10) and =MODE.SNGL(A1:A10) for the first mode. =MODE.MULT returns all modes as an array. The range is =MAX(A1:A10)-MIN(A1:A10).
What does the tool do with text and blanks?
It skips anything that is not a number and tells you how many items it skipped and what they were. A header word before the first number is ignored without being counted as skipped.
Is my list stored or uploaded?
No. Everything is calculated in your browser, and your numbers are never saved or sent.
More from FLXCode
Average CalculatorNew
Average (mean) of pasted numbers, or a weighted average for grades and prices, with the steps.
Quartile CalculatorNew
Q1, median and Q3 of your numbers, plus IQR, outlier fences and a box plot.
Standard Deviation CalculatorNew
Paste your numbers and get the sample and population standard deviation, with the steps shown.
GPA CalculatorNew
Work out your semester, weighted and cumulative GPA from courses, credits and grades, or the grade you need for a goal.