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

How To Use in Sheets

AVEDEV(value1, [value2, ...])

External Links

Google Sheets - Standard Deviation, Variance, Average Deviation Functions Tutorial Sample,Population

Learn how to calculate Sample & Population Standard Deviation, Variance & Average Deviation in Google Sheets using STDEV, STDEVP, VAR, VARP, AVEDEV Statistical Functions and understand exactly what these functions do.

0Better Sheets Tutorials

No videos yet. Stay tuned!