• Title/Summary/Keyword: MS Excel

Search Result 101, Processing Time 0.027 seconds

A case study of MS Excel's powerful functions for statistical data analysis. (Focused on an Analysis of Variance menu) (자료 통계 분석을 위한 MS 엑셀의 유용한 기능들에 관한 사례연구 (지하철 이용객 자료 분석))

  • Kim, Sook-Young
    • 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.

  • PDF

Spreadsheet-based Educational Method for Management Science (스프레드시트를 기반으로 한 새로운 경영과학 강의 방식)

  • 정기호
    • 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.

Test for reliability of MS Excel statistical analysis output and modification of macros (Focused on an Analysis of Variance menu) (MS 엑셀 프로그램의 통계분석결과 신뢰성 검증 및 매크로 보완 (분산분석 메뉴를 중심으로))

  • Kim, Sook-Young
    • 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.

  • PDF

Development of program for calculation of representative bed-material size by using MS ExcelTM (MS ExcelTM을 이용한 하상재료의 대표입경 계산 프로그램 개발)

  • Lee, Chanjoo;Nam, Ji-Su;Lee, In
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 2017.05a
    • /
    • pp.334-334
    • /
    • 2017
  • Representative particle sizes(RPS) are commonly used for particle size distribution of heterogeneous sediment such as bed material. RPS can provide not only information of mean characteristics of sediment, but also other properties like sorting, skewness, kurtosis. For sediment including sand and clay material, RPS is estimated through two steps. The first is experimental step for calculating weight of each size class, the next is interpolation step to get RPS by using the graph plot. At the second step, graph method known as direct reading of value along the interpolation line in the graph plot is commonly used. This method is often time-consuming job. In this study we developed a new program to get RPS by using MS Excel. Simple linear and semi-log interpolation are used. When compared with conventional graph method(direct reading), simple linear shows 5.31%, while semi-log 1.29% of relative difference. We developed MS Excel program for estimation of RPS automatically.

  • PDF

Application of MS Excel in Teaching Statics (엑셀 프로그램을 활용한 정역학 교육 사례)

  • Kim, Youngheub
    • 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.

Computer Simulation Program for Central Limit Theorem - Dynamic MS Excel Program -

  • Choi, Hyun-Seok;Kim, Tae-Yoon
    • Journal of the Korean Data and Information Science Society
    • /
    • v.16 no.2
    • /
    • pp.359-369
    • /
    • 2005
  • Central limit theorem is known as one of the most important limit theorem in statistics and probability. This paper provides a dynamic MS Excel program that demonstrates computer simulation of various types of central limit theorems. Our result will be of great use for better understanding of central limit theorems.

  • PDF

A Proposal for Improving the Perception of Differential Concept by Using a Well-Known Table Processor: MS Excel

  • Tolga, Kabaca;Seref, Mirasyedioglu
    • Research in Mathematical Education
    • /
    • v.12 no.3
    • /
    • pp.193-200
    • /
    • 2008
  • In this study, an innovative computer support has been suggested to improve differential perception of the students. Research has been conducted on a calculus class which has 35 students. A semi-structured interview has been reported in the study. By this interview, it was tried to make differential concept more understandable by using Micro Soft Excel component of the well-known MS Office software. By this aim, students have been asked to integrate a simple function by using MS Excel. At the end of the study, it was observed that differential concept made more sense in students' minds than previous.

  • PDF

Development of MS Excel Macros to estimate regression models and test hypotheses of relationships between variables (Application to regression analysis of subway electric charges data) (MS Excel 함수들을 이용한 회귀 분석 모형 추정 및 관계 분석 검정을 위한 매크로 개발 (지하철 전기요금 자료 회귀분석에 응용))

  • Kim, Sook-Young
    • 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.

  • PDF

Modelling of effluent and GHGs for wastewater treatment plants using by MS Excel simulator(PKES) (MS Excel 시뮬레이터(PKES)를 이용한 하수처리장 유출수 및 온실가스 모델링)

  • Bin, Jung-In;Lee, Byung-Hun
    • Journal of Korean Society of Water and Wastewater
    • /
    • v.28 no.6
    • /
    • pp.735-745
    • /
    • 2014
  • This paper presents PKES(PuKyung -Excel based Simulator) for WWTPs(wastewater treatment plants) by using MS Excel and VBA(Visual Basic for Application). PKES is a user-friendly simulator for the design and optimization of the whole plant including biological and physico-chemical processes for the wastewater and sludge treatment. PKES calculates the performance under steady or dynamic state and allows changing the mathematical model by the user. Mathematical model implemented in PKES is a improved integration model based on ASM2d and ADM1 for simulation of AS(activated sludge) and AD(anaerobic digestion). Gaseous components of $N_2$, $N_2O$, $CO_2$ and $CH_4$ are added for estimation of GHGs(greenhouse gases) emission. The simulation results for comparison between PKES and Aquasim(EAWAG) showed about the same effluent concentrations. As a result of verification using by measured data of BOD, TSS, TN and TP for 2 years of operation, calculated effluent concentrations were similar to measured effluent concentrations. The values of average RMSE(root mean square error) were 1.9, 0.8, 1.6 and 0.2 mg/L for BOD, TSS, TN and TP, respectively. Total GHGs emission of WWTP calculated by PKES was 138.5 ton-$CO_2$/day and GHGs emissions of $N_2O$, $CO_2$ and $CH_4$ were calculated at 21.7, 28.9 and 87.9 ton-$CO_2$/day, respectively. GHGs emission of activated sludge was 32.5 % and that of anaerobic digestion was 67.5 %.

A Study on Edit Order of Text Cells on the MS Excel Files (MS 엑셀 파일의 텍스트 셀 입력 순서에 관한 연구)

  • Lee, Yoonmi;Chung, Hyunji;Lee, Sangjin
    • Journal of the Korea Institute of Information Security & Cryptology
    • /
    • v.24 no.2
    • /
    • pp.319-325
    • /
    • 2014
  • Since smart phones or tablet PCs have been widely used recently, the users can create and edit documents anywhere in real time. If the input and edit flows of documents can be traced, it can be used as evidence in digital forensic investigation. The typical document application is the MS(Microsoft) Office. As the MS Office applications consist of two file formats that Compound Document File Format which had been used from version 97 to 2003 and OOXML(Office Open XML) File Format which has been used from version 2007 to now. The studies on MS Office files were for making a decision whether the file has been tampered or not through detection of concealed items or analysis of documents properties so far. This paper analyzed the input order of text cells on MS Excel files and shows how to figure out what cell is the last edited in digital forensic perspective.