All functions / Statistics

AVERAGE

The arithmetic mean of the numbers.

Syntax

=AVERAGE(number1, [number2], …)

Arguments

• number: Numbers, cells or ranges.

Example

=AVERAGE(B2:B10) → Mean of B2 through B10

Practise it

• AVERAGE, MIN and MAX
• IFERROR and IFNA
• Mean, median and mode
• Standard deviation and z-scores
• Challenge: the class gradebook
• Challenge: customer survey results