Investment Studio > Expressions > Functions > Statistical > AVEDEV
float avedev(float data [, ...])
Returns the average of the absolute deviations of all data points from their arithmetic mean: given N data points,
| N | |||
| avedev = | 1 | å | |datak - average(data)| |
| ¾ | |||
| N | |||
| k = 1 |
All elements in the argument list are converted to floats (with exclusion if conversion fails). The list may contain array arguments, in which case each array element is treated as a separate list element.
Example
The expression
=avedev(1, 2, 3, 4, 5)
equals 1.2.
See also average, devsq, kurt, skew, stdev, stdevp, var, varp.