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

• 한국데이터정보과학회:학술대회논문집
• /
• 2006.04a
• /
• pp.155-161
• /
• 2006

To enhance the interest and comprehension of learners studying Statistics. The program which learners can use is needed. With the help of this program, the interest and concentration of the learners can be enhanced, and the effects of the study of Statistics can be maximized, through the convenience of calculation to the theoretical contents of Statistics, various graphs, the, simulation.

• Genomics & Informatics
• /
• v.11 no.1
• /
• pp.55-57
• /
• 2013

Growing numbers of studies employ cell line-based systematic short interfering RNA (siRNA) screens to study gene functions and to identify drug targets. As multiple sources of variations that are unique to siRNA screens exist, there is a growing demand for a computational tool that generates normalized values and standardized scores. However, only a few tools have been available so far with limited usability. Here, we present siMacro, a fast and easy-to-use Microsoft Office Excel-based tool with a graphic user interface, designed to process single-condition or two-condition synthetic screen datasets. siMacro normalizes position and batch effects, censors outlier samples, and calculates Z-scores and robust Z-scores, with a spreadsheet output of >120,000 samples in under 1 minute.

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

• International Journal of Computer Science & Network Security
• /
• v.23 no.9
• /
• pp.37-46
• /
• 2023

The main aim of the article is to solve the problem of automating price monitoring using marketing forecasting methods and Excel functionality under martial law. The study used the method of algorithms, trend analysis, correlation and regression analysis, ANOVA, extrapolation, index method, etc. The importance of monitoring consumer price developments in market pricing at the macro and micro levels is proved. The introduction of a Dummy variable to account for the influence of martial law in market pricing is proposed, both in linear multiple regression modelling and in forecasting the components of the Consumer Price Index. Experimentally, the high reliability of forecasting based on a five-factor linear regression model with a Dummy variable was proved in comparison with a linear trend equation and a four-factor linear regression model. Pessimistic, realistic and optimistic scenarios were developed for forecasting the Consumer Price Index for the situation of the end of the Russian-Ukrainian war until the end of 2023 and separately until the end of 2024.

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

• Journal of Breast Disease
• /
• v.6 no.2
• /
• pp.35-38
• /
• 2018

Purpose: The eighth American Joint Committee on Cancer staging system for breast cancer was recently published to more accurately predict the prognosis by adding biomarkers such as estrogen receptors, progesterone receptors, and human epidermal growth factor receptor 2. However, this system is very complicated and difficult to use by clinicians. The authors developed a program to aid in setting up the staging system and confirmed its usefulness by applying it to theoretical combinations and actual clinical data. Methods: The program was developed using the Microsoft Excel Macro. It was used for the anatomic, clinical and pathological prognostic staging of 588 theoretical combinations. The stages were also calculated the stages using 840 patients with breast cancer without carcinoma in situ or distant metastasis who did not undergo preoperative chemotherapy. Results: The anatomic, clinical and pathological prognostic stages were identical in 240 out of 588 theoretical combinations. In the actual patients' data, stages IB and IIIB were more frequent in clinical and pathological prognostic stages than in the anatomic stage. The anatomic stage was similar to the clinical prognostic stage in 58.2% and to the pathological prognostic stage in 61.9% of patients. Oncotype DX changed the pathological prognostic stage in 2.1% of patients. Conclusion: We developed a program for the new American Joint Committee on Cancer staging system that will be useful for clinical prognostic prediction and large survival data analysis.

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