文章基本信息

标题：A Spreadsheet Simulation to Teach Concepts of Sampling Distributions and the Central Limit Theorem
本地全文：下载
作者：Haney, Mark H.
期刊名称：Spreadsheets in Education
印刷版ISSN：1448-6156
出版年度：2015
卷号：8
期号：3
页码：3
出版社：Faculty of Information Technology, Bond University
摘要：This paper presents an interactive spreadsheet simulation model that may be used to help students understand the concept of sampling distributions and the implications of the central limit theorem for sampling distributions. The spreadsheet model simulates an approximation to a sampling distribution by taking 1,000 random samples from a population, calculating the mean of each sample, and then using percentage polygons to display the distribution of the sample means compared to the distribution of the population. A normal probability plot of the sample means is also created as a second tool for understanding the distribution of the sample means. The user may vary the size of the samples taken, and then observe the effects of sample size on the range and shape of the approximated sampling distribution. The spreadsheet model is built without macros or VBA programming, using only standard formulas and tools. The instructor may choose to build the model with students, or simply present it to them and lead them in experimenting with it, depending on the needs of the class.
关键词：spreadsheet; simulation; sampling distribution; central limit theorem; statistics education