AVEDEV

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

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

number1The first number.
number2The second number.
number3(Optional) The third number.

REMARKS
* For an illustrated example refer to the [[Dispersion]] page.
* 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 255 arguments.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 AB
1=AVEDEV(4, 5, 6) = 0.6675
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.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top