Procedure to find Intersection
An intersection is a point where 2 curves have the same coordinates. The equation of a straight line can be written asy = mx + c, where m is the slope and c is the intercept of a line. For example, you are given two lines line1:y = m1x + c1 and line2:y1 = m2x + c2 wherem1, c1 are the slope and intersection of line1 andm2, c2 are the slope and intersection of line2. Considering the intersection point to be (a, b).
Following are the steps
Step 1: As, (a, b) is the intersection point of the two lines, which means that (a, b) satisfies the equation of both linesb = m1a + c1 i.e. andb = m2a + c2.
Step 2: Equating the values of b, to find the value of a,m1a+ c1 = m2 + c2. .
Step3: After rearranging the equation, the value of a comes out to be,.
Step 4: Now, substitute the value of a in any of the equations to find the value of b,b = m1 + c1.
Intersection of Two Linear Straight Lines in Excel
Intersection points can be beneficial in finding insights into the data, As intersections give the same values for different data sets. Excel can help to automate the task of finding the intersection point of two lines by using the =slope() and =intersection() function and replacing their values with the given equations. In this article, we will learn how to find the intersection point of two straight lines in excel.
Contact Us