View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KBiggs418 KBiggs418 is offline
external usenet poster
 
Posts: 1
Default Can trendline equations be automatically entered into cells?

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.