BeginnerStatistical Functions
Find the average order value with AVERAGE
Calculate the mean value of a set of customer orders.
AVERAGE
3 min10 points
AVERAGE
Returns the arithmetic mean of a range, ignoring empty cells.
Syntax
AVERAGE(number1, [number2], ...)
Statistical Functions.
A worked example
=AVERAGE(C2:C9)
Returns 2,250
Totals the eight order values and divides by eight.
Where it goes wrong
Blank cells are skipped, but zeros are not. If a missing value was entered as 0 rather than left empty, it drags the average down.
Consider instead: MEDIAN, when one extreme value would distort the picture.
Practise AVERAGE
Knowing what a function does and being able to write it from memory are different skills. These close the gap.
All AVERAGE practice exercises →