본문 바로가기
  • Home

Re-exploring teaching and learning of probability and statistics using Excel

  • Journal of The Korea Society of Computer and Information
  • Abbr : JKSCI
  • 2016, 21(7), pp.85-92
  • Publisher : The Korean Society Of Computer And Information
  • Research Area : Engineering > Computer Science

이승범 1 박정은 2 Choi Sang-Ho 1 Kim Dong-Joong 1

1고려대학교
2University of Delaware

Accredited

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.

Citation status

* References for papers published after 2022 are currently being built.