Calculates the average of the magnitudes of deviations of data from a dataset's mean.

Syntax:

AVEDEV(value1, value2, ...)

value1 - The first value or range of the sample.

value2, ... - Additional values or ranges to include in the sample.

Notes:

If the total number of values supplied as value arguments is not at least two, AVEDEV will return an error.

AVEDEV will 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 dataset, divided by the number of elements in the dataset.

Step 1: To use the AVEDEV Formula, simply begin with your edited Excellentable:

Step 2: Then begin typing the AVEDEV formula in the area you would like to display the outcome:

Error.

User does not have sufficient privileges to access this Content Learn More

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`.