+ Reply to Thread
Results 1 to 2 of 2

Interpolation in EXCEL

  1. #1
    Registered User
    Join Date
    02-27-2008
    Posts
    1

    Interpolation in EXCEL

    I am trying to perform non-linear interpolation in EXCEL. I have known X and Y values and I want to find corresponding Y values for new Xs.
    Any help will be really appreciated.
    e.g.
    Known X Known Y
    1860.00 0.15
    1926.47 2.12
    1927.18 2.31
    1929.10 2.70
    1929.17 3.08


    What will be the Y's for the following Xs
    1920.041667
    1920.125
    1920.208333
    1920.291667

  2. #2
    Forum Contributor
    Join Date
    10-27-2006
    Location
    United Kingdom
    MS-Off Ver
    EXCEL 2003 (2007 at home)
    Posts
    517
    The First thing to do is to plot your data on an XY scatter chart.
    Then try to fit a trend line through the points.

    I've done that and your data is horrid!
    The best fit is probably an exponential line, but that is not very good.

    What error bands do you have on this data?
    Do you have any clues from the process that generated the data as to what the shape of the graph should be?

    Anyway you could try takeing the natural log of your Y values
    (use the function LN)
    then use a linear forecast on the X and LN(Y) data.
    then use EXP to reverse the effect of the logarithm.

    For 1920.125 this gives 1.824

+ Reply to Thread

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