avedev

Syntax:

Value Number  avedev(Range source)

Description:

Computes the average deviation of numerical cells in source.

Examples:

($d4) = avedev($a1:$c3)
Before:
AB CD
1147
2258
3369
4
5
6
After:
AB CD
1147
2258
3369
42.22222222222222
5
6
($a1) = avedev($b1:$d20)