+ Reply to Thread
Results 1 to 3 of 3

tinterception point from a grahp in Excel

  1. #1
    mic
    Guest

    tinterception point from a grahp in Excel

    how to find interception point from a grahp with 2 series of data in Excel

  2. #2
    Jerry W. Lewis
    Guest

    Re: tinterception point from a grahp 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



  3. #3
    Bernard Liengme
    Guest

    Re: tinterception point from a grahp 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" <mic@discussions.microsoft.com> wrote in message
    news:92483817-0F39-4B65-94EB-36232947A861@microsoft.com...
    > how to find interception point from a grahp with 2 series of data in Excel




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1