HP Forums
OT: Excel regression modeling using VBA - Printable Version

+- HP Forums (https://archived.hpcalc.org/museumforum)
+-- Forum: HP Museum Forums (https://archived.hpcalc.org/museumforum/forum-1.html)
+--- Forum: Old HP Forum Archives (https://archived.hpcalc.org/museumforum/forum-2.html)
+--- Thread: OT: Excel regression modeling using VBA (/thread-235440.html)



OT: Excel regression modeling using VBA - Namir - 12-06-2012

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.

Namir

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