How do I extract data from graph (i.e. interpolaton)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If we have a table of data values, can we build a graph and extract values
from it not found in the table?
Example pairs 2200, 1,21; 2400, 1.37 are in table from which a (non-linear)
graph is created. Is there any simple way to find the value that goes with
2217, for example?

I know we can use match and index and do linear interpolation, but is there
a simpler or more elegant way to do this?
 
FORECAST() both forecasts and interpolates:
In A1:B2 put:

2200 1.21
2400 1.37

anywhere else put =FORECAST(2217,B1:B2,A1:A2) and you will see: 1.22360
 

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

Back
Top