Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Interpolation
You can use FORECAST() for linear interpolation, or TREND() for
quadratic interpolation. Jerry Jan wrote: This is a portion of a data series A B 45 20.760 55 20.785 64 20.817 How can I take this series and get the intermediate values in another data set 45,46,47,48 etc |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Interpolation
If you pass the appropriate arrays to the functions, you can use them
from VBA. To call a worksheet function from all versions of VBA, prefix the function name with "Application.", as in coefs = Application.LinEst(ydata, xdata) An alternate syntax that works with Excel 97 or later uses "WorksheetFunction." or "Application.WorksheetFunction." in place of the earliar "Application.". This newer syntax may be marginally faster, but the main advantage is that it will pull up a list of those worksheet functions that can be called from VBA. Jerry Jan wrote: Thanks! Can this be done programatically. I have 10 sets if data with 8-10 subsets in each Thanks again Jan "Jerry W. Lewis" wrote: You can use FORECAST() for linear interpolation, or TREND() for quadratic interpolation. Jerry Jan wrote: This is a portion of a data series A B 45 20.760 55 20.785 64 20.817 How can I take this series and get the intermediate values in another data set 45,46,47,48 etc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interpolation within a data table | Excel Worksheet Functions | |||
interpolation | Excel Worksheet Functions | |||
3D Interpolation | Excel Worksheet Functions | |||
help with interpolation and limit of interpolation | Excel Discussion (Misc queries) | |||
interpolation XY data with bezier curver | Charts and Charting in Excel |