Ask Your Question

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

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

12stringpc gravatar image

updated 2020-10-28 12:54:23 +0100

Alex Kemp 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

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

Opaque gravatar image

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


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


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

Seen: 183 times

Last updated: Apr 23 '19