OT: Excel regression modeling using VBA



#2

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.


Possibly Related Threads…
Thread Author Replies Views Last Post
  Quadratic & Cubic Regression RPN progs Matt Agajanian 9 3,002 09-17-2013, 11:37 AM
Last Post: Jeff O.
  Dynamic Gaussian Quadrature code in Excel VBA Namir 4 1,797 07-30-2013, 07:37 PM
Last Post: Namir
  Where is linear regression on an HP-41 Palmer O. Hanson, Jr. 22 5,727 08-13-2012, 10:43 PM
Last Post: Gerson W. Barbosa
  WP 34S linear regression bug Nigel J Dowrick 9 3,033 05-12-2012, 06:23 PM
Last Post: Paul Dale
  OT: To All Number Crunchers: Don't miss this VBA numeric library Namir 0 829 04-04-2012, 11:25 AM
Last Post: Namir
  35s Quadratic Regression J Noël 11 3,271 02-04-2011, 08:19 AM
Last Post: Dieter
  for those that use excel hugh steers 7 2,149 10-18-2007, 10:55 AM
Last Post: Thomas Okken
  OT: Excel strikes again! Rodger Rosenbaum 6 1,793 09-26-2007, 12:11 PM
Last Post: Eamonn
  HP35s / RPN Calculator Simulator in Excel / Java? Thomas Chrapkiewicz 6 1,909 08-23-2007, 07:30 AM
Last Post: Thomas Chrapkiewicz
  How to use linear regression using 19bii? Jim Webber 3 1,437 05-07-2007, 12:10 AM
Last Post: Howard Owen

Forum Jump: