![]() |
getting a y-value from a graph knowing the corresponding x-value
if you have a graph with three points plotted [(x1,y1),(x2,y2),(x3,y3)], can excel find y4 if you know the corresponding x4? -- lsu-i-like ------------------------------------------------------------------------ lsu-i-like's Profile: http://www.excelforum.com/member.php...o&userid=14317 View this thread: http://www.excelforum.com/showthread...hreadid=392733 |
You could use FORECAST() or TREND() to predict the y-value assuming that
the points can be approximated by a straight line. You could use FORECAST() to predict the y-value assuming that the points can be approximated by a quadratic. Jerry lsu-i-like wrote: if you have a graph with three points plotted [(x1,y1),(x2,y2),(x3,y3)], can excel find y4 if you know the corresponding x4? |
All times are GMT +1. The time now is 12:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com