Browse > Article
http://dx.doi.org/10.7465/jkdi.2014.25.2.403

An educational tool for binary logistic regression model using Excel VBA  

Park, Cheolyong (Department of Statistics, Keimyung University)
Choi, Hyun Seok (Department of Statistics, Keimyung University)
Publication Information
Journal of the Korean Data and Information Science Society / v.25, no.2, 2014 , pp. 403-410 More about this Journal
Abstract
Binary logistic regression analysis is a statistical technique that explains binary response variable by quantitative or qualitative explanatory variables. In the binary logistic regression model, the probability that the response variable equals, say 1, one of the binary values is to be explained as a transformation of linear combination of explanatory variables. This is one of big barriers that non-statisticians have to overcome in order to understand the model. In this study, an educational tool is developed that explains the need of the binary logistic regression analysis using Excel VBA. More precisely, this tool explains the problems related to modeling the probability of the response variable equal to 1 as a linear combination of explanatory variables and then shows how these problems can be solved through some transformations of the linear combination.
Keywords
Binary logistic regression; Excel macro; odds ratio;
Citations & Related Records
Times Cited By KSCI : 4  (Citation Analysis)
연도 인용수 순위
1 Choi, H. S. and Park, C. (2013). An educational tool for regression models with dummy variables using Excel VBA. Journal of the Korean Data & Information Science Society, 24, 593-6012.   과학기술학회마을   DOI   ScienceOn
2 Choi, H. S. and Ha, J. (2012). Development of Bayes' rule education tool with Excel Macro. Journal of the Korean Data & Information Science Society, 23, 905-912.   DOI   ScienceOn
3 Jacobson, R. (2002). Microsoft excel 2002 visual basic for applications step by step, Microsoft Press, Redmond, WA.
4 Kim D. (2012). On the development of DES round key generator based on Excel Macro. Journal of the Korean Data & Information Science Society, 23, 1203-1212.   과학기술학회마을   DOI   ScienceOn
5 Lee, J. Y. (2008). An example of participatory statistics class using Excel Macro. The Korean Journal of Applied Statistics, 21, 355-359.   과학기술학회마을   DOI   ScienceOn
6 Walkenbach, J. (2004). Excel 2003 power programming with VBA, Wiley Publishing, New York.
7 Park, J. (2011). Application frame for logistic regression analysis with Excel VBA, Master Thesis, Seoul National University, Seoul.