LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 947
Default intersection point

I added both lines into a chart and added a trendline to both graphs to
get
the following equations
y=80x-20


For the data set
x y
0 60
25 140

Hi. Just some feedback. When given data pairs like above, the linear
equation should have a y-intercept of 60 by inspection.
(The slope (80/25 or 3.2)

I believe what you did was use a "Line" graph in which the x-points are
numbered 1,2...etc
This would give an equation of 80*x-20

A Scatter Chart would have placed the x-points in the correct location, and
given an equation of:

3.2 x + 60

Again, just some thoughts.

If line-segment interception is being used, then I show the two lines as:
60.+ 3.2 x
95 + x

Hence:
x: 15.909090909090908
y: 110.9090909090909
--
HTH
Dana DeLouis



"Joel" wrote in message
...
Using both lines as linear the answer is x = 1.35, y = 88.7

I added both lines into a chart and added a trendline to both graphs to
get
the following equations

y=80x-20
y=15x + 68.33. this line it was difficult to dtermine if I shoud use a
linear approximation or some other approximation.

then I solved manually for x and y

80x-20 = 15x + 68.33
65x = 88.33
x = 1.3589

y= 80x - 20
y = 80 * (1.3589) - 20
y = 1.35

"pmss" wrote:

Hello

Some one can help me to find the intersection point between two lines.
One
line is irregular and another is straight. For example I have given here
two
lines here . I have to find out the intersection point between these two
lines. Thank YOu

First Line
x y
0 80
5 105
15 110
25 120
35 160
50 150
Second Line
x y
0 60
25 140

Pmss


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Indicate intersection point on a two-line graph Greg[_2_] Charts and Charting in Excel 3 April 23rd 23 09:07 AM
How do i locate the point of intersection of two lines graphs Nana Adwoa Charts and Charting in Excel 4 April 2nd 23 07:58 PM
Intersection point return data tvtime Excel Worksheet Functions 20 July 27th 06 07:20 PM
Intersection point in graphs rk0909 Excel Discussion (Misc queries) 4 October 28th 05 09:44 PM
Find intersection point using lables? mpjohnston Excel Programming 2 August 25th 04 01:22 PM


All times are GMT +1. The time now is 01:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"