Mean, Median & Mode Calculator
Calculate average, median, mode, range, and more
In the above calculator, paste in your numbers and hit Calculate, and you get the mean, median, mode, range, count, and sum, plus a frequency chart so you can see how the data is distributed.
Once you have those numbers, the real question is what they actually mean for your situation. That's what the rest of this article covers.
How Each Calculation Works
This calculator gives you four core measures: mean, median, mode, and range. They sound similar, but each answers a different question about your data.
Mean (the Average)
The mean is what most people call the average. You add up all the values and divide by how many there are.
Formula: Mean = Sum of all values / Count of values
Say you have these seven test scores: 72, 85, 88, 91, 64, 90, 78.
- Sum: 72 + 85 + 88 + 91 + 64 + 90 + 78 = 568
- Count: 7
- Mean: 568 / 7 = 81.14
Every value in your dataset influences the mean. That's its strength, and its weakness.
Median (the Middle Value)
The median is the literal middle value once you sort your data from smallest to largest.
- Step 1: Sort the values: 64, 72, 78, 85, 88, 90, 91
- Step 2: Find the middle. Seven values, so the middle is the 4th one.
- Median: 85
When you have an even number of values, there's no single middle value. You take the average of the two middle ones instead. For the four values 10, 20, 30, 40: the two middle values are 20 and 30, so the median is (20 + 30) / 2 = 25.
Mode (the Most Frequent Value)
The mode is whichever value shows up most often. Some datasets have one mode, some have several, and some have none at all.
Take this set of customer satisfaction ratings: 4, 5, 3, 5, 4, 5, 2, 4, 5, 3.
Tallying the frequencies: 2 appears once, 3 appears twice, 4 appears three times, 5 appears four times.
Mode: 5
If no value repeats, the calculator displays "No mode." If two or more values tie for the top frequency, all of them are listed as modes.
Range (the Spread)
Range is simply the distance from the smallest value to the largest.
Formula: Range = Max - Min
Using the same test scores (64 to 91): Range = 91 - 64 = 27.
Range gives you a quick read on how spread out your data is. A range of 5 suggests very consistent values. A range of 200 tells you there's a lot of variation.
Mean vs. Median vs. Mode: Which One Should You Use?
This is the question most calculator pages skip.
All three measures tell you something about the "center" of your data, but they're not interchangeable. Picking the wrong one can genuinely mislead you.
Use the Mean When Your Data Is Fairly Symmetric
The mean works best when your values don't have extreme outliers pulling it in one direction.
If your test scores cluster between 70 and 95 with no dramatic exceptions, the mean gives you a solid summary.
It's also the right choice when you need the total embedded in your answer.
The mean of five monthly expenses tells you the typical spend, and you can multiply it by 12 to estimate annual cost. Median doesn't work that way.
Use the Median When You Have Outliers or Skewed Data
This is the most common situation where beginners reach for the wrong tool.
Imagine a small company with eight employees. Seven of them earn between $45,000 and $65,000. The eighth is the founder, earning $600,000.
Mean salary: roughly $135,000. That number doesn't represent anyone's actual experience.
Median salary: about $55,000. That's closer to what a typical employee actually earns.
This is why news reports on household income almost always cite the median, not the mean. In the US, a handful of extremely high earners pull the mean far above what most households actually take home.
If your data is skewed (many values bunched on one side with a long tail on the other), trust the median.
Use the Mode for Categories or Repeating Patterns
Mode is the right measure when you want to know what's most common, or when your data is categorical rather than numeric.
A shoe retailer tracking sales by size wants to know which size to stock more of. The mean shoe size is useless here, since you can't order a half-size that doesn't exist. The mode, say size 10, tells you exactly what sells most.
Quality control is another good fit. A factory tracking defect types uses mode to pinpoint the most frequent failure. Customer survey ratings work the same way.
When All Three Tell the Same Story
In a perfectly symmetric distribution, the mean, median, and mode are all identical or very close.
This is rare in real data, but it's a useful sanity check. If your mean and median are close together, your data is probably not heavily skewed.
How to Calculate Mean, Median, and Mode in Excel
Excel has dedicated functions for each of these, and they're straightforward once you know the quirks.
AVERAGE (Mean in Excel)
=AVERAGE(A2:A20)This calculates the arithmetic mean of a range. Excel ignores empty cells and text automatically, but it does include cells with the value 0.
If you have zeros in your data that represent missing values rather than actual zeros, filter them out before applying AVERAGE.
MEDIAN
=MEDIAN(A2:A20)The MEDIAN function handles all the sorting and middle-value logic for you. It works correctly for both odd and even counts. Like AVERAGE, it ignores blank cells and text.
A useful trick: if you want the median for a specific group (say, median salary for just the "Engineering" department), you can use MEDIAN with IF as an array formula:
=MEDIAN(IF(B2:B20="Engineering", A2:A20))Press Ctrl+Shift+Enter to confirm this as an array formula in older Excel versions. In Excel 365, you can enter it normally.
MODE.SNGL (Single Mode)
=MODE.SNGL(A2:A20)Returns the most frequently occurring value. If there's a tie, it returns the first one it encounters.
The big gotcha: if no value repeats, MODE.SNGL returns a #N/A error. Wrap it to handle that gracefully:
=IFERROR(MODE.SNGL(A2:A20), "No mode")MODE.SNGL replaced the older MODE function in Excel 2010. MODE still works for backward compatibility, but Microsoft recommends MODE.SNGL for new workbooks.
MODE.MULT (Multiple Modes)
=MODE.MULT(A2:A20)When your data has more than one mode, MODE.MULT returns all of them as an array.
In Excel versions before 365, you need to select multiple cells and enter it as an array formula with Ctrl+Shift+Enter. If you just press Enter normally, it behaves like MODE.SNGL and returns only the first mode.
In Excel 365, MODE.MULT spills the results automatically into as many rows as needed, no special entry required.
Like MODE.SNGL, it returns #N/A when all values are unique. The IFERROR wrapper handles this the same way.
Range, Min, Max in Excel
Excel doesn't have a single RANGE function, but it's a one-liner:
=MAX(A2:A20) - MIN(A2:A20)Common Mistakes to Avoid
Here are some common mistakes to avoid when working with mean, median, and mode.
Calculating the Median Without Sorting First
This is the most frequent error by hand. If you try to find the middle value of an unsorted list, you'll get the wrong answer. The calculator above handles this automatically, but if you're doing it by hand, always sort first.
Assuming the Mean Represents a Typical Value When Outliers Exist
The mean is pulled toward extreme values. A dataset of 1, 2, 3, 4, 100 has a mean of 22, but four out of five values are below 5. In that case, the median (3) tells a much more honest story.
Thinking Every Dataset Must Have a Mode
It's common to assume there's always a mode. If your dataset is 10, 20, 30, 40, 50, every value appears exactly once. There is no mode. The calculator shows "No mode" in this case, which is the correct answer, not an error.
Confusing Mean and Median as Interchangeable
A lot of everyday language uses "average" loosely. When someone says "the average house price in this neighborhood is $450,000," they might mean the mean or the median. These can differ by tens of thousands of dollars in real estate data. Always check which measure is being reported.
Using MODE.SNGL When You Have Multiple Modes
If your data has two or more values tied for most frequent, MODE.SNGL quietly returns just one of them without warning you that others exist. Use MODE.MULT (or this calculator) to make sure you see the full picture.
Frequently Asked Questions
What is the difference between mean and average?
They're the same thing. Mean is the technical term; average is the everyday word. Both refer to the sum of all values divided by the count of values. When someone says "class average," they mean the arithmetic mean.
Can a dataset have more than one mode?
Yes. If two or more values appear the same number of times, and that number is higher than any other frequency, all of those values are modes. A dataset with two modes is called bimodal; one with more is multimodal. This calculator lists all modes when that happens.
When should I use median instead of mean?
Use the median when your data contains outliers (extreme high or low values) or when the distribution is noticeably skewed. Salary data, home prices, and household income are classic cases where median is more informative than mean. If your mean and median are very different, that's a signal that outliers or skew are at play.
Why does Excel's MODE function return an error?
MODE.SNGL (and the older MODE function) returns #N/A when every value in the dataset appears exactly once, meaning there is no mode. Wrap it in IFERROR: =IFERROR(MODE.SNGL(A2:A20), "No mode") to display something readable instead.
Does the order of numbers matter for mean, median, or mode?
For the mean and mode, no. For the median, the order of your original list doesn't matter either, because the calculation always sorts the values first. This calculator sorts automatically before finding the median.
What does range tell you that mean and median don't?
Range measures spread, not center. Two datasets can have identical means but very different ranges. A class where everyone scored between 78 and 82 and a class where scores ranged from 40 to 100 could have the same mean of 80, but they describe very different realities. Range is the simplest way to see how far apart your lowest and highest values are.
Related Articles / Calculators
