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

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.

Open PDF

Document Details

Document Type
Technical Report
Publication Date
Jul 01, 2007
Accession Number
ADA470645

Entities

People

  • Samuel E. Buttrey

Organizations

  • Naval Postgraduate School

Tags

DTIC Thesaurus Topics

  • Air Flow
  • Basic Programming Language
  • Coefficients
  • Computations
  • Computer Programming
  • Computer Programs
  • Data Science
  • Data Sets
  • Flow
  • Information Science
  • Model Tests
  • Operations Research
  • Programming Languages
  • Spreadsheet Software
  • Statistical Analysis
  • Statistics
  • User Interface

Fields of Study

  • Computer science

Readers

  • Computational Linguistics
  • Life Cycle Cost Analysis
  • Psychometric Testing or Psychological Assessment.