Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

AVEDEV(number1,number2, ) returns the average of the absolute deviations of data points from their mean

Input the formula: =AVEDEV(B2:B8). Press Enter to get the result. Referenced from Excel Help