Accession Number:

ADA470645

Title:

The "Smarter Regression" Add-In for Linear and Logistic Regression in Excel

Descriptive Note:

Technical rept.

Corporate Author:

NAVAL POSTGRADUATE SCHOOL MONTEREY CA DEPT OF OPERATIONS RESEARCH

Personal Author(s):

Report Date:

2007-07-01

Pagination or Media Count:

17.0

Abstract:

The widely-used Excel spreadsheet program has a linear regression routine, but it has a number of drawbacks it does not handle categorical predictors it requires to the user to generate columns for interactions it cannot compute logistic regressions and it is limited to 16 predictor columns. We have developed an Excel add-in that does both logistic and linear regression, handles categorical and interaction variables in an obvious way, and removes the 16-column limit. We also support nested model tests and, for linear regression, transformations of the response variable. Although we do not claim that Excel is the proper tool for data analysis, our tool can make both small, quick analyses and introductory statistics courses simpler and more complete.

Subject Categories:

  • Computer Programming and Software
  • Statistics and Probability

Distribution Statement:

APPROVED FOR PUBLIC RELEASE