Calculates the average of the magnitude of deviations of data from a data set's mean.
Sample usage
AVEDEV(1,2,3,4,5,6,7,8,9,10)
AVEDEV(A2:A100)
Syntax
AVEDEV(value1, [value2, ...])
-
value1– The first value or range of the sample. -
value2, ...– Additional values or ranges to include in the sample.
Notes
-
AVEDEVwill ignore any text values in value arguments. -
The average deviation is the sum of the absolute values of the difference of each data point and the mean of the data set, divided by the number of elements in the data set.
See also
VARPA: Calculates the variance based on an entire population, setting text to the value '0'.
VARP: Calculates the variance based on an entire population.
VARA: Calculates the variance based on a sample, setting text to the value '0'.
VAR: Calculates the variance based on a sample.
STDEVPA: Calculates the standard deviation based on an entire population, setting text to the value '0'.
STDEVP: Calculates the standard deviation based on an entire population.
STDEVA: Calculates the standard deviation based on a sample, setting text to the value `0`.
STDEV: The STDEV function calculates the standard deviation based on a sample.
SKEW: Calculates the skewness of a data set, which describes the symmetry of that data set about the mean.
KURT: Calculates the kurtosis of a data set, which describes the shape and in particular the 'peakedness' of that data set.
DVARP: Returns the variance of an entire population selected from a database table-like array or range using an SQL-like query.
DVAR: Returns the variance of a population sample selected from a database table-like array or range using an SQL-like query.
DSTDEVP: Returns the standard deviation of an entire population selected from a database table-like array or range using an SQL-like query.
DSTDEV: Returns the standard deviation of a population sample selected from a database table-like array or range using an SQL-like query.
DEVSQ: Calculates the sum of squares of deviations based on a sample.