Calling Regression Toolpack in a Macro

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

I want to call the Regression capability in Excel's Data Analysis Tool Pack
from a VBA macro. I have checked atpvbaen.xls in the Reference pulldown menu
item in the macro and Tool Pack VBA in Add-ins. The call syntax begins with
Application.Run "ATPVBEAN.XLA!Regress" , but how do I find what the
remaining parameters are to include in the call, including specifying the
input and output ranges?

Thanks for your help
Phil
 
Record a macro while you use the ATP menu system to call the regression tool.
Then examine the recorded syntax. Depending on what you want, it may be
simpler to use LINEST, which is the fundamental calculation engine underneath
the ATP regression tool.

Jerry
 
Back
Top