• 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 Korea Computer Industry Society
• /
• v.9 no.5
• /
• pp.207-216
• /
• 2008

Statistical analysis menus of MS Excel software, with powerful spreadsheet functions has not been modified since Excel 2000 Edition and its utilization is very low. To improve utilization of Excel menu for statistical analysis, this research compared outputs of Excel statistical menus and computed test statistics, and developed high-level macros. Outputs of Excel menus, both oneway layout and twoway layout, on real data are exactly same as the computed test statistics, and therefore, Excel menus for statistical analysis are reliable. Macros to provide results for Analysis of Variance with a block and multiple comparison of means are developed using Excel functions.

• Journal of the Korean Data and Information Science Society
• /
• v.25 no.6
• /
• pp.1419-1429
• /
• 2014

In this paper, we consider the development of encryption of DES (data encryption standard) based on Microsoft Excel Macro, which was adopted as the FIPS (federal information processing standard) 46 of USA in 1977. Concrete explanation of DES is given. Algorithms for DES encryption are adapted to Excel Macro. By repeating the 16 round which is consisted of diffusion (which hide the relation between plain text and cipher text) and the confusion (which hide the relation between cipher key and cipher text) with Excel Macro, we can easily get the desired DES cipher text.

• 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.23 no.6
• /
• pp.1203-1212
• /
• 2012

In this paper, we consider the development of round key generator of DES (data encryption standard) based on Microsoft Excel Macro, which was adopted as the FIPS (federal information processing standard) of USA in 1977. Simple introduction to DES is given. Algorithms for round key generator are adapted to excel macro. By repeating the 16 round which is consisted of diffusion (which hide the relation between plain text and cipher text) and the confusion (which hide the relation between cipher key and cipher text) with Microsoft Excel Macro, we can easily get the desired DES round keys.

• The Korean Journal of Applied Statistics
• /
• v.21 no.2
• /
• pp.355-359
• /
• 2008

In order to make students more interesting in statistics class, a small visual basic program is introduced. This program, which can be executed through the Excel Macro, can immediately collect many individual questionnaire files that were filled up by participatory students and consolidate into one Excel worksheet.

• 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.

• 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 Korean Data and Information Science Society
• /
• v.23 no.5
• /
• pp.905-912
• /
• 2012

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.

• Journal of the Korea Computer Industry Society
• /
• v.10 no.5
• /
• pp.213-220
• /
• 2009

Regression analysis to estimate the fitted models and test hypotheses are basic statistical tools for survey data as well as experimental data. Data is collected as pairs of independent and dependent variables, and statistics are computed using matrix calculation. To estimate a best fitted model is a key to maximize reliability of regression analysis. To fit a regression model, plot data on XY axis and select the most fitted models. Researchers estimate the best model and test hypothesis with MS Excel's graph menu and matrix computation functions. In this study, I develop macros to estimate the fitted regression model and test hypotheses of relationship between variables. Subway electric charges data with one dependent variable and three independent variables are tested using developed macros, and compared with the results using built-in Excel of regression analysis.