Manuals/calci/AVEDEV

From ZCubes Wiki
Revision as of 03:51, 21 November 2013 by Abin (talk | contribs)
Jump to navigation Jump to search
AVEDEV(n1,n2,n3)


  • 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