AVEDEV

Description Computes the average deviation of a list of numbers.

Syntax AVEDEV(number_list)

Argument Description

number_list A list of up to 30 arguments separated by commas. The list may contain numeric values, cell references, range references, or array constants.Text and logical values in range references and array constants are ignored. Text entered in the argument list will be evaluated as a number, if possible; otherwise it will cause a #VALUE! error. Logical values entered into the argument list are evaluated as numeric 1 if TRUE and numeric 0 if FALSE.

Argument	Description
number_list	A list of up to 30 arguments separated by commas. The list may contain numeric values, cell references, range references, or array constants.Text and logical values in range references and array constants are ignored. Text entered in the argument list will be evaluated as a number, if possible; otherwise it will cause a #VALUE! error. Logical values entered into the argument list are evaluated as numeric 1 if TRUE and numeric 0 if FALSE.

Equation

Examples This function returns 0.5:

AVEDEV(1,2)

See Also AVERAGE, COUNT, DEVSQ, KURT, SKEW