| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use Tools, Data Analysis, Regression in Macros
I am trying to write a macro that includes using 'Regression' in "Data
Analysi"s but the Macro recorder will not recognise the actions. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to use Tools, Data Analysis, Regression in Macros
Bruce Edwards -
I am trying to write a macro that includes using 'Regression' in "Data Analysi"s but the Macro recorder will not recognise the actions. < As a workaround, you could avoid trying to use the Regression tool (which requires that the Analysis ToolPak add-in be installed) and instead use Excel's built-in LINEST array-entered worksheet function (perhaps with OFFSET to get specific results). - Mike www.mikemiddleton.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where can I find Tools : Data Analysis : Regression in Excel (Vist | Excel Discussion (Misc queries) | |||
| regression charts in data analysis | Charts and Charting in Excel | |||
| Data analysis tools | Excel Worksheet Functions | |||
| Charts generated by Data Analysis/Regression Add-in | Charts and Charting in Excel | |||
| Data analysis Regression in vba | Excel Programming | |||
Hybrid Mode
