Browse > Article
http://dx.doi.org/10.7465/jkdi.2012.23.5.905

Development of Bayes' rule education tool with Excel Macro  

Choi, Hyun-Seok (Department of Statistics, Keimyung University)
Ha, Jeong-Cheol (Department of Statistics, Keimyung University)
Publication Information
Journal of the Korean Data and Information Science Society / v.23, no.5, 2012 , pp. 905-912 More about this Journal
Abstract
We are dealing with the Bayes' rule education tool with Excel Macro and its usage example. When an event occurs, we are interested in whether it does under certain conditions or not. In this case, we use the Bayes' rule to calculate the probability. Bayes' rule is very useful in making decision based on newly obtained statistical information. We introduce an efficient self-teaching educational tool developed to help the learners understand the Bayes' rule through intermediate steps and descriptions. The concept and examples of intermediate steps such as conditional probability, multiplication rule, law of total probability, prior probability and posterior probability could be acquired through step-by-step learning. All the processes leading to result are given with diagrams and detailed descriptions. By just clicking the execution button, users could get the results in one screen.
Keywords
Bayes' rule; Excel Macro; form; posterior distribution; prior distribution;
Citations & Related Records
Times Cited By KSCI : 3  (Citation Analysis)
연도 인용수 순위
1 Albert, J. H. (1996). Bayesian computation using minitab, Duxbury Press, Belmont, CA.
2 Berry, D. A. (1996). Statistics : A Bayesian perspective, Duxbury Press, Belmont, CA.
3 Choi, H. S. and Ha, J. (2011). Development of process-oriented education tool for Statistics with Excel Macro. Journal of the Korean Data & Information Science Society, 22, 643-650.
4 Jacobson, R. (2002). Microsoft excel 2002 visual basic step by step, Microsoft Press, Redmond, WA.
5 Kim, J. H. and Baek, H. Y. (2011). Excel macro for applying Bayes' rule. Journal of the Korean Data & Information Science Society, 22, 1183- 1197.
6 Lee, J. Y. (2008). An example of participatory statistics class using Excel Macro. The Korean Journal of Applied Statistics, 21, 355-359.   DOI   ScienceOn
7 Walkenbach, J. (2004). Excel 2003 power programming with VBA, Wiley Publishing, New York, NY.