The Smarter Regression add-in for linear and logistic regression in excel
Buttrey, Samuel E.
MetadataShow full item record
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.
NPS Report NumberNPS-OR-07-002
Showing items related by title, author, creator and subject.
Rhinehart, Javan A. (Monterey, California: Naval Postgraduate School, 2017-09);Networks protected by firewalls and physical separation schemes are threatened by multi-homed devices. The purpose of this study is to detect multi-homed devices on a computer network. More specifically, the goal is to ...
Experiments in forecasting atmospheric marine horizontal visibility using model output statistics with conditional probabilities of discretized parameters. Karl, Michael L. (Monterey, California. Naval Postgraduate School, 1984-06);This report describes the development and application of a program to forecast important air/ocean parameters using the method (s) of model output statistics. The focus of this operationally oriented study is to forecast ...
Van Orman, Brian Lee; Renard, Robert Joseph (1977-06);Diagnostic model output parameters, provided by the Fleet Numerical Weather Central, Monterey, California (FNWC) , and the marine fog frequency climatology developed at the Naval Postgraduate School, Monterey, California, ...