AVEDEV(n1,n2,n3)
- are positive integers.
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:
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 7 | 1.75 | ||
| Row2 | 6 | |||
| Row3 | 9 | |||
| Row4 | 3 | |||
| Row5 | 0 | |||
| Row6 |
Where N1, N 2 ... are positive integers. =AVEDEV (B2:B5) is 1.75