AVEDEV(number1,number2,...) returns the average of the absolute deviations of data points from their mean : AVERAGE « Statistical functions « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Statistical functions
3. AVERAGE

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

Referenced from Excel Help

21.1.AVERAGE
	21.1.1.	AVEDEV(number1,number2,...) returns the average of the absolute deviations of data points from their mean
	21.1.2.	AVERAGE(number1,number2,...) returns the average (arithmetic mean)
	21.1.3.	=AVERAGE(B2:B6, 5) returns the average of the numbers and 5
	21.1.4.	Use AVERAGE with more than one range: =AVERAGE(A1:A12, B1:B12)