An Excel Spreadsheet and VBA Macro for Model Selection and Predictor Importance Using All-Possible-Subsets Regression
Two of the most challenging aspects of teaching regression analysis pertain to model selection and the relative importance of predictors. All-possible-subsets (APS) regression is a particularly useful tool for addressing both of these topics. When using regression analysis to analyze customer satisf...
Main Author: | Michael Brusco |
---|---|
Format: | Article |
Language: | English |
Published: |
Bond University
|
Series: | Spreadsheets in Education |
Online Access: | http://sie.scholasticahq.com/article/8064-an-excel-spreadsheet-and-vba-macro-for-model-selection-and-predictor-importance-using-all-possible-subsets-regression.pdf |
Similar Items
-
Excel VBA Macro for the Robust Design of Static Multiple Responses
by: Chih-Kai Yang, et al.
Published: (2011) -
Solution to Secondary Sedimentation Problem by Spreadsheet and VBA
by: Selami Demir -
The Call Center Scheduling Problem using Spreadsheet Optimization and VBA
by: Perry, Katherine
Published: (2012) -
Optimal Production Scheduling using VBA on Microsoft Excel
by: Pornrat Thumrongvut
Published: (2019-02-01) -
Assessing Excel VBA Suitability for Monte Carlo Simulation
by: Alexei Botchkarev