Understanding the degrees of freedom of sample variance by using Microsoft Excel

Summary In this article, the degrees of freedom of the sample variance are simulated by using the Visual Basic for Applications of Microsoft Excel 2010. The simulation file dynamically displays why the sample variance should be calculated by dividing the sum of squared deviations by n‐1 rather than n, which is helpful for students to grasp the meaning of degrees of freedom.