Recalculating a Regression Output in Data Analysis

[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

 

[Mike Middleton]

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? <

See Help for the LINEST array-entered worksheet function.

- Mike
www.mikemiddleton.com