I have two plots making use of scatter plot of which one is non straight and also the various other one is direct. And I call for the intersection of these curves. How need to I continue ?

Edit: The plots are done by using a collection of values in excel.

You are watching: How to find intersection of two curves in excel

Curve 1:

x: 0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8

y:8.43,8.76,8.27,7.87,7.69,7.76,8.46,8.85,8.34,7.92,7.73,7.79,8.42,8.76,8.27,7.87,7.69

Curve 2: y=8.168

Thanks

Edit-2: In the other question Get collaborates of intersecting suggest of 2 trend lines a trfinish line is made and also then the interarea of those are dealt, which is clearly not possible for mine and also not a duplicate for the question you are referring to.


microsoft-excel microsoft-excel-2007
Share
Improve this question
Follow
edited Sep 11 "17 at 9:37
Yoyo
asked Sep 1 "17 at 5:39
*

YoyoYoyo
1311 gold badge11 silver badge88 bronze badges
6
| Show 1 more comment

1 Answer 1


Active Oldest Votes
0
EDIT: The following approach is applicable only to graphs wright here straight interpolation is proper and where the linear curve is a continuous horizontal line.

Assuming your information is in columns A,B and C as presented below, the x-coordinate of the intersections have the right to be uncovered making use of the formula below. This formula filled down from D3 provides the outcomes in the table listed below.

=IF(OR(AND($B2>=$C3,$B3=$C3)),$A2+($A3-$A2)*($B2-$C3)/($B2-$B3),"")

*

If you would certainly clearly explain your requirements, you can gain an acceptable solution.

Here"s the graph through a linear fit to the initially curve (red line) and also the second (constant) curve (purple line).

*

You can approach this in couple of ways:

You have the right to settle the equation of the linear fit for x as soon as y = 8.168. That provides the allude wright here the 2 straight lines cross (4.040,8.168).

See more: Don'T Take It Personal ( Just One Of Those Days That A Girl Goes Through

You deserve to discover the points wbelow the blue curve equals 8.168. Thesimplest method to do this is by direct interpolation, which assumesthat the line segments in between points deserve to be approximated by adirectly line. For the initially interarea (between points 3 and also 4)8.168 is this fraction of the means between the two points:

(8.27-8.168)/(8.27-7.87) = 0.255

And the x-coordinate is the exact same fraction of the method in between 1 and also 1.5, giving (1.128, 8.168).

The 3rd crossing is coincidentally near the intersection through the direct fit, so let"s view what it is, too: