Calling Regression Toolpack in a Macro


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
 
Ad

Advertisements

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top