• Journal of Korea Entertainment Industry Association
• /
• v.15 no.6
• /
• pp.71-80
• /
• 2021

This study is aimed at analyzing the characteristics of each service quality and the requirements of the customers followed by the classification of service quality factors of youth sports clubs by using Kano model. For this purpose, a survey was conducted by targeting on 257 subjects in 10 youth sports clubs in Seoul and Gyeonggi areas and for data processing, Microsoft Office Excel 2016 and SPSS 22.0 were used to carry out Frequency Analysis, Factor Analysis, Reliability Analysis, Kano model Quality Classification, Timko's Customer Satisfaction Coefficient, and the computation and analysis of Public-service Customer Satisfaction Index. The following shows the research findings. First, as a result of using Kano model to classify each item of the service quality factors of the youth sports club through Dualistic Quality Theory Attribution, one-dimensional quality elements resulted in all 22 items of service quality factors of youth sports club. Second, the customer satisfaction coefficient computation result showed that satisfaction coefficient appeared by the order of 'kind response of the instructor,'(0.81), 'attitude of the instructor'(0.80), 'systematic lecture program'(0.76), and 'variety of program)'(0.76) and dissatisfaction coefficient appeared by the order of 'clean and pleasant facility'(-0.79), 'attitude of the instructor'(-0.76), 'kind response of the instructor'(-0.76), 'convenience of parking facility'(-0.73), and 'promptness of business process'(-0.73). Third, the public-service customer satisfaction index placing appeared by the order of the 'attitude of the instructor', 'kind response of the instructor', 'clean and pleasant facility' and 'systematic lecture program'.

• The Journal of Korean Medicine
• /
• v.32 no.1
• /
• pp.56-66
• /
• 2011

Background: This was a study to analyze Sanghanron through network theory, as the first attempt to construct network models for systems biomedicine in traditional Korean medicine. For this purpose, we investigated the network structure with priority given to two-node connections between symptoms and herbs of Taeyangbyung compilation in Sanghanron. Purpose: We had three goals in carrying out this study. First, to establish the minimum clinical grouping data sets for symptoms and herbs of Taeyangbyung compilation in Sanghanron. Second, to make index files for the obtained data sets. Third, to generate a network structure for systems biomedicine in this part, and analyze its relationship. Methods: Using MS office Excel and Netminer software, we constructed the minimum clinical grouping data sets and the network for systems biomedicine about symptoms and herbs of Taeyangbyung compilation in Sanghanron, and analyzed its relationship. Results: We established the minimum clinical grouping data sets for symptoms and herbs of Taeyangbyung compilation in Sanghanron, using MS Excel. We constructed a network to structurize our database through two-node connections of Netminer program, and analyzed its relationships. Conclusions: Further research on network model for systems biomedicine between symptoms and herbs for three Yang and three Um(Taeyang, Soyang, Yangmyung, Taeum, Soum, Gualum) disease compilation is necessary.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.14 no.11
• /
• pp.5752-5761
• /
• 2013

This study was performed to propose the developmental direction of the elderly suicide study by analyzing the trend of study in elderly suicide. A literature search was conducted using RISS, KISS, Nanet. A total of 184 research articles which were published on elderly suicide in Korea from 1996 to 2013 were analyzed with structured analysis forms. For statistical analysis, frequency and percentage were used with EXCEL program. As a results, a study on elderly suicide in the social welfare sector was actively and a survey of general elderly proportion of the study was high. In addition, most concepts of research were associated with suicidal ideation, depression, social support, and stress of the elderly. Therefore, existing in previous studies classified as high-risk elderly people living alone, poor elderly, a man who attempted suicide risk in elderly subjects research through a variety of research methods will be made.

• Food Science of Animal Resources
• /
• v.32 no.1
• /
• pp.118-124
• /
• 2012

This study was conducted for quantitative microbial risk assessment (QMRA) of Clostridium perfringens with consumption on ham and sausage products in Korea, according to Codex guidelines. Frame-work model as product-retail-consumption pathway composed with initial contamination level, the time and temperature in distributions, and consumption data sets for ham and sausage products and also used the published predictive growth and dose-response models for Cl. perfringens. The simulation model and formulas with Microsoft@ Excel spreadsheet program using these data sets was developed and simulated with @RISK. The probability of foodborne disease by Cl. perfringens with consumption of the ham and sausage products per person per day was estimated as $3.97{\times}10^{-11}{\pm}1.80{\times}10^{-9}$. There were also noted that limitations in this study and suggestion for development of QMRA in the future in Korea.

• Herbal Formula Science
• /
• v.23 no.2
• /
• pp.209-224
• /
• 2015

Objective : The main purpose of this study is to find a reasonable solutions for utilization of herbal formulas based on the medical classics. Methods : We used official Ten 'Selected Korean Medical Classics(SKMC)'. For input of formulas from SKMC, we had to select proper editions of them. After consultations with experts of 'The Korean Medicine Society for the Herbal Formula Study' and 'Korean Society of Medical History', we chose the proper editions of SKMC, and according to those books, we built formulas database using microsoft office excel sheets, respectively. Results : After whole input procedures, we requested several experts to inspect the results and also, to correct errors in them. Input categories were name of formula, name of classic, classification, original source, composition herb, weight, unit of weight, weight conversion index, converted weight, basic formula, indications, reason for modification, preparing method, taking method and contraindications. Final number of whole formulas in DB was 32,882. Conclusions : We used SKMC and built database using excel program. Through this procedure, we can provide a developmental ways to make a foundation for herbal formulas from the medical classics, so that we can make herbal formulas be standardized or industrialized more efficiently.

• Aerospace Engineering and Technology
• /
• v.1 no.1
• /
• pp.8-27
• /
• 2002

In this study, the load analysis of a composite canard aircraft is performed numerically. Excel visual basic program for PC is used to calculate aerodynamic coefficients, loads and moments etc.. The basic data required for the load analysis such as aircraft configuration and dimension, parts and its weight and coordinate etc. are obtained from Catia modeling, measurement or material density. Aircraft weight, center of gravity, inertia moment, structural design speeds, wing load distribution, forces and moments are evaluated by using these data. V-n diagram is also represented for selecting critical loads applied to the wing and fuselage. The V-n diagram is investigated to decide the flight envelope of canard aircraft for design speed VA, VC, VD and load factor +3.8G, -1.52G at maximum weight of 2,573 lbs and sea level. In the future, the results of the wing and fuselage load analysis is to represented by using selected critical loads.

• The Journal of the Society of Korean Medicine Diagnostics
• /
• v.14 no.1
• /
• pp.57-69
• /
• 2010

Background: This is a study for building up the database foundation and about graphic structures of Ontology Network systems of Taeyangbyung compilation in Sanghannon in Traditonal Korean Medicine. Therefore, we began to this study about the systematic clinical ontology network systems with priority given to symptoms of Taeyangbyung compilation in Sanghannon. Purpose: We have two goals to carry out this study. The first, we will establish the minimum clinical grouping data sets about symptoms of Taeyangbyung compilation in Sanghannon. The second, we will find out graphic structures of ontology network system in this part, and analysis that. Methods: Through MS office Excel, Access and Netminer software, we will construct the minimum clinical grouping data sets and the graphic structures of ontology network system about symptoms of Taeyangbyung compilation in Sanghannon, and analysis that. Results: We established the minimum clinical grouping data sets about symptoms of Taeyangbyung compilation in Sanghannon through MS Excel and Access software, and constructed the ontology images to structurize our database through Netminer program, and analysis that. Conclusions: Further research about ontology network between symptoms and prescription and three Yang and three Um(Taeyang, Soyang, Yangmyung, Taeum, Soum, Gualum) Disease compilation is necessary.

• Journal of Veterinary Clinics
• /
• v.19 no.3
• /
• pp.312-315
• /
• 2002

Diagnostic tests often require the determination of cut-off values that discriminate uninfected from infected individuals. The receiver operating characteristic (ROC) curve has been frequently used to attain this purpose and gives a representation of diagnostic accuracy (sensitivity and specificity) of a prediction model when varying the cut-point of a decision rule on a whole spectrum. We have written and tested a visual basic application program in EXCEL for maximum likelihood estimation of a binormal ROC curve, which also computes univariate statistics of a diagnostic test employed. Examples applying for computed tomographic images in radiology and methicillin-resistant Staphylococcus aureus research are given to illustrate this approach. This stand-alone module is available from the first author on request.

• The Journal of the Korea Contents Association
• /
• v.22 no.3
• /
• pp.134-140
• /
• 2022

The purpose of this study was to investigate the directives and Wh-words in the directives from elementary 2nd, 4th and 6th grade Korean textbooks. After entering all directives into Microsoft Office Excel, directives with Wh-words were separated. The analysis program, Natmal, was used for the analysis of the directives and Wh-words. The criteria from previous studies were also applied for this analysis process. As a result of the study, there are a lot of nouns and verbs in directives. They were consisted of sentences with an average of 6.9 Eojeol. There were a total of 11 types of Wh-words and 'Mueot(what), Eotteon(which), eotteohge(how)' appeared most frequently in all grades. For question types, both grades had more inferential questions than literal information questions. This results were expected to be used as basic data for language interventions with school aged children who have language disorders.

• Journal of Advanced Navigation Technology
• /
• v.27 no.1
• /
• pp.77-95
• /
• 2023

In this study, the conceptual design of a tilt + stopped rotor type electric vertical take-off and landing (eVTOL) aircraft was performed using design iteration. Based on Hyundai Motor's S-A1, the mission profile was defined using the concept of urban air mobility (UAM), and configuration design and aerodynamic analysis were performed using OpenVSP and XFLR5 software. After estimating the required power for the designed eVTOL, the required performance of the battery and the maximum take-off weight (MTOW) were calculated. . It was iteratively calculated using Microsoft Excel and Visual Basic Application, and a new electric motor weight estimation formula was derived. Also, the sensitivity analyses of each design variables of an eVTOL was performed using the automated program.