How to Show/calculate End-values of Trendline?

[H. Forstner]

Hello,

(Excel 2007)

I created a graph and a linear trendline, showing the equation:
y = mx+b

B determines the starting point.

How can I get the value of the end of the trendline?


Thanks for your help

rgds
Harry

 

[Bernard Liengme]

The b parameter (the "intercept" ) is value of y at x=0 (where the line
crosses the y axis). It is not really an 'end'. To compute the value of y at
any other value of x (let's say at a value of x stored in G3) use =slope*G1
+ intercept. Now you could copy the slope and intercept values from the chart
but you are better off using the SLOPE and INTERCEPT function. Read about
these in Help and them post a new mesage to get more help.
best wishes

 

[H. Forstner]

Hello Bernard,

The b parameter (the "intercept" ) is value of y at x=0 (where the line
crosses the y axis). It is not really an 'end'.

Sure. At X=0 I meant the start of the visible line.

And I would like to calculate the end of the visible trendline.

To compute the value of y at
any other value of x (let's say at a value of x stored in G3) use =slope*G1
+ intercept.

What is G1 or G3?


rgds
harry