HP Forums

Full Version: OT: Excel regression modeling using VBA
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

Hello All,

I have posted several articles on performing regression modeling and best regression model search on my web site. I also include the Excel files with the VBA code. The code in the various files and articles cover:

1. Multiple linearized regression and the regression ANOVA table.

2. Finding the best multiple linearized regression model.

3. Finding the best polynomial model (with a twist!).

If you are a regression junky like me and would like to find the best empirical fit (especially for established data or for obtaining approximation for various mathematical and statistical functions) then these articles are a MUST.


Edited: 6 Dec 2012, 10:08 a.m.