Thread: Calculating the Slope Of A Trendline

Hi!
Lets say I have two points from which I created a trendline using the LINEST and INTERCEPT formulas. How do I calculate the slope of this trendline in degrees? Is there a formula for that? I tried the slope function and it doesn't give degrees.
Thanks!
Dima
PS: I attached the example.

Originally Posted by dima777

Hi!
Lets say I have two points from which I created a trendline using the LINEST and INTERCEPT formulas. How do I calculate the slope of this trendline in degrees? Is there a formula for that? I tried the slope function and it doesn't give degrees.
Thanks!
Dima
PS: I attached the example.

slope is not given in degrees. maybe you want something like the angle of elevation.

if that is the case, please type out your problem. no one likes to open .zip files. a paranoid bunch, we are