+ Reply to Thread
Results 1 to 5 of 5

Interpolate between data

  1. #1
    Valued Forum Contributor abduljaleel.mca's Avatar
    Join Date
    02-13-2013
    Location
    Chennai, India
    MS-Off Ver
    MS 365 Business
    Posts
    312

    Interpolate between data

    Hi,

    Please have a look at the attached file.

    Please let me know how to interpolate these data when I enter a price value of 80.

    Any formula is also fine.

    Please help.

    Thanks
    Abdul
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Interpolate between data

    explain better please
    If solved remember to mark Thread as solved

  3. #3
    Valued Forum Contributor abduljaleel.mca's Avatar
    Join Date
    02-13-2013
    Location
    Chennai, India
    MS-Off Ver
    MS 365 Business
    Posts
    312

    Re: Interpolate between data

    Hi Patel,

    I know these data points.

    X 16 60 100 150 273
    Y 267.47226 184.48218 160.82095 -55.55879 -557.21659

    I would like to interpolate Y values when giving any values between specified Xvalue. For example what will be the Y value when X=20 OR what will be the Y value when X=127. If I assume correctly we need to use interpolation and that should consider the nearest points and calculate Y value.

    Hope it is clear, please let me know.

    Thanks
    Abdul

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,212

    Re: Interpolate between data

    Linear interpolation is a frequent discussion topic here. One of my first suggestions might be to put it into this site's search engine and study the solutions previously presented.

    One of the easiest solutions in my opinion would be to use a spreadsheet (like my old version of QuattroPro) that has a built in linear interpolation function (@LINTERP).

    The basic algorithm I use for linear interpolation looks something like this (spread over several cells as I am not fond of big, ugly, single cell formulas):

    1) A lookup function to locate the interval containing "new_x" -- usually a MATCH() function
    2) Four instances of the INDEX() functions to return the x and y points for the desired interval.
    3) Then a formula to find new_y at new_x. Maybe the TREND() function or equivalent.

    I have recently seen someone proposing variations of the PERCENTILE() function for linear interpolations. I have not studied these in detail to see exactly how it works.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  5. #5
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

    Re: Interpolate between data

    a
    b
    c
    d
    e
    f
    1
    x
    y
    x
    y
    2
    16
    267.472
    127
    43.976
    e2: =percentile($b$2:$b$6, 1 - percentrank($a$2:$a$6, d2))
    3
    60
    184.482
    4
    100
    160.821
    5
    150
    -55.559
    6
    273
    -557.217
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Interpolate between data - NOT WORKING?
    By Conrad1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-18-2013, 12:05 PM
  2. Interpolate data
    By wenners68 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-14-2012, 05:22 AM
  3. How to interpolate chart data from three parameters.
    By cslaton in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-16-2012, 08:26 AM
  4. [SOLVED] IS THERE A WAY TO INTERPOLATE AUTOMATICALLY WITHIN A DATA TABLE?
    By Eric S. in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-16-2005, 01:05 AM
  5. [SOLVED] how do i interpolate data
    By mp in forum Excel General
    Replies: 1
    Last Post: 02-08-2005, 02:06 PM

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