Forum Discussion
Jesushdz2113
Nov 28, 2023Copper Contributor
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
JKPieterse
Nov 29, 2023Silver Contributor
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.