• Communications for Statistical Applications and Methods
• /
• v.14 no.2
• /
• pp.301-307
• /
• 2007

A effective teaching method on correlation coefficient for elementary level statistics course is discussed in this article. The well known inequalities, such as Theorem 368 of Hardy et al. (1952), are used for the interpretation of concept of covariance. An Excel example is provided for the illustration of concept of correlation coefficient.

• CDE review
• /
• v.10 no.1
• /
• pp.29-38
• /
• 2004

최적화(optimization)는 “최선”이란 의미의 라틴어 “OPTIMUS”을부터 유래되었다. 공학에서 최적설계는 가능하면 짧은 시간에 최고성능을 갖는 제품을 값싸게 생산할 수 있는 설계로 정의한다. 2차 세계대전 이후 가볍고 성능이 우수한 항공기 구조물의 설계를 위하여 시작한 현대 최적설계 기법은 컴퓨터 계산능력의 발전과 함께 실용범위를 점차 확대하고 있다. 본 특집에서는 최적설계의 기본개념을 소개하기 위하여 최적설계의 정식화, 도해 최적화, 최적화의 수치적 기법, EXCEL을 이용한 최적설계 등을 간략하게 소개한다. (중략)

• 한국데이터정보과학회:학술대회논문집
• /
• 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.

• Journal of the Korean Chemical Society
• /
• v.63 no.3
• /
• pp.220-225
• /
• 2019

• Journal of the Korean Chemical Society
• /
• v.65 no.2
• /
• pp.79-82
• /
• 2021

• Journal of the Korean Society of Manufacturing Process Engineers
• /
• v.14 no.2
• /
• pp.127-133
• /
• 2015

In this study, an analytical model was developed for one-dimensional finite element analysis (1D FEA) of a spindle system of machine tools and then implemented to automate the FEA as a tool. FEA, with its vibration characteristics such as natural frequencies and modes, was performed using the universal FEA software ANSYS. VBA of EXCEL was used to provide the programming environment for its implementation. This enabled graphic user interfaces (GUIs) to be developed to allow interactions of users with the tool and, in addition, an EXCEL spreadsheet to be linked with the tool for data arrangement. The language of ANSYS was used to develop a code to perform the FEA. It generates an analytical model of the spindle system based on the information at the GUIs and subsequently performs the FEA based on the model. Automation helps identify the near-optimal design of the spindle system with minimum time and efforts.

• Journal of the Korean Society for Aeronautical & Space Sciences
• /
• v.46 no.1
• /
• pp.32-40
• /
• 2018

In this research, a method of deriving statistical weight prediction formula which is used during the conceptual design phase was studied and it was programmed using Microsoft Excel and verified by applying to jet transport aircraft. The database was built while referencing the variables of conventional wing weight estimation formulas and it was used for modeling the jet transport wing weight regression equation. The model was evaluated using the K-fold cross validation method to solve the overfitting problem of the model.

• Journal of the Korean Institute of Illuminating and Electrical Installation Engineers
• /
• v.21 no.10
• /
• pp.134-140
• /
• 2007

In recent years, power equipment and system standards have been increasing in both number and complexity. The standards that will soon be introduced to KOREA is the transmission system standards for harmonic emission limits assessing in distorting loads. Utility engineers, being under increasing time constraints, are turning more and more to software to quickly solve problems. This paper describes the methodology used to implement the above standards in Microsoft Excel in order to assist utility engineers to readily apply these standards in practical situations.

• Journal of The Korean Society of Agricultural Engineers
• /
• v.48 no.6
• /
• pp.31-41
• /
• 2006

The analysis used in this work was cost-benefit analysis method. All future costs and returns of a given mushroom house were discounted to the time of initial investment (present) by means of 3.5% discount rate. Then the cost of ownership was compared to the return from the system. This analysis method has been developed and coded into a balance sheet for use on a EXCEL program. Using this programmed analysis,a large number of the case studies were examined using different combinations of economic conditions. These results will be very useful to individuals considering investment in a mushroom house, or any similar production system. By the way of the sensitivity analysis for each important parameter, the change of the marginal cost-benefit period could be finally determined. These parameters were typically construction cost of mushroom house, cost of cooling system, required cooling and heating energy amounts, unit price of mushroom media bottle, growing number of media bottles, production weight per unit bottle, sale price of mushroom, and annual number of growing period, etc.

• Journal of Environmental Science International
• /
• v.26 no.4
• /
• pp.421-432
• /
• 2017

In this study, we examined the suitability of ten disinfection models for predicting the inactivation of Artemia sp. via single or combined physical and chemical treatments. The effect of Hydraulic Retention Time (HRT) on the inactivation of Artemia sp. was examined experimentally. Disinfection models were fitted to the experimental data by using the GInaFiT plug-in for Microsoft Excel. The inactivation model were evaluated on the basis of RMSE (Root Mean Square Error), SSE (mean Sum Square Error) and $r^2$. An inactivation model with the lowest RMSE, SSE and $r^2$ close to 1 was considered the best. The Weibull+Tail model was found to be the most appropriate for predicting the inactivation of Artemia sp. via electrolytic treatment and electrolytic-ultrasonic combined treatment. The Log-linear+Tail model was the most appropriate for modeling inactivation via homogenization and combined electrolytic-homogenization treatment. The double Weibull disinfection model was the most suitable for the predicting inactivation via ultrasonic treatment.