The Museum of HP Calculators

HP Forum Archive 21

[ Return to Index | Top of Index ]

OT: Excel regression modeling using VBA
Message #1 Posted by Namir on 6 Dec 2012, 10:05 a.m.

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.

[ Return to Index | Top of Index ]

Go back to the main exhibit hall