Data analysis Regression in vba

Posted to microsoft.public.excel.programming

Anne[_3_]

external usenet poster

Posts: 2

Data analysis Regression in vba

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2002 Analysis ToolPak Regression Analysis Help Requested	MH	Excel Worksheet Functions	1	February 28th 09 07:16 AM
Where can I find Tools : Data Analysis : Regression in Excel (Vist	Kristen M.	Excel Discussion (Misc queries)	2	December 3rd 08 10:55 AM
regression charts in data analysis	kourtney	Charts and Charting in Excel	1	February 14th 08 10:40 PM
Charts generated by Data Analysis/Regression Add-in	[email protected]	Charts and Charting in Excel	7	April 3rd 07 11:29 PM
Recalculating a Regression Output in Data Analysis	karin	Excel Worksheet Functions	1	August 23rd 05 03:40 AM

All times are GMT +1. The time now is 05:12 PM.

Menu

About Us