엑셀을 활용하여 확률과 통계 교수·학습을 재탐구하기

Abstract

The law of large numbers, central limit theorem, and connection among binomial distribution, normal distribution, and statistical estimation require dynamics of continuous visualization for students’ better understanding of the concepts. During this visualization process, the differences and similarities between statistical probability and mathematical probability that students should observe need to be provided with the intermediate steps in the converging process. We propose a visualization method that can integrate intermediate processes and results through Excel. In this process, students’ experiences with dynamic visualization help them to perceive that the results are continuously changed and extracted from multiple situations. Considering modeling as a key process, we developed a classroom exercise using Excel to estimate the population mean and standard deviation by using a sample mean computed from a collection of data out of the population through sampling.