Variance in Excel

Fundamentals of Social Statistics by Adam J. McKee

As you may have noticed from looking at how standard deviation (s) is computed, the variance (s-square) is merely the standard deviation squared.  It is not widely reported in the scientific literature by itself because people cannot intuitively interpret it.  It is, however, very useful in later statistical techniques.

Computing the Variance

To compute the Variance, simply square the standard deviation.

Computing Variance in Excel

To compute the variance of a set of scores in Excel, use the VAR function.

variance in Excel
Figure 17. Variance in Excel.

Key Terms

Standard Deviation, Variance


[ Back | Contents | Next ]

Last Modified:  06/03/2021

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Doc's Things and Stuff uses Accessibility Checker to monitor our website's accessibility.