Data analysis Regression in vba

[Anne]

I would like to make a macro that does the same as the menu-option: Tools -
Data Analysis - Regression?

Macro-recording results in somtething like:

Application.Run "ATPVBAEN.XLA!Regress", , , True, True, 95, , True, _
True, True, True, , True

Not very helpfull!

I can use the function RSQ, but I would like to have the extra information
of the menu option without having to program it all myself.

Thanks in advance
Anne

 

[Jerry W. Lewis]

See

http://groups.google.com/[email protected]

Jerry

 

[Dave Peterson]

If you record a macro when you're changing these options (one by one), you'll
see what changes.

But try them in this order:

inpyrng
inpxrng
constant
labels
confid
soutrng
residuals
sresiduals
rplots
lplots
routrng
nplots
poutrng

 

[Anne]

Thanks Dave for the suggestion.
What is the meaning of routrng and poutrng
I don't see them on the dialog window.
Anne

 

[Dave Peterson]

I don't know. In fact, when I recorded a couple of macros, I only got 12
parms. Maybe some experimenting when you record some macros varying your input
would give you an idea.