Re: Asymptote from a set of data

<home@xxxxxxxxxxxxx> wrote in message
news:1136548307.440663.281490@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi
>
> The data does not fit exactly a log but it is the best way I could
> explain it. For example the breakdown of a diode at say 0.7 volts will
> show a very sharp increase. If I plot a straight line before the 0.7v
> and a straight line after the 0.7v and measure the intercept I can
> measure the "turning point".
> I am trying to produce a Excel VBA function to manage this, therefore I
> would like an algorithm to calc the intercept of the asymptote.
> Any suggestions?
>
> WayneL

Wayne,

Linearise the points below 0.7v and the points above 0.7v (which you can do
with excel as in the last post)
Will the intersection of the lines give you the point you want,
if so get the equation of both lines and solve.

Joe


.

Quantcast