+ Reply to Thread
Results 1 to 7 of 7

Intersection of 2 Perpendicular Lines - Apparent Error in Intersection Coordinates

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2013
    Posts
    35

    Intersection of 2 Perpendicular Lines - Apparent Error in Intersection Coordinates

    Could anyone explain this please...

    I have plotted an arbitrary line y=0.83333*x +3. I needed a 2nd Line perpendicular to this going through the Origin (0,0). To be perpendicular that line needs a slope of -1*1/0.83333 = -1.2. That will be y = -1.2*x. I have used the formula as in the Diagram attached and get a a point of intersection. But this point is apparently wrong as it could be seen in the diagram. Any explanation?
    Int.JPG
    Thanks a lot...

    - pd -

  2. #2
    Registered User
    Join Date
    11-26-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: Intersection of 2 Perpendicular Lines - Apparent Error in Intersection Coordinates

    Adding to my question above, this is what I get from Geogebra...
    Geo.JPG

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    Re: Intersection of 2 Perpendicular Lines - Apparent Error in Intersection Coordinates

    How did you get your x value? The intercept formula is roughly -3/2 which is not -0.67. I think you inverted the division.
    Rory

  4. #4
    Registered User
    Join Date
    11-26-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: Intersection of 2 Perpendicular Lines - Apparent Error in Intersection Coordinates

    Thank you very much rorya. When I invert the formula it works. I had taken the formula from this link: https://www.listendata.com/2012/10/e...wo-linear.html. The same formula could be found in many other places and fora too. That is why I am puzzled. Are they all wrong?

    Here is the result when I invert the formula:
    Early_Problem.JPG

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    Re: Intersection of 2 Perpendicular Lines - Apparent Error in Intersection Coordinates

    No, the formula you posted was correct: (int2 - int1)/(slope1 - slope2)

    which is: (0-3)/(0.83333-1.2) = -3/2.033333 = -1.47541

    What you appear to have calculated was: (slope1 - slope2)/(int2 - int1)

    which is: 2.033333/-3 = -0.67778

  6. #6
    Registered User
    Join Date
    11-26-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: Intersection of 2 Perpendicular Lines - Apparent Error in Intersection Coordinates

    That is correct. Brilliant. I have inadvertently inverted the formula.

    I will mark this answer as correct and the question [Solved] and add 1 to your reputation.

    Thank you very much.

  7. #7
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    Re: Intersection of 2 Perpendicular Lines - Apparent Error in Intersection Coordinates

    Glad to help.

+ 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. [SOLVED] Finding Intersection between 2 Trend Lines
    By DJBuck11 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-10-2018, 01:32 PM
  2. Getting point of intersection for two lines
    By adelkam in forum Excel General
    Replies: 1
    Last Post: 07-02-2016, 05:04 PM
  3. Calculating the intersection of 2 lines 2
    By MattRNR in forum Excel General
    Replies: 3
    Last Post: 03-14-2014, 09:34 PM
  4. Calculating the Intersection of 2 lines
    By MattRNR in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-24-2013, 09:03 AM
  5. Replies: 1
    Last Post: 07-16-2013, 06:41 PM
  6. [SOLVED] Intersection of two lines
    By akr in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-26-2006, 08:20 AM
  7. display intersection value for 2 lines
    By gab2409 in forum Excel General
    Replies: 3
    Last Post: 02-28-2005, 12:29 AM

Tags for this Thread

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