Title

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