IntermediateStatistical Functions
Count orders meeting two conditions
Count rows that satisfy several criteria at once.
COUNTIFS
8 min25 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.
Functions in this exercise
- AVERAGE — Returns the arithmetic mean of a range, ignoring empty cells. Syntax and example
- MEDIAN — Returns the middle value — the one an outlier can't drag around. Syntax and example
Who this is for
Recommended next
Related exercises
- 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