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

• Proceedings of the Korean Institute of Information and Commucation Sciences Conference
• /
• 2006.05a
• /
• pp.251-254
• /
• 2006

마이크로 흐름센서는 종래의 반도체 집적회로 공정기술을 이용하여 소형으로 제작이 가능하며, 빠른 응답특성을 가지는 장점이 있어 다양한 응용이 기대되고 있다. 본 연구에서는 넓은 흐름의 세기영역에서 정밀한 감도를 가지는 2차원 마이크로 흐름센서를 실리콘 기판위에 설계하여 왔다. 이러한 흐름센서의 정확한 온도특성을 분석하고 이 결과로부터 최적을 온도 감지막 위치를 결정할 필요가 있다. 설계방법으로서 표계산 소프트웨어 Excel을 이용하여 열운송방정식의 차분 방정식을 매크로 기능을 이용하여 적용하고 워크시트 내에서 셀 참조방식을 활용하여 자동 계산을 수행하도록 구현하였다. 본 연구에서는 Excel을 활용한 효율적인 설계방법을 제시하고 하나의 히터와 양측에 한 쌍의 온도 감지막을 가진 마이크로 흐름센서에 대해서 열전달 특성을 계산하고 이로부터 최적을 온도 감지막 위치를 결정할 수 있었다.

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

• 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.15 no.3
• /
• pp.543-554
• /
• 2004

In teaching statistics, the part which is very important but difficult to understand to the students is estimation and hypothesis testing. This paper introduces the developed program about estimation and hypothesis testing by using Excel Macro. This program will help learners to study and use a statistical inference conveniently, and to get a good learning effect.

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

• Proceedings of the Korea Society of Mathematical Education Conference
• /
• 2006.04a
• /
• pp.25-37
• /
• 2006

영재를 위한 수학교육은 우리의 당면과제 중 하나이다. 능력 있는 학생들의 학습이 속진에 한정되는 것 보다는 심화자료 및 수학적 소프트웨어와 함께 하는 것이 더 의미 있을 것으로 기대된다. 본 연구는 스프레트쉬트를 사용한 수학적 아이디어의 탐구에 관한 것이다. 다음에 대해 논의하기로 하겠다. i) 스프레드쉬트는 비전통적이면서도 이용이 용이하며, 수학적 통찰을 위한 매개물이다. ii) 풍부하고, 흥미릅고, 가치있는 수학적 주제에 대해 스프레드쉬트를 이용할 수 있다. iii) 스프레드쉬트를 사용하여 학생들이 수학적 아이디어에 대한 흥미를 고취시킬 수 있다. iv) 스프레드쉬트는 학생들에게 그들의 창의적인 시각화 기술을 공개할 기회를 줌으로써 수학에 대한 폭넓은 도식적 이해를 제공한다. v) animation을 포함한 스프레드쉬트 도식들의 적절한 사용은 유익하면서도 흥미롭다. vi) 학생들은 일상생활에 나타나는 수학의 흥미로움을 발견할 것이다. vii) 교사는 지금의 지도방식에 스프레드쉬트를 통합할 수 있다. 특히 스프레드쉬트는 다음과 같은 면모도 가지고 있다. i) 창의적인 수학적 스프레드쉬트 모델들의 실제 과정들이 그 자체로써 수학적 개념발달에 이용될수 있다. ii) 스프레드쉬트 모델은 심화된 주제의 탐색을 위한 의미 있는 탐구과제를 제공한다. iii) 스프레드쉬트는 현장에서 사용되는 실제적 수학 도구이다. - 과학자나 공학도들의 사용도 증가되고 있다. 이것의 사용은 학생들이 현장에서 사용할 기술을 취득하게 할 수 있고, 같은 컴퓨터의 소프트웨어를 사용하는 가족의 대화 수단이 되기도 한다. 본 연구에서 우리는 스프레드쉬트의 4가지 실증적 예를 들어 보겠다. 또한 다른 영역에서 발전된 스프레드쉬트 모델의 몇 가지 도식적 산출물도 포함 할 것이다. 우리는 가장 대중적인 스프레드 쉬트인 Microsoft Excel 프로그램을 사용하였다. Excel의 수행과 Excel 연산의 설명을 담은 CD와 함께 다양한 사례들에 대한 논의는 (8)을 참고하기 바란다. 본고에서는 graphic animation 기술, 스크롤바의 사용을 간단하게 개괄하겠다. '동적형상들(movies)'를 만들 수 있는 간단한 매크로의 사용 등의 내용들은 각 자료를 사용할 수 있는 Excel 파일의 예와 함께 [1]과 [8]에 설명하였었다. 많은 인쇄물과 on-line 참고문헌, 매체자료들도 함께 제공하였다.

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

• The Journal of Korean Society for Radiation Therapy
• /
• v.25 no.1
• /
• pp.87-90
• /
• 2013

Purpose: Introducing CR (Computed Radiography) system created a process of printing therapy irradiation images and converting the degree of enlargement. This is to increase job efficiency and contribute to work improvement using a computerized method with home grown software to simplify this process, work efficiency. Materials and Methods: Microsoft EXCEL (ver. 2007) and VISUAL BASIC (ver. 6.0) have been used to make the software. A window for each shield block was designed to enter patients' treatment information. Distances on the digital images were measured, the measured data were entered to the Excel program to calculate the degree of enlargement, and printouts were produced to manufacture shield blocks. Results: By computerizing the existing method with this program, the degree of enlargement can easily be calculated and patients' treatment information can be entered into the printouts by using macro function. As a result, errors in calculation which may occur during the process of production or errors that the treatment information may be delivered wrongly can be reduced. In addition, with the simplification of the conversion process of the degree of enlargement, no copy machine was needed, which resulted in the reduction of use of paper. Conclusion: Works have been improved by computerizing the process of block production and applying it to practice which would simplify the existing method. This software can apply to and improve the actual conditions of each hospital in various ways using various features of EXCEL and VISUAL BASIC which has already been proven and used widely.

• The Journal of Society for e-Business Studies
• /
• v.25 no.3
• /
• pp.131-145
• /
• 2020

The numbers of SNS (Social Network Service) users and usage amounts are increasing every year. The influence of SNS is increasing also. SNS has a wide range of influences from daily decision-making to corporate management activities. Therefore, proper analysis of SNS can be a very meaningful work, and many studies are making a lot of effort to look into various activities and relationships in SNS. In this study, we analyze the SNS following relationships using Twitter, one of the representative SNS services. In other words, unlike the existing SNS analysis, our intention is to analyze the interests of the accounts by extracting and visualizing the accounts that two accounts follow in common. For this, a common following account was extracted using Microsoft Excel macros, and the relationship between the extracted accounts was defined using an adjacency matrix. In addition, to facilitate the analysis of the following relationships, a direction graph was used for visualization, and R programming was used for such visualization.