AVEDEV ( argument-list )
Description: Computes the average of the absolute deviations of a set of data points from their mean. AVEDEV is a measure of the variability in a data set.
Mathematical Formula:
The number of combinations is as follows, where number = n and number-chosen = k:
Arguments:
|
Name |
Type |
Description |
|
argument-list |
logical, number, name, array, or reference that contains a number. The list can be a single argument that is an array or a reference to an array. |
The arguments in argument-list designate the values for which the average of the absolute deviations is to be computed. Logical values and text representations of numbers occurring directly in the list of arguments are included. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0value 0 are included. |
Return Type and Value: number – The average of the absolute deviations of a set of data points from their mean.
[Example:
AVEDEV(-3.5,1.4,6.9,-4.5) results in 4.075
AVEDEV({-3.5,1.4,6.9,-4.5}) results in 4.075
end example]