DEVSQ: Calculates the sum of the squared deviations from the mean (without dividing by N or N-1).
For the numbers 50, 47, 52, 46, and 45 that's 34.
Average Deviation: One more Excel function deals with deviations in a way other than squaring them.
The variance and standard deviation deal with negative deviations by squaring all the deviations before averaging them. How about if you just ignore the minus signs. This is called the absolute value of each deviation.
AVEDEV calculates the average absolute deviation of a group of numbers. For the numbers above it's 2.4
This statistic is less complicated than variance or standard deviation but is rarely used. Why? Statisticians can't use it as the foundation for additional statistics you meet later.
No comments:
Post a Comment