Can trendline equations be automatically entered into cells?

K

KBiggs418

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trendline Question 0
Trendline Showing Problem ? 2
Trendline Equation 5
Display Coefficients of a Polynomial Trendline 3
How would I attach or assign values to a trendline? 3
Trendline Question 1
trendline - request power --> get linear 1
using polynomial trendline equations 2

Top