AVEDEV function

This topic describes the formula syntax and usage of the AVEDEV function in the Data Quality Execute Formula transform.

Description

Returns the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set. Arguments are numeric columns in the data.

The equation for average deviation is:

(1/n)Σ|x-m|

Where n is the number of data points, x is a column value, and m is the mean of the values.

Syntax

AVEDEV(number1,number2,...)

The AVEDEV function syntax has the following arguments:

number1,number2,... number1 is required, subsequent numbers are optional. 1 to 255 arguments for which you want the average of the absolute deviations. Nonnumeric columns and empty fields are ignored. Fields containing the 0 value are included..

Example

Data: Y1=4, Y2=5, Y3=6, Y4=7, Y5=5, Y6=3, Y7=0


Formula	Result
`AVEDEV([Y1],[Y2],[Y3],[Y4],[Y5])`	0.880000
`AVEDEV([Y1],[Y2],[Y3])`	0.666667
`AVEDEV([Y1]:[Y2]:[Y3],[Y4],[Y5],[Y6],[Y7])`	1.673469