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.
| Original language | English |
|---|---|
| Pages (from-to) | 129-132 |
| Number of pages | 4 |
| Journal | Computers and Industrial Engineering |
| Volume | 18 |
| Issue number | 2 |
| DOIs | |
| State | Published - 1990 |
| Externally published | Yes |
Fingerprint
All Science Journal Classification (ASJC) codes
- Information Systems and Management
- Management Science and Operations Research
- Industrial and Manufacturing Engineering
- Applied Mathematics
Cite this
The use of spreadsheet packages in industrial engineering - The case of regression analysis with binary dependent variables. / Goss, Ernest; Schroer, Bernard J.
In: Computers and Industrial Engineering, Vol. 18, No. 2, 1990, p. 129-132.Research output: Contribution to journal › Article
}
TY - JOUR
T1 - The use of spreadsheet packages in industrial engineering - The case of regression analysis with binary dependent variables
AU - Goss, Ernest
AU - Schroer, Bernard J.
PY - 1990
Y1 - 1990
N2 - 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.
AB - 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.
UR - http://www.scopus.com/inward/record.url?scp=0025680301&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=0025680301&partnerID=8YFLogxK
U2 - 10.1016/0360-8352(90)90023-F
DO - 10.1016/0360-8352(90)90023-F
M3 - Article
VL - 18
SP - 129
EP - 132
JO - Computers and Industrial Engineering
JF - Computers and Industrial Engineering
SN - 0360-8352
IS - 2
ER -