• Journal of the Korea Computer Industry Society
• /
• v.9 no.5
• /
• pp.207-216
• /
• 2008

Statistical analysis menus of MS Excel software, with powerful spreadsheet functions has not been modified since Excel 2000 Edition and its utilization is very low. To improve utilization of Excel menu for statistical analysis, this research compared outputs of Excel statistical menus and computed test statistics, and developed high-level macros. Outputs of Excel menus, both oneway layout and twoway layout, on real data are exactly same as the computed test statistics, and therefore, Excel menus for statistical analysis are reliable. Macros to provide results for Analysis of Variance with a block and multiple comparison of means are developed using Excel functions.

• Journal of the Korea Computer Industry Society
• /
• v.9 no.5
• /
• pp.223-228
• /
• 2008

A case study to show MS Excel's convenient and powerful functions was conducted to test hypotheses with subway data. Quantitative variables were described using descriptive menu, and qualitative variables were described using histogram menu of a MS Excel software. Relationships were tested using regression menu, differences were tested using t-test menu, and factors were tested using variance-layout menu of a Excel software. Data input, management, and statistical analysis were done successfully with only a MS Excel software.

• Journal of Korea Society of Industrial Information Systems
• /
• v.15 no.5
• /
• pp.187-196
• /
• 2010

We present a link that allows Excel to call the functions in the lp_solve system. lp_solve is free software licensed under the GPL that solves linear and mixed integer linear programs of moderate size. Our link manages the interface between Excel and lp_solve. Excel has a built-in add-in named Solver that is capable of solving mixed integer programs, but only with fewer than 200 variables. This link allows Excel users to handle substantially larger problems at no extra cost. Futhermore, we introduce that a network drawing method in Excel using arc adjacency lists of a network.

• Korean Management Science Review
• /
• v.19 no.2
• /
• pp.41-58
• /
• 2002

New attempt has been made on Management Science (MS) education since the end of 1990s. The most distinctive feature of the new attempt is using spreadsheet program like Excel as a teaching tool for MS course. The spreadsheet program gives an excellent tool for modeling and solvina MS problems. In order to improve the pedagogical effect through using the spreadsheet program for MS course, new teaching model based on spreadsheet encompassing new course contents, effective instruction method, and examination method is needed. For this purpose, professors teaching MS should share their own teaching experiences and methods. So this paper explains remarkable functions of Excel and how to use them for the MS tools. This paper also stresses the importance of team project and case study to improve the effect of MS education through the use of Excel and presents some tips on MS education.

• Journal of the Korea Computer Industry Society
• /
• v.10 no.5
• /
• pp.213-220
• /
• 2009

Regression analysis to estimate the fitted models and test hypotheses are basic statistical tools for survey data as well as experimental data. Data is collected as pairs of independent and dependent variables, and statistics are computed using matrix calculation. To estimate a best fitted model is a key to maximize reliability of regression analysis. To fit a regression model, plot data on XY axis and select the most fitted models. Researchers estimate the best model and test hypothesis with MS Excel's graph menu and matrix computation functions. In this study, I develop macros to estimate the fitted regression model and test hypotheses of relationship between variables. Subway electric charges data with one dependent variable and three independent variables are tested using developed macros, and compared with the results using built-in Excel of regression analysis.

• Journal of the Korea Society of Computer and Information
• /
• v.9 no.3
• /
• pp.201-209
• /
• 2004

In this paper, You can design drawing to safekeep and manage equipments in order to utilize efficiently by making use of Visio, and can convert stored data into Office data after inputting user attributes of each equipment. that means that you can analyze each data by using functions of Excel after changing Visio safe attributes into Excel data and XML data, and control and utilize data effectively by converting XML data into DB ones. Additionally. you can use on deliveration of useful information on shopping mall. At last, we present how to share and utilize transformed equipments on the web by designing and making and transforming Data type for good management of equipments of computers existed in university.

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

• Korean Journal of Computational Design and Engineering
• /
• v.10 no.5
• /
• pp.349-355
• /
• 2005

This paper concerns about how and why design frameworks for optimization should consider various software development environments such as MATLAB, VB, VBscript, Python, Tcl, PHP, Perl, and JAVA. The frameworks can be utilized by many engineers who have a basic concept about the optimization theory and/or basic knowledge about the computer programming languages. The framework will integrate a number of remote CAE tools, automatically execute them for design optimization, and have the capabilities of post-processing of data such as objective functions, state variables and design variables using a third-party spreadsheet program like Excel. The prototype framework developed in this study will be applied to various examples of optimization problems and show the validity of the proposed method of a framework implemenation.

• Journal of the Korea Society of Computer and Information
• /
• v.22 no.11
• /
• pp.143-149
• /
• 2017

In this paper, we propose efficient management method of liberal education for improving computer literacy. We analyzed the actual conditions and factors affecting education and reflected the analysis results in education. The subject of the study is 'Practice Excel', and tested achievement based on computer literacy. In order to evaluate objectively, we conducted CBT(Computer Based Test) based on Computer Specialist in Spreadsheet & Database Level-2. Analysis of the questionnaire included the use of the popular statistical program, IBM SPSS 24 trial, and frequency, ANOVA, t-test, crossover analysis, and correlation. Evaluation results, An important factor influencing educational performance was active participation. It also proved to be very helpful for understanding excel functions & expression.

• Korean Journal of Computational Design and Engineering
• /
• v.7 no.2
• /
• pp.102-109
• /
• 2002

This paper presents a method for automatic generating of check sheet to measure deep-drawn sheet metal. By using polyhedral model of CAD, the proposed procedure calculates measuring points automatically. The results of measure are exported to MS-Excel. The proposed method is implemented by API functions and C language using SPEED plus CAD/CAM system and MS-Window OLE.