Results 1 to 3 of 3

Interpolate

Threaded View

  1. #1
    Registered User
    Join Date
    11-10-2010
    Location
    Oklahoma
    MS-Off Ver
    Excel 2007
    Posts
    11

    Interpolate

    I need to figure out a way to linearly interpolate a set of values.

    I have several sets of data where the independant variables are different and the array size is different. I need to convert all of these data sets into a standard type. For example

    I have this data set in columns 1 & 2:
    -17.3..... -.4
    -15 ........ -.3
    -11.6 ..... -.39
    -10 ....... -.82
    -9 ........ -.76
    -8.3 ..... -.71
    -7.2 ..... -.65
    -6 ...... -.57
    ..
    and I need it to be of the form:

    -14 .... X
    -13 .... X
    -12 .... X
    -11 .... X
    -10 .. -.82 (some of the values match up, so they need no interpolation)
    -9 .... -.76
    -8 ...... X

    I need to fill in the X's. I guess I need to store the value -14 then search for the gap that it fits in the top table, then do some math gymnastics then spit out the interpolated value. then do the same for -13, -12... and so on. I think I'm trying to make this too difficult because I'm struggling with the implementation of it.
    Last edited by ryan darrow; 02-17-2011 at 11:44 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1