The Smarter Regression add-in for linear and logistic regression in excel
Loading...
Authors
Buttrey, Samuel E.
Subjects
Computer programming
Software
Software engineering
Software
Software engineering
Advisors
Date of Issue
2007
Date
2007
Publisher
Monterey, California. Naval Postgraduate School
Language
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.
Type
Technical Report
Description
Series/Report No
Department
Organization
Identifiers
NPS Report Number
NPS-OR-07-002
Sponsors
Funder
Format
ii, 14 p.: ill. (some col.);28 cm.
Citation
Distribution Statement
Approved for public release; distribution is unlimited.