BeginnerStatistical Functions
Find the average order value with AVERAGE
Calculate the mean value of a set of customer orders.
AVERAGE
3 min10 points
Total the three biggest orders
The situation
Harbor Supply's board pack quotes what share of revenue comes from the three largest orders. The list is re-exported every month in a different order, so sorting it by hand and adding the top rows is both slow and easy to get wrong.
A1
fx
| Row number | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Order | Value | ||||
| 2 | SO-9301 | $1,200 | Top three total | |||
| 3 | SO-9302 | $850 | ||||
| 4 | SO-9303 | $2,400 | ||||
| 5 | SO-9304 | $640 | ||||
| 6 | SO-9305 | $5,200 | ||||
| 7 | SO-9306 | $3,100 | ||||
| 8 | SO-9307 | $920 | ||||
| 9 | SO-9308 | $1,480 | ||||
| 10 | SO-9309 | $4,900 | ||||
| 11 | SO-9310 | $710 | ||||
| 12 |
Functions in this exercise
- LARGE — Returns the nth largest value — the third-best rep, not just the best.
Who this is for
Recommended next
Related exercises
- AdvancedData Analysis
Name the second-best rep with LARGE and INDEX
Combine ranking with a lookup to return a name, not just a number.
LARGE · INDEX · MATCH
14 min40 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 - IntermediateStatistical Functions
Measure the spread, ignoring the extremes
Compare the second-best and second-worst weeks to get a fairer range.
LARGE · SMALL
7 min25 points