Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > AVEDEV
 

AVEDEV(number1, number2 [,number3] [,…])

 
 Returns the average deviation for a list of numbers.

 number1The first number.
 number2The second number.
 number3The third optional number.

 REMARKS
 
  		• This function returns the average of the absolute deviations from the mean.
     
  		• This function is a measure of the variability in a data set.
     
  		• You can also use a single array or a reference to an array instead of arguments separated by commas.
     
  		• The arguments must be either numbers or names, arrays, or references that contain numbers.
     
  		• If any of the arguments contain text, logical values, or empty cells, then these are ignored.
     
  		• If any of the arguments are zero, then these are counted.
     
  		• If any of the arguments are not numeric, then #VALUE! is returned.
     
  		• You can have a maximum of 30 arguments.

     EXAMPLES
     
     AB
    1=AVEDEV(4,5,6,7,5,4,3) = 1.0205
    2=AVEDEV(4,4,4) = 0 
    3=AVEDEV(4,2,5) = 1.111 
    4=AVEDEV(4,FALSE,5) = 2 
    5=AVEDEV(4,FALSE,B1) = 2 
    6=AVEDEV("4",FALSE,TRUE) = 2 
    7=AVEDEV("4",FALSE,B2) = 2 
    8=AVEDEV("4",FALSE,TRUE) = 2 
    9=AVEDEV(4,"some text",5) = #VALUE! 
    		 
     Functions - A | Index - A | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top