+ Reply to Thread
Results 1 to 2 of 2

Value of X Axis at Point of intersection of graph

  1. #1
    Registered User
    Join Date
    11-28-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    30

    Value of X Axis at Point of intersection of graph

    can any 1 help me out with the solution for getting the value of x axis as a output at the point of intersection of graph.
    Line A Xvalues Yvalues Line B Xvalues Yvalues
    0.00 0 0.00 0
    10.00 13.16034096 36.37 82.25832595
    15.00 20.52397047 40.00 115.8194413
    20.00 28.4946725 43.64 134.3326777
    25.00 37.13602193 47.28 138.9411748
    30.00 46.51159363 50.91 148.3278756
    35.00 56.68496247 54.55 157.8096965
    40.00 67.71970333 58.19 160.7829491
    45.00 79.67939109 61.82 162.5015485
    50.00 92.62760063 65.46 163.047185
    55.00 106.6279068 69.10 163.3801609
    60.00 121.7438845 72.73 164.1433416
    65.00 138.0391086 76.37 165.1955453
    70.00 155.577154
    75.00 174.4215955
    80.00 194.636008
    85.00 216.2839664
    90.00 239.4290456
    95.00 264.1348205
    100.00 290.4648658

    eg.xlsx
    Last edited by sac0011; 11-28-2013 at 03:00 AM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,809

    Re: Value of X Axis at Point of intersection of graph

    I generally think of two generic approaches to this kind of problem. Choose which approach you want to use, and we can help you implement it.

    1) Curve fitting/regression: a) Select a suitable equation for each curve. b) regress coefficients for each curve using suitable regression routines. If the equations chosen in (a) are "linear," then we can use the LINEST() function to find those coefficients. If there are non-linear parameters, then we will have to use Solver or similar to get the coefficients. c) With usable equations for each curve, we now have a system of equations for which we need to find the solutions. So we pull out our algebra text and remember how to solve systems of equations (I like this tutorial http://www.purplemath.com/modules/syseqgen.htm).

    2) Sometimes, rather than finding a single pair of equations that describes the entire data set, it is easier to define each curve as a collection of straight lines connecting the individual data points. This is called linear interpolation. This approach looks like this: a) Locate the interval for each curve that contains the intersection point. b) Use the boundary points for that interval for each equation to find slope and intercept for each curve over that interval. This can be accomplished using a combination of the MATCH(), INDEX(), and LINEST() (or SLOPE() and INTERCEPT()) functions. c) As before, with the coefficients of these two straight lines, you can solve the system of equations.

    Choose an approach and we'll help you program it in.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 09-09-2015, 10:07 AM
  2. Need Help Regarding Points of intersection in graph.
    By rajiv3888 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-05-2012, 09:50 AM
  3. [SOLVED] Projection of Intersection values on Y and X axis
    By RahulMani in forum Excel General
    Replies: 0
    Last Post: 06-05-2006, 10:35 AM
  4. Intersection of a graph
    By pdgood in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2006, 10:30 PM
  5. Marking point of intersection on double y axis chart?
    By TheBigLoofah in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-22-2006, 07:10 PM

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