NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ1151211
Record Type: Journal
Publication Date: 2017
Pages: 4
Abstractor: As Provided
ISSN: ISSN-0141-982X
Understanding the Degrees of Freedom of Sample Variance by Using Microsoft Excel
Ding, Jian-Hua; Jin, Xian-Wen; Shuai, Ling-Ying
Teaching Statistics: An International Journal for Teachers, v39 n3 p92-95 Aut 2017
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.
Wiley-Blackwell. 350 Main Street, Malden, MA 02148. Tel: 800-835-6770; Tel: 781-388-8598; Fax: 781-388-8232; e-mail:; Web site:
Publication Type: Journal Articles; Reports - Descriptive
Education Level: N/A
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A