Forum Discussion
automate regression data analysis (from the "data" tab) of a table that updates
Is it possible to automate regression data analysis (from the "data" tab) of a table that updates itself when another row is add in the table
- Are you referring to the regression analysis dome using the Analisys Toolpak add-in? I'm afraid you have to redo that each time as that add-in spits out hard-coded results.
The LINEST function gives you most of the numbers you need to do the regression however.
