Logistic Regression via Excel Spreadsheets: Mechanics, Model Selection, and Relative Predictor Importance

INFORMS Transactions on Education

article

Michael Brusco¹ 

[1] Department of Business Analytics, Information Systems, and Supply Chain, Florida State University

关键词: logistic regression;    OLS regression;    all possible subsets;    lasso;    spreadsheets;   

DOI  :  10.1287/ited.2021.0263

学科分类：数学（综合）

来源: INFORMS

【 摘 要 】

Logistic regression is one of the most fundamental tools in predictive analytics. Graduate business analytics students are often familiarized with implementation of logistic regression using Python, R, SPSS, or other software packages. However, an understanding of the underlying maximum likelihood model and the mechanics of estimation are often lacking. This paper describes two Excel workbooks that can be used to enhance conceptual understanding of logistic regression in several respects: (i) by providing a clear formulation and solution of the maximum likelihood estimation problem; (ii) by showing the process for testing the significance of logistic regression coefficients; (iii) by demonstrating different methods for model selection to avoid overfitting, specifically, all possible subsets ordinary least squares regression and l1-regularized logistic regression (lasso); and (iv) by illustrating the measurement of relative predictor importance using all possible subsets.

【 授权许可】

CC BY|CC BY-SA|CC BY-ND|CC BY-NC|CC BY-NC-SA|CC BY-NC-ND