Recalculating a Regression Output in Data Analysis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a regression analysis done on a template form that I want to update
itself every time I paste in a new set of data. I noted that the simple
analysis within a plot will update / recalculate -- but the more detailed
analysis in the Data Analysis section will not. How Can I get this to
re-assess the regression values/errors?

thanks
karin
 
karin -
I have a regression analysis done on a template form that I want to update
itself every time I paste in a new set of data. I noted that the simple
analysis within a plot will update / recalculate -- but the more detailed
analysis in the Data Analysis section will not. How Can I get this to
re-assess the regression values/errors? <
Click to expand...

See Help for the LINEST array-entered worksheet function.

- Mike
www.mikemiddleton.com
 
Back
Top