How to find intersection coordinates in word2010

Foreword: First of all, we will often encounter the problem of finding the coordinates of the intersection point of the data in data processing, for general straight lines and curves can be fitted.

using Excel, you can approximate or even accurately find the intersection of two curves.

The steps of the method are as follows:

1. Tool requirements.

1）word

2. In the first step, we first use the line chart of Excel.

or a scatter plot with smoothed lines.

1) Then we select "Linear" in [Trend Line Options], "Show Formula" and "Show Square of R" in [Trend**].

2) Below, you can see from the [Trend Line Options] that there are different fits, so you can try different fitting methods to get the best fit.

3. In the second step, we fit both curves at this time, and we can get two functions, and the intersection point of the two functions is (3, 5), so according to this point, two sets of auxiliary data are set up. A set of abscissa is 3, and a set of ordinates is 5, as follows.

1) Finally, right-click on the chart, insert the data, insert the data just now, set the thick of the auxiliary line to points, set the color to black, set the dash type to the dashed line, and delete the label, the final effect is as follows.

The coordinates of the intersection point are to connect the analytic expressions of two functions, and the coordinates of the intersection point are obtained by solving the system of equations.

The intersection coordinates are the coordinate positions of the intersection points of two functions. The position of a point can be described in terms of a set of numbers (ordered arrays). For example, on a plane, two intersecting lines L1 and L2 can be made; Passing through any point m on the plane, make two straight lines parallel to L1 and L2 respectively and intersect with L2 and L1 at P2 and P1; In this way, the point m can be represented by the directed distance p2m, p1m from the direction parallel to l1 and l2 to l2 and l1.

These two directed distances are called the coordinates of the point m, and the two straight lines are called the coordinate axes.

The intersection of the coordinate axes is called the origin, and when two lines are perpendicular to each other, it is a planar Cartesian coordinate system.

In space, there can be three intersecting planes, and any point m in space can be represented by the directed distance from one of the two intersecting planes to the other plane along the line that passes through this point and is parallel to one of the two intersecting planes. These three directed distances are the coordinates of one point m in space, the three planes are called coordinate planes, and the intersection of any two coordinate planes is the coordinate axis. The intersection of the three axes is the origin.

You can first substitute x equal to 0 into the equation and then get the coordinates with the y axis, and then substitute y equal to 0 to get the coordinates with the x axis, and then you can find the coordinates of the intersection point.

1）y=x-4

2) y=-x+2

2y=-2y=-1

The intersection point of x=3 is (Suihui 3,-1) key mountain.

In the (0,0) family, (3,-1).

It is possible to find the length of the hypotenuse of the right triangle with 2 right-angled sides of 1 and 3.

Derive 2 squares of 10.

y²=x

y=x-2, then (x-2) = x

x²-4x＋4=x

x²-5 x＋4=0

x-1）（x-4）=0

then x = 1 or 4

When x=1, y=-1

When x=4, y=2