getting a y-value from a graph knowing the corresponding x-value

L

lsu-i-like

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?
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top