• Journal of the Korean Data and Information Science Society
• /
• v.22 no.6
• /
• pp.1183-1197
• /
• 2011

The prior distribution is the probability distribution we have before observing data. Using Bayes' rule, we can compute the posterior distribution, the new probability distribution, after observing data. Computing the posterior distribution is much easier than before by using Excel VBA macro. In addition, we can conveniently compute the successive updating posterior distributions after observing the independent and sequential outcomes. In this paper we compose some Excel VBA macros for applying Bayes' rule and give some examples.

• Journal of the Korean Data and Information Science Society
• /
• v.16 no.3
• /
• pp.581-589
• /
• 2005

The purpose of this thesis is to develop and introduce Add-in program which we can systematically, visually and dynamically study discrete probability distribution of binomial distribution, poisson distribution and hypergeometric distribution, and continuous probability distribution of normal distribution, exponential distribution, and the definition and characteristics of t distribution, F distribution and ${\chi}^2$ distribution to be driven from normal distribution, and graphs, the computation process of probability by using VBA which is the device of Excel.

• Journal of the Korean Data and Information Science Society
• /
• v.16 no.2
• /
• pp.185-193
• /
• 2005

This study develops and introduces the program for letting learners study statistics in a systematic and efficient way by using Excel tools such as VBA and Macro, when they study statistical inference at two populations. This study helps learners understand the steps on statistical inference at two populations by utilizing the systematic and visual techniques.

• Transactions of the KSME C: Technology and Education
• /
• v.2 no.1
• /
• pp.21-28
• /
• 2014

As one of the most famous spreadsheet programs that is widely applied to a variety of fields in business, MS Excel has also been used for educational purposes due to its feature of wide accessibility, enabling students to use the program through almost any kind of PC that now exists. The program is mainly used for numerical analysis and formulae applications in the fields of science and engineering. This paper shall provide the key to understanding the application of MS Excel to teaching Statics through the illustration of its essential functions for education. Also, the development process of the analysis program using macros and VBA(Visual Basic for Applications) is described for the deeper comprehension of advanced applications. Students were not only able to solve the Statics problems using basic features of MS Excel, but also discovered new systematic methods of approaching complex problems and developed application programs using macros and VBA.

• Journal of the Korea Society of Computer and Information
• /
• v.27 no.5
• /
• pp.149-156
• /
• 2022

Recently, there have been many reports of document-type malicious code injecting malicious code into Microsoft Office files. Document-type malicious code is often hidden by encoding the malicious code in the document. Therefore, document-type malware can easily bypass anti-virus programs. We found that malicious code was inserted into the Visual Basic for Applications (VBA) macro, a function supported by Microsoft Office. Malicious codes such as shellcodes that run external programs and URL-related codes that download files from external URLs were identified. We selected 354 keywords repeatedly appearing in malicious Microsoft Office files and defined the number of times each keyword appears in the body of the document as a feature. We performed machine learning with SVM, naïve Bayes, logistic regression, and random forest algorithms. As a result, each algorithm showed accuracies of 0.994, 0.659, 0.995, and 0.998, respectively.

• Journal of the Korean Data and Information Science Society
• /
• v.24 no.3
• /
• pp.593-601
• /
• 2013

We often need to include categorial variables as explanatory variables in regression models. The categorial variables in regression models can be quantified through dummy variables. In this study, we provide an education tool using Excel VBA for displaying regression lines along with test results for regression models with a continuous explanatory variable and one or two categorical explanatory variables. The regression lines with test results are provided step by step for the model(s) with interaction(s), the model(s) without interaction(s) but with dummy variables, and the model without dummy variable(s). With this tool, we can easily understand the meaning of dummy variables and interaction effect through graphics and further decide which model is more suited to the data on hand.

• Proceedings of the Korean Statistical Society Conference
• /
• 2005.05a
• /
• pp.141-146
• /
• 2005

7차 교육과정(1997)의 도입으로 확률 및 통계단원이 중등 수학 교과과정에서 독자적인 영역을 확보하게 된 만큼 그 목적에 부합하면서 효율적이고 흥미를 유발시킬 수 있도록 교과교육 매체 개발에 투자를 해야 할 시기라고 본다. 교과교육 매체의 한 방법으로 Excel을 중학 교육과정에 나타난 통계교과내용을 지원하게끔 Excel의 기본 메뉴, 분석도구, 그리고 Visual Basic을 활용한 매크로 작성방법에 대하여 다루었다.

• Journal of the Korean Data and Information Science Society
• /
• v.21 no.3
• /
• pp.481-491
• /
• 2010

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.

• Journal of the Korean Data and Information Science Society
• /
• v.22 no.4
• /
• pp.643-650
• /
• 2011

Recently the needs for education on Statistics is growing bigger, but a mathematics-oriented education makes college students loose interest in Statistics. On the hypothesis that motivating interest is the key factor for learning, we need to develop an education tool for Statistics that makes learners to study independently but throughly. By using Excel Macro, we develop and introduce add-in program, called PETS, which supplies not only results but also process to get them.

• Journal of the Korean Data and Information Science Society
• /
• v.25 no.2
• /
• pp.403-410
• /
• 2014

Binary logistic regression analysis is a statistical technique that explains binary response variable by quantitative or qualitative explanatory variables. In the binary logistic regression model, the probability that the response variable equals, say 1, one of the binary values is to be explained as a transformation of linear combination of explanatory variables. This is one of big barriers that non-statisticians have to overcome in order to understand the model. In this study, an educational tool is developed that explains the need of the binary logistic regression analysis using Excel VBA. More precisely, this tool explains the problems related to modeling the probability of the response variable equal to 1 as a linear combination of explanatory variables and then shows how these problems can be solved through some transformations of the linear combination.