The use of spreadsheet packages in industrial engineering - The case of regression analysis with binary dependent variables

Ernst P. Goss, Bernard J. Schroer

Research output: Contribution to journalArticle

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 languageEnglish (US)
Pages (from-to)129-132
Number of pages4
JournalComputers and Industrial Engineering
Volume18
Issue number2
DOIs
StatePublished - 1990
Externally publishedYes

All Science Journal Classification (ASJC) codes

  • Computer Science(all)
  • Engineering(all)

Fingerprint Dive into the research topics of 'The use of spreadsheet packages in industrial engineering - The case of regression analysis with binary dependent variables'. Together they form a unique fingerprint.

  • Cite this