Manuals/calci/AVEDEV
AVEDEV (N1, N2...) Where N1, N 2 ... are positive integers.
AVEDEV returns the average of the absolute deviations of data points from their mean.
· Arguments can be numbers, names, arrays, or references.
· Logical values and text representations of numbers are calculated.
Formula:-
· The equation to find out the average deviation is:
AVEDEV
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 7 | 1.75 | ||
| Row2 | 6 | |||
| Row3 | 9 | |||
| Row4 | 3 | |||
| Row5 | 0 | |||
| Row6 |
AVEDEV (N1, N2...) Where N1, N 2 ... are positive integers.
=AVEDEV (B2:B5) is 1.75