Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have some data with gaps in it, and need to fill them accurately using
interpolation. How do I do that? |
#2
![]() |
|||
|
|||
![]()
mp wrote:
I have some data with gaps in it, and need to fill them accurately using interpolation. How do I do that? You can't fill them "accurately" with interpolation. Interpolation is a guess of what data maybe, might, possibly be what should go there. And depending on the nature of the data there are lots of ways to do interpolation. Linear, polynomial, exponential, etc. If you have an interest rate problem for example and fill it in with linear interpolation you're guaranteed inaccurate data points. You've got to know more about the nature of your problem and what sort of curve fits it best. For simple linear interpolation between two points (X1,Y1) and (X2,Y2) the equation to find a value Y for an unknown X is: Y = Y1 + (X-X1)*(Y2-Y1)/(X2-X1) Good luck... Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |