How do I extract data from graph (i.e. interpolaton)
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? |
How do I extract data from graph (i.e. interpolaton)
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 -- Gary's Student "TauBrewer" wrote: 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? |
All times are GMT +1. The time now is 09:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com