Ask Your Question
0

How can I reference the fit parameters of a trend line?

asked 2019-04-22 16:35:33 +0200

12stringpc gravatar image

For making projections, I would like to extrapolate my data using the parameters from the fitted trend line in a graph/chart. At present I need to type this information into the cells every time the fit changes. Is there any way to make a reference in a cell to the fit parameters. That would be awesome!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
2

answered 2019-04-22 18:33:56 +0200

Opaque gravatar image

updated 2019-04-23 11:47:15 +0200

Hello,

I'm not sure, If I got you right, but for linear trendline there is a SLOPE() and a INTERCEPT() function to get the parameters required for a linear function and with these you can perform a linear extrapolation.

In the example below

=SLOPE(B3:B12,A3:A12) and =INTERCEPT(B3:B12,A3:A12)

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-04-22 16:35:33 +0200

Seen: 28 times

Last updated: Apr 23