• Proceedings of the Korean Statistical Society Conference
• /
• 2003.05a
• /
• pp.219-224
• /
• 2003

Translation errors in the statistical funtions of the Korean Excel 2002 software are analyzed into three categories: Pure translation mistakes; Vague translation; Inconsistent translation. These errors have not been corrected at least for the last ten years and therefore, it is suspicious that the Korean agents for foreign software companies are more interested in marketing with monololy power than in improving quality of their products

• 한국데이터정보과학회:학술대회논문집
• /
• 2004.04a
• /
• pp.79-82
• /
• 2004

본 발표에서는 1998년 서울대학교 통계학과에서 개발한 KESS(Korean Educational Statistical System; http://stats.snu.ac.kr/time)의 추가로 개발된 내용을 소개하기로 한다 (조신섭 외, 1999). 추가로 개발된 모듈(module)들은 통계교육에서 필요로 하는 분석법들 중에서 회귀분석, 시계열분석과 연관된 내용들이다. 기존의 여러 가지 통계패키지와 비교해 보아 효율적인 통계교육을 위한 필수적인 옵션 및 분석 결과를 제공하도록 하였다.

• Communications of Mathematical Education
• /
• v.9
• /
• pp.299-316
• /
• 1999

본 논문에서는 스프레드쉬트 프로그램 중에서 가장 활용도가 높은 Excel을 이용하여 만든 여러 가지 모의실험이 확률 통계학습에 어떻게 활용되는 지를 제시함으로써 개념의 지도 및 문제풀이 능력 향상의 효율성을 높이는 방안을 모색하고자 한다. 즉 이는 단순한 이론적 수치계산이 아닌 구체적 경험을 제시하여 학생들에게 확률적 상황에 내재된 확률적 정보의 의미를 파악하게 함으로써 확률의 개념에 대한 이해를 돕고 확률 통계단원에 대한 흥미를 유발케 하고자 한다.

• Journal of Korean Society for Quality Management
• /
• v.24 no.2
• /
• pp.172-178
• /
• 1996

In this study, we developed a software for statistical process control. This software presents $\bar{x}$, R, CUSUM, EWMA control chart and process capability index. In this system, statistical process control methods are integrated into the automated method on a real time base. It is available in process control of specified type and can be performed on personal computer with network system.

• Proceedings of the KAIS Fall Conference
• /
• 2003.06a
• /
• pp.203-207
• /
• 2003

본 논문에서는 컴퓨터로 정밀 계측기 기들을 자동 제어하고 데이터？ 측정하기 위하여 기존의 상용 프로그램을 사용하지 않고 Extol VBA(Visual Basic for Applications)를 이용하는 방법에 대하여 연구하였다. 이는 반복측정 및 통계적 수치계산 둥에서 많은 장점을 지니고 있어 수많은 국가교정기관 및 일반 산업체에서 유용하게 사용될 수 있으리라 사료된다.

• Proceedings of the Korea Contents Association Conference
• /
• 2014.06a
• /
• pp.241-242
• /
• 2014

• Journal of radiological science and technology
• /
• v.32 no.1
• /
• pp.39-43
• /
• 2009

The medical diagnostic examination using ionizing radiation has improved the patients' life and brought revolution in medical examination along with the mechanical development. However, the development of medical imaging systems has also been the reason to increase the patients' exposure for ionizing radiation. ICRP recommends that each country adopts diagnostic reference levels depending on regional and national situations. The Korea Food & Drug Administration suggested the dosimetry measurement guideline for patients in 2007. Nonetheless, in reality, it is hard to know the skin dose of the patients when applying a x-ray since there is no radiation dosimeter in most of clinical situation. Therefore, this study sets a program based on the bit system to figure out easily the skin dose of a patients using MS Excel program in the PC setting. The results showed 10% better outcome.

• Journal of the Korean Society for Aeronautical & Space Sciences
• /
• v.37 no.9
• /
• pp.923-930
• /
• 2009

In this paper, we introduce a satellite conceptual design software which can be used for outlining a new satellite as well as for educational purpose. This software consists of three commercial tools: MATLAB, STK(Satellite Tool Kit), and Excel. The management of the design software is done by MATLAB which provides basic calculations, GUI(Graphical User Interface), Excel data base management, and STK control. STK, an orbital simulation software developed by AGI, takes a part of obtaining accurate orbital information of a satellite. Excel, a product of Microsoft, is used for the data base of previous satellites and for the saving place of temporary and final results of the software. The conceptual design of a satellite is to roughly estimate power system and mass. In the power system design, the sizes of solar array and battery are determined. Based on the database of existing satellites, we can estimate the subsystems's mass fraction of a target satellite. Design examples for Kompsat 1 and 2 are suggested for verification of the developed software.

• Journal of Wetlands Research
• /
• v.18 no.3
• /
• pp.226-231
• /
• 2016

Land Generated Waste Load Unit(LGWLU) estimation based on land use data is required to understand the impact of land use on water quality. The method of estimating LGWLU based on the monitoring data requires a lot of time and manpower. In this study, we propose a method of land pollution unit load estimation based on land use data with LP optimization. Optimization is the process to obtain the best possible optimal solution in a given condition. This study carried out optimization by using excel solver in Microsoft Excel. This study derived LGWLU of BOD, T-N, T-P in Gongju-Si and Seocheon-Gun by using the 2012 land use map made by ministry of environment based on 2010 satellite image. This study about LGWLU estimation is expected to be able to determine more clearly the water pollution caused by land use changes.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.40 no.4
• /
• pp.129-136
• /
• 2017

Climate change is the biggest environmental issue of our times. A variety of activities to reduce greenhouse gas emissions have been in progress to observe the Kyoto Protocol. Especially, the Energy Target Scheme is created to reduce greenhouse emission with the supervision of Korean government. This includes Green-house Gas Information Systems to promote activities in the private sector to reduce green-house gas emissions, to cut a cost of energy use, and to reduce GHG emissions. Also, the system has calculated the amount of greenhouse gases. Without any additional investment, 2.75% savings are increased over the previous year. In service sector, a cooperation of customers and employees is necessary. A reduction of GHG emissions requires a proper service organization, considering an amount of investment and payback period. Without any additional investment or replacement, employees can save energy easily turning off ventilation systems an hour before employees' departure, installing timers to turn off water purifiers and vending machines after some period of no use. The Green-house Gas Information System is similar to that of Environmental Management System. However, the Excel is the best program to calculate an amount of green-house gas emissions, and to assess for a reduced amount of GHG emissions. A goal of this research is to propose a practical method in the private sector to calculate an amount of green-house gases. The Green-house gas Information System based on Excel spreadsheet gives standards for good evaluation. The greenhouse gas information system establishes and executes the policies and objectives related to greenhouse gas emissions Similar to ISO 14001 environment management system structures, the advantages of using simplified Excel Sheet for calculating GHG emissions and reducing GHG emissions are easy to access.