Avedev Formula

=AVEDEV(Range)
Example:
=AVEDEV(A2:A9)
The function above is short for average deviation. It calculates the mean of the range and also calculates its deviation altogether.

Read More..