Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mp
 
Posts: n/a
Default how do i interpolate data

I have some data with gaps in it, and need to fill them accurately using
interpolation. How do I do that?

  #2   Report Post  
Bill Martin -- (Remove NOSPAM from address)
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 05:17 AM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Charting data ranges that change mikelee101 Charts and Charting in Excel 2 December 16th 04 11:07 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM


All times are GMT +1. The time now is 04:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"