I have to analyze data a lot and doing this requires me to fit trendlines to
the data I'm working on. I then have to use the equation for the trendline to
continue my analysis. My question is whether there is a way to have the
equation for the trendline automatically entered into cells in the worksheet?

For example if i have a scatter plot of data points and i fit a linear
trendline (y = mx + b), is there a way to have the equation automatically
filled into cells in the worksheet (for example m would be cell A1 and b
would be in cell A2. This would mean that if i changed the data points on the
graph, the cells A1 and A2 would automatically update to the new parameters
of the trendline.

Thanks for the help.

KBiggs418 -

http://spreadsheetpage.com/index.php...dline_formulas

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"KBiggs418" wrote in message
...
I have to analyze data a lot and doing this requires me to fit trendlines
to
the data I'm working on. I then have to use the equation for the trendline
to
continue my analysis. My question is whether there is a way to have the
equation for the trendline automatically entered into cells in the
worksheet?

For example if i have a scatter plot of data points and i fit a linear
trendline (y = mx + b), is there a way to have the equation automatically
filled into cells in the worksheet (for example m would be cell A1 and b
would be in cell A2. This would mean that if i changed the data points on
the
graph, the cells A1 and A2 would automatically update to the new
parameters
of the trendline.

Thanks for the help.