View : 1331 Download: 0

Generalized additive models using Excel macro and VBA

Title
Generalized additive models using Excel macro and VBA
Authors
석혜은
Issue Date
1997
Department/Major
대학원 통계학과
Keywords
ExcelVBAmacromodel
Publisher
The Graduate School of Ewha Women's University
Degree
Master
Abstract
Excel v7.0 is recently very popular as a spreadsheet and useful software tool in data analysis for many non-statistician users, and specially offers a linear regression analysis module for the users. However, if the dependence of E(Y) on X in a regression model is far from linear, the procedure may lead them to an inadequate model. To avoid this situation, they might need to use another statistical software other than EXCEL, which makes them to spend extra time to learn it. Thus, several well-known modern regression techniques such as GAM(Generalized Additive Models) and ACE(Alternating Conditional Expectation) are programmed in EXCEL MACRO and VBA(Visual Basic for Application) and integrated herein. EXCEL v7.0 with this procedure helps the users get closer to an adequate interpretation of a relationship between response and predictors. ;엑셀(EXCEL)V7.0은 비통계학자들이 자료분석을 할 때 많이 사용하는 스프레드시트(spreadsheet)이며 유용한 소프트웨어(software)이다. 또한, 엑셀은 선형회귀모듈을 제공한다. 그러나, 회귀모형에서 X에 대한 E(Y)의 종속관계가 선형이 아니라면, 그 프로시져는 부적합한 모형으로 적합될 것이다. 그들에게는 엑셀이 아닌 다른 통계 소프트웨어를 습득하기 위해 이외의 시간(extra time)이 요구된다. 그래서, 최근에 잘 알려진 GAM(Generalized Additive Models)과 ACE(Alternating Conditional Expectation) Procedure를 엑셀 매크로와 VBA(Visual Basic for Application)로 구현해 보았다. 엑셀이 이러한 프로시져를 포함한다면, response와 predictor의 관계를 좀 더 정확하게 판단하는데 도움이 될 것이다.
Fulltext
Show the fulltext
Appears in Collections:
일반대학원 > 통계학과 > Theses_Master
Files in This Item:
There are no files associated with this item.
Export
RIS (EndNote)
XLS (Excel)
XML


qrcode

BROWSE