ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   getting a y-value from a graph knowing the corresponding x-value (https://www.excelbanter.com/excel-discussion-misc-queries/38593-getting-y-value-graph-knowing-corresponding-x-value.html)

lsu-i-like

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


Jerry W. Lewis

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