LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
MrShorty
 
Posts: n/a
Default Intersection point in graphs


General answer:

If we have two functions y1=f(x) and y2=g(x), we find the point(s) of
intersection by setting y1=y2 [f(x)=g(x)]and solving for x.

Specific case:

directly proportional function y1=f(x)=ax
indirectly proportional funciton y2=g(x)=b/x
set them equal ax=b/x - x^2=b/a - x=+/- sqrt(b/a)

I leave it to you to decide if you want the positive root or the
negative root, or if I have correctly/incorrectly interpreted the form
of your functions.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=480125

 
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
Excel plugin to make graphs look better CM Excel Discussion (Misc queries) 0 October 17th 05 11:16 PM
Excel changing number formatting and source data in graphs on it's own!!! JohnHamer Excel Discussion (Misc queries) 2 September 22nd 05 02:29 PM
Help! My graphs sneezed! triscuit Charts and Charting in Excel 1 August 18th 05 03:29 PM
Error bars for a single data point not whole series Helen Charts and Charting in Excel 1 April 13th 05 06:21 PM
decimal point override does not work Sam Brauen Excel Discussion (Misc queries) 0 January 6th 05 05:29 PM


All times are GMT +1. The time now is 11:25 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"