Excel provides the AVEDEV function for this very purpose! ... However, the variance can be a confusing number to work with. ... In addition, youa#39;ll find the standard deviation is more commonly used than the variance in statistical analyses.
|Title||:||Microsoft Office Excel 2007 Formulas and Functions For Dummies|
|Author||:||Ken Bluttman, Peter G. Aitken|
|Publisher||:||John Wiley & Sons - 2008-02-11|