# AVEDEV

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

Returns the average deviation of the numbers in a list, table or cell range.

 number1 The first number. number2 The second number. number3 (Optional) The third number.

 REMARKS
 * The average deviation is a measure of dispersion.* 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 are empty, then these are ignored.* If any of the arguments contain text or logical values, 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.* For an illustrated example refer to the Quant > Dispersion > Mean Deviation page.* For the Microsoft documentation refer to support.microsoft.com

 A B 1 =AVEDEV(4,5,6) = 0.667 5 2 =AVEDEV(4,5,6,0) = 1.875 3 =AVEDEV(4,4,4) = 0 4 =AVEDEV(4,2,5) = 1.111 5 =AVEDEV(4,FALSE,5) = 2 6 =AVEDEV(4,FALSE,B1) = 2 7 =AVEDEV("4",FALSE,TRUE) = 2 8 =AVEDEV("4",FALSE,B3) = 2 9 =AVEDEV("4",FALSE,TRUE) = 2 10 =AVEDEV(4,"some text",5) = #VALUE!

 1 - What is the average deviation of these values from their mean. The mean value is 0.667.2 - What is the average deviation of these values from their mean. Zeros are included so the mean is 1.875.3 - What is the average deviation of these values from their mean. The mean value is 0.4 - What is the average deviation of these values from their mean. The mean value is (4+2+5)/3.