Excel Forum

Excel Magic Trick #97: AVEDEV function

Basic Statistics. See how to use the AVEDEV function to measure the spread (variation) in a data set. Also see the STDEV function. Measure whether a mean represents its data points fairly.

Formula and functions

Got a Question? Ask it Here in the Forum.