Average vs Median: The Simple Mistake That Misleads Business Reports
One huge order can make your "average order value" look far better than reality. Learn when to use the average, when to use the median, and how to get both right in Excel with AI help.
"Our average order value is ₹11,800!" It sounds great, until you discover that almost every customer spends about ₹2,000, and one large order pulled the average up. This is one of the most common mistakes in business reports, and it is easy to avoid.
A simple example
Ten orders in a day:
| Order | Amount |
|---|---|
| 1 to 9 | ₹2,000 each |
| 10 | ₹1,00,000 |
- Average (mean): total ₹1,18,000 ÷ 10 = ₹11,800
- Median (middle value): sort the amounts and take the middle one = ₹2,000
Which number describes a typical customer? The median. Nobody actually spent anything near ₹11,800.
What each one tells you
| Measure | What it shows | Use it when |
|---|---|---|
| Average | Total divided by count | You care about totals, for example "average revenue per day" for planning |
| Median | The middle value | You want to describe a typical customer, order, salary or delivery time |
The average is pulled by extreme values; the median is not. When your data has a few very large (or very small) values, report the median, or both.
Where this matters in business
- Order value: a few bulk or B2B orders make the average misleading for retail decisions.
- Delivery time: a few very late deliveries raise the average; the median shows the usual experience. (Report the late ones separately, they matter too.)
- Salaries: a few high salaries lift the average; the median is closer to what most employees earn.
- Customer spend: a handful of big customers can hide that most customers spend very little.
How to calculate in Excel
Plain average and median:
=AVERAGE(E2:E500)
=MEDIAN(E2:E500)
With conditions (for example, only October orders), AVERAGEIFS works directly. For a median with conditions, ask AI for a formula for your Excel version:
Excel 365. Column A has dates, column E has order amounts. Give me a
formula for the median order amount for October 2026 only, and explain
it in one line.
In Excel 365, a typical answer combines MEDIAN with FILTER.
Let AI help you choose and explain
I want to report a "typical order value" to my manager. Most orders are
₹1,000–5,000 but a few B2B orders are above ₹2 lakh. Should I use the
average or median? How should I explain the difference in one sentence?
A good one-sentence explanation for a report:
"The median order was ₹2,000, meaning half of all orders were below this amount; the average (₹11,800) is higher because of a few large business orders."
A quick checklist for your next report
- Look at the largest and smallest values before choosing a measure.
- If a few values are far from the rest, report the median (and mention the extremes separately).
- If you report an average, say what it includes ("including bulk orders").
- Let Excel do the calculation, not the AI chat.
Learn more
Choosing the right summary is lesson 3 of our free course AI for Data Analysis, which also covers fair comparisons, trends, honest charts and simple forecasting, with no advanced maths.