Slope of Non-Linear Curve

[addcapital]

Hello,

I am looking out for calculating Slope of Curve for non linear time series using Excel. In general linear form we can easily do this using SLOPE() function but when it's non-linear how do we can calculate tangent point and slope at that point ?

Thanks in Advance.

 

[financeguy]

Hello,

I am looking out for calculating Slope of Curve for non linear time series using Excel. In general linear form we can easily do this using SLOPE() function but when it's non-linear how do we can calculate tangent point and slope at that point ?

Thanks in Advance.

Don't think there's anything set up by Excel for you to use. I think you'll just have to come up with a numerical method to approximate the slope at any given point.

 

[koupparis]

\(\frac{y_2-y_1}{x_2-x_1}\)? Am I missing something?

 

[financeguy]

\(\frac{y_2-y_1}{x_2-x_1}\)? Am I missing something?

yeah basically except i would use an averaging (or weighted averaging) of the rate of change from the point behind the point in question to the point, and that from the point in question to the point after it