Journal of Statistics: Advances in Theory and ApplicationsAuthor's: Jian-Hua Ding, Ling-Ying Shuai, Jie-Bo Xue and Jun Li
Pages: [17] - [30]
Received Date: January 7, 2018; Revised February 2, 2018
Submitted by:
DOI: http://dx.doi.org/10.18642/jsata_7100121917
In this article, the degrees of freedom of the residual variance of simple linear regression are simulated by using the VBA (Visual Basic for Application) of Microsoft Excel 2010. The simulation file dynamically demonstrates why the residual variance should be calculated by dividing the sum of squared errors by n - 2 rather than n, which can be displayed in class and is helpful for students to grasp the meaning of degrees of freedom.
degrees of freedom, linear regression, excel simulation.
