Demonstrating The Central Limit Theorem In The Classroom: An Excel Exercise
The Central Limit Theorem (CLT) states that regardless of the underlying distribution, the distribution of the sample means approaches normality as the sample size increases. Understanding the CLT is central to other concepts presented in a business statistics class; however, the CLT remains one of most misunderstood concepts in introductory statistics. This paper describes the steps for developing a Microsoft Excel spreadsheet that allows students to visualize the CLT. In addition to introducing students to creative uses of spreadsheets, we show that student learning is enhanced by incorporating this pedagogical exercise in the classroom.
By making research freely available, we help support the greater global exchange of knowledge. There are no article submission or processing charges. Each journal volume is preserved via the Walker Library's three level preservation methods including local and cloud storage. The author(s) retains/retain the copyright to the work, but grants the Journal the right to publish, display, and distribute the work in print and electronic format. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons CC BY-NC-ND 4.0 license that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal. For more information on this license go to https://creativecommons.org/licenses/by-nc-nd/4.0.