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 Showing Problem ? 3
Trendline Question 0
Trendline Not Appearing In Chart Problem ? 0
Trendline Question 1
Help with area under trendline 0
Sr. Citizen Question On Adding A Trendline, Please ? 1
Trendlines: When Excel Will Draw, And When Will Not Be Drawn, ForScatter Charts 0
How would I attach or assign values to a trendline? 4

Top