Calculates the average of the magnitudes of deviations of data from a dataset's mean.
Description
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!