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.
Haney, Mark H.
A Spreadsheet Simulation to Teach Concepts of Sampling Distributions and the Central Limit Theorem,
Spreadsheets in Education (eJSiE):
3, Article 3.
Available at: https://epublications.bond.edu.au/ejsie/vol8/iss3/3
Spreadsheet with sampling from approximately normal population
interactive_sampling_distribution_MLB_salaries_skewed_population.xlsx (120 kB)
Spreadsheet with sampling from skewed population