Browse > Article

A study on sampling using the function of excel  

Choi, Hyun-Seok (Department of Statistics, Keimyung University)
Kim, Tae-Yoon (Department of Statistics, Keimyung University)
Publication Information
Journal of the Korean Data and Information Science Society / v.21, no.3, 2010 , pp. 481-491 More about this Journal
Abstract
In this paper, we made a program to compare between population parameters and sample statistics, via Excel macro. This program gathers each students’ files to one file, from which a sample is drawn. This program will help students to be interested in class through extracting a part of sample from a group and comparing the difference between parameters and statistics in a few seconds. In Excel, overlapping value could happen when random numbers are generated but we avoid this case by making the sub-program, without replacement with VBA.
Keywords
Sampling; visual basic for application; without replacement;
Citations & Related Records
Times Cited By KSCI : 5  (Citation Analysis)
연도 인용수 순위
1 이정용 (2008), 엑셀 매크로 (MACRO) 기능을 이용한 통계학 참여수업의 예. <응용통계연구>, 21, 355-359.   과학기술학회마을
2 조신섭, 송문섭, 이윤모, 성병찬, 윤영주, 이현부 (1998). 기초통계교육을 위한 통계패키지의 비교 연구 및 엑셀을 이용한 한글 통계패키지의 구현. <한국통계학회 춘계학술발표회 논문집>, 75 -79.
3 조신섭, 송문섭, 이윤모, 성병찬, 윤영주, 이현부 (1999). 기초통계교육을 위한 통계소프트웨어의 개발 -Excel에 기초한-. <품질경영학회지>, 27 , 277-290.
4 Choi, H. S. (2006a). The teaching of statistics using excel vba. Journal of the Korean Data & Information Science Society, 17 , 811-820.   과학기술학회마을
5 Choi, H. S. (2006b). A program for teaching type 1 and type 2 errors. Journal of the Korean Data & Information Science Society, 17, 19-30.   과학기술학회마을
6 Choi, H. S., Choi, S. W. and Kim, T. Y. (2005). Computer program development for two populations inference. Journal of the Korean Data & Information Science Society, 16, 185-193.   과학기술학회마을
7 Choi, H. S. and Kim, T. Y. (2008). Various central limit theorem simulators with microsoft excel. Pushpa Publishing House, 24, 61-71.
8 Choi, H. S. and Song, G. M. (2005). Computer program development for probability distribution. Journal of the Korean Data & Information Science Society, 16, 581-589.   과학기술학회마을
9 Jacobson, R. (2002). Microsoft excel 2002 visual basic step by step, Microsoft Press, Washington.
10 Walkenbach, J. (2004). Excel 2003 power programming with vba, Wiley Publishing, New York.
11 신성도, 최명복 (1998). <내마음대로 활용하는 엑셀 매크로>, 기전연구사, 서울.