AVERAGE « Statistical functions « Microsoft Office Excel 2007 Tutorial






21.1.AVERAGE
21.1.1.AVEDEV(number1,number2,...) returns the average of the absolute deviations of data points from their meanAVEDEV(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)AVERAGE(number1,number2,...) returns the average (arithmetic mean)
21.1.3.=AVERAGE(B2:B6, 5) returns the average of the numbers and 5=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)Use AVERAGE with more than one range: =AVERAGE(A1:A12, B1:B12)