value…: Optionally include one or more additional values or collections of values.
AVEDEV divides the sum of the numbers by the number of numbers to get the average. The difference (absolute value) between the average and each number is summed and divided by the number of numbers.
If value contains date/time values, a duration value is returned.
Examples
=AVEDEV(2, 2, 2, 4, 4, 4) returns 1.
=AVEDEV(2, 2, 2, 2, 3, 3, 3, 3, 4, 4, 4, 4) returns 0.666666666666667.
=AVEDEV("3d", "6d", "4d", "7d") returns 1d 12h, a duration value.
=AVEDEV("1/12/2010", "31/12/2011", "30/9/2013") returns 371d 18h 40m, also a duration value.