Mean vs Median vs Mode: When the Average Lies to You

Mean vs Median vs Mode: When the Average Lies to You

The mean is the arithmetic average: add everything up and divide by the count. The median is the middle value when the data is sorted. The mode is the most frequent value. When data is symmetric, the three are close. When data is skewed or has outliers, as with salaries, house prices or order values, the mean can be pulled far from what's typical, and the median usually describes the "typical" case better.

"Average" is the most-used statistic in business and one of the easiest to misread. A single number on a dashboard can hide a very different picture, and choosing the wrong measure of center is a common way analysis misleads people without anyone meaning it to.

One Team, Three Answers

A small analytics team of ten people has these annual salaries (in thousands of US dollars):

45, 48, 50, 52, 55, 55, 58, 60, 62, 400

The last one is the department head, who also holds equity.

Measure How it's calculated Result
Mean 885 ÷ 10 $88.5K
Median Middle of the sorted list: (55 + 55) ÷ 2 $55K
Mode Most frequent value $55K

A job ad that says "average salary on this team: $88.5K" is technically true. But nine of the ten people earn $62K or less. One outlier moved the mean up by more than $30K. The median ($55K) describes what a typical team member earns.

Remove the department head and the mean drops to about $54K, while the median barely moves (to $55K). That's the key property: the median is robust to outliers, and the mean isn't.

Skew: Why Real Business Data Misleads

Many business quantities are right-skewed: most values are modest, with a long tail of very large ones.

  • Salaries and income
  • Order values (many small baskets, a few bulk orders)
  • House and property prices
  • Session durations and time-on-site
  • Customer lifetime value

In right-skewed data, the mean is larger than the median, sometimes by a lot. In left-skewed data (for example, exam scores where most people do well), the mean is below the median.

A quick diagnostic: if the mean and median differ a lot, the data is skewed or has outliers. Look at a histogram before choosing which one to report.

When Each Measure Is the Right One

Use the mean when:

  • The data is roughly symmetric without extreme outliers (like heights or manufacturing measurements)
  • You need totals. Mean × count = total. For budgeting, capacity planning or revenue forecasting, the mean order value is correct because it includes the big orders. A median-based revenue estimate would come in too low.
  • You're feeding the number into further calculations or models that assume means

Use the median when:

  • The data is skewed or has outliers
  • You want to describe the typical case: "what does a typical customer spend?", "what does a typical analyst earn?"
  • The data contains possible errors you haven't fully cleaned (see our data cleaning checklist)

Use the mode when:

  • The data is categorical: the most common product category, payment method or city
  • You want the most common discrete value, like the most frequent shoe size or the most common number of items per order
  • Data can have more than one mode (bimodal), which often signals two different groups mixed together, such as weekday and weekend shoppers

A Business Example: Order Value

An online store reports average order value (AOV) = $64. Marketing designs a promotion: "spend $60, get free shipping", assuming most orders are near $64.

The median order value is actually $38. A handful of B2B bulk orders pull the mean up. The typical customer is far below the threshold, so the promotion barely changes their behavior. Meanwhile, the bulk buyers get free shipping they would have paid for.

Both numbers are correct. They answer different questions: the mean is right for revenue planning, and the median is right for designing offers around typical customers. Good dashboards often show both.

Other Useful Variants

  • Trimmed mean: drop the top and bottom few percent, then average. It's a compromise that keeps some of the mean's properties while resisting outliers.
  • Weighted mean: each value counts according to its weight, for example average price weighted by units sold. It's essential when combining groups of different sizes. Ignoring the weights is one path to Simpson's paradox.
  • Geometric mean: the right average for growth rates. If revenue grows 50% one year and falls 50% the next, the arithmetic mean says "0% average growth", yet you've lost 25%.
  • Percentiles: the median is the 50th percentile. Reporting the 25th and 75th (or the 90th for things like delivery times) shows the spread, not just the center.

Always Report Spread Too

A center without a spread is half the story. Two stores can have the same median delivery time of 2 days, one with nearly every order in 1–3 days and the other ranging from same-day to 3 weeks. Pair the median with the interquartile range (25th to 75th percentile), and pair the mean with the standard deviation. A box plot shows all of it in one chart.

Common Mistakes

  1. Reporting only "the average" for salaries or prices. Publications and government statistics usually use the median for income and house prices for exactly this reason. Our own data analyst salary guide reads salary data the same way.
  2. Averaging averages. The mean of three stores' average basket sizes isn't the company's average basket size unless the stores have equal order counts. Recalculate from the underlying totals.
  3. Deleting outliers to "fix" the mean. If the outliers are real, switch to the median or report both. Don't throw away real data.
  4. Averaging percentages or ratios directly. Weight them by their denominators instead.

What to Learn Next

Measures of center and spread are the first chapter of every statistics course, and the foundation for confidence intervals, hypothesis tests and A/B testing. Introduction to Statistics (Stanford) covers them clearly and conceptually. See also how averages are misused visually in 5 Data Visualization Mistakes, and browse all Math & Statistics courses.

Frequently Asked Questions

Is the median better than the mean? Neither is better in general. The median better describes a typical value in skewed data. The mean is needed for totals and many statistical methods. Choose based on the question.

Why do salary reports use the median? Because salaries are right-skewed. A few very high earners pull the mean well above what most people earn, so the median is a more honest picture of a typical salary.

Can data have no mode or several modes? Yes. If every value is unique, there's no meaningful mode. Data with two peaks is bimodal, which often means two different populations are mixed together.

How do I calculate these in Excel or Python? In Excel: AVERAGE, MEDIAN and MODE.SNGL. In pandas: df["col"].mean(), .median() and .mode().

Bottom Line

The mean is the right choice for totals and symmetric data. The median is the honest choice for the "typical" case in skewed data full of outliers. The mode is for the most common category. When the mean and median disagree, don't pick the one that suits your argument. Look at the distribution, report the measure that matches the question, and add a measure of spread.

Enjoyed this article?

Share it with your network

Listings related to Mean vs Median vs Mode: When the Average Lies to You