The Use of Spreadsheet Packages in Industrial Engineering: The Case of Regression Analysis with Binary Dependent Variables
Document Type
Article
Publication Date
1990
Department
Management and International Business
Abstract
Industrial engineers often rely upon multiple regressions in forecasting. However, in the case where the dependent variable is binary, the use of ordinary least squares regression, as provided by spreadsheet packages, introduces serious problems. This study provides an easily implemented alternative technique which solves these problems. The technique is implemented by adding a logit regression template to Lotus 1-2-3.
Publication Title
Computers and Industrial Engineering
Volume
18
Issue
2
First Page
129
Last Page
132
Recommended Citation
Goss, E. P.,
Schroer, B. J.
(1990). The Use of Spreadsheet Packages in Industrial Engineering: The Case of Regression Analysis with Binary Dependent Variables. Computers and Industrial Engineering, 18(2), 129-132.
Available at: https://aquila.usm.edu/fac_pubs/7343