Data analysis Regression in vba


A

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
 
Ad

Advertisements

D

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
 
A

Anne

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

Advertisements

D

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.
 

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