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

See

http://groups.google.com/groups?selm...40mediaone.net

Jerry

Anne wrote:

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

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 wrote:

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

--

Dave Peterson

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" wrote in message
...
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 wrote:

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

--

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.

Anne wrote:

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" wrote in message
...
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 wrote:

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

--

Dave Peterson


--

Dave Peterson