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.
The LINEST function gives you most of the numbers you need to do the regression however.