Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to write a macro to do a regression analysis? I tried
recording a macro while doing one but it never took.

Thanks for the help

Chris
 
I recorded a macro when I did it against some test data and got this code:

Application.Run "ATPVBAEN.XLA!Regress", ActiveSheet.Range("$B$1:$B$28"), _
ActiveSheet.Range("$A$1:$A$28"), False, True, , "", True, True, True, _
True, , True

If you look at the dialog for that regression option, you can try to match up
those checkmarks/values to the order that the function requires.

This may help with that order:
inpyrng,inpxrng,constant,labels,confid,soutrng,
residuals,sresiduals,rplots,lplots,routrng,nplots,poutrng
 
Back
Top