IntermediateStatistical Functions4 min20 points

Average or median for this data?

The situation

Ten orders came in last month. Nine were between $380 and $510, and one distributor placed a $12,800 restocking order. You have to put one number in the board pack describing a typical order.

The average, because it uses every order rather than throwing information away.
The median, because one very large order pulls the average away from what a typical order looks like.
The average, because medians only work on data that has been sorted first.
Either — with ten orders the two will be close enough not to matter.

Functions in this exercise

AVERAGE — Returns the arithmetic mean of a range, ignoring empty cells.
MEDIAN — Returns the middle value — the one an outlier can't drag around.

Who this is for

Business Analyst
Data Analyst
Consultant

Recommended next

IntermediateStatistical Functions

Count orders meeting two conditions

Count rows that satisfy several criteria at once.

COUNTIFS

8 min25 points

BeginnerStatistical Functions
Find the typical order size with MEDIAN
Use the median to describe a set of orders that one huge deal has skewed.
MEDIAN
5 min15 points
BeginnerStatistical Functions
Find the average order value with AVERAGE
Calculate the mean value of a set of customer orders.
AVERAGE
3 min10 points
IntermediateData Analysis
Total only the orders above average
Sum the orders that beat the average, without typing the average in yourself.
SUMIF · AVERAGE
8 min25 points

Average or median for this data?

The situation

Functions in this exercise

Who this is for

Recommended next

Count orders meeting two conditions

Related exercises

Find the typical order size with MEDIAN

Find the average order value with AVERAGE

Total only the orders above average