how to find interception point from a grahp with 2 series of data in Excel
how to find interception point from a grahp with 2 series of data in Excel
Depends on what kind of equations describe the 2 series.
If they are 2 straight lines:
y = a1 + b1*x
y = a2 + b2*x
Then you can algebraically solve to see that they intersect at
x = -(a1-a2)/(b1-b2)
For non-linear equations, use Solver.
Jerry
mic wrote:
> how to find interception point from a grahp with 2 series of data in Excel
Tell us more: are the lines linear?
In general, find equations of best fit and solve for x.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"mic" <[email protected]> wrote in message
news:[email protected]...
> how to find interception point from a grahp with 2 series of data in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks