+ Reply to Thread
Results 1 to 4 of 4

Curve Fitting and interpolation

  1. #1
    Registered User
    Join Date
    10-22-2009
    Location
    cairo egypt
    MS-Off Ver
    Excel 2003
    Posts
    17

    Curve Fitting and interpolation

    Please see the attached two curves which i want to transfer to excel to automate my
    calculations, i made a try in the attached workbook and i need your advice and comments

    for the first curve
    having t,x i got y
    now, is what i have done is true and accurate (using the linear equation) or there a best fit polynomial or other way to do that
    I tried LINEST on the rows A3 to A8 if i complete to A33 will it differ or be more accurate
    if i have t=12 (or any value between 0,30 which have no exact values on the attached curve) and x =14.5 for example how can i interpolate to find y

    with the same x i got y in the curve in the second sheet
    is my polynomial is accurate , is there a better way
    thanks in advance
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by salmanisn; 01-18-2011 at 07:13 AM. Reason: files attach

  2. #2
    Registered User
    Join Date
    10-22-2009
    Location
    cairo egypt
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Curve Fitting and interpolation

    it will be good to have a hint ! better than nothing

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

    Re: Curve Fitting and interpolation

    I tried LINEST on the rows A3 to A8 if i complete to A33 will it differ or be more accurate
    It will be more accurate, but you need to remove the rows that don't have data.
    if i have t=12 (or any value between 0,30 which have no exact values on the attached curve) and x =14.5 for example how can i interpolate to find y
    Use the slope and offset returned from LINEST in cells N29 and O29 respectively.
    is my polynomial is accurate , is there a better way
    It's certainly accurate as to the data; with a third-order polynomial you can fit ANY four points having unique domain (x) values. That doesn't mean it's correct.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    10-22-2009
    Location
    cairo egypt
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Curve Fitting and interpolation

    thank you very much for your reply , please have a look for that

    Use the slope and offset returned from LINEST in cells N29 and O29 respectively.

    but the slope and offset returned from LINEST in cells N29 and O29 is belongs to linear t=0

    when i use them it gives the point shown in the graph, the green triangle located in t=0 where
    i look for a line in between 0,30 say t=15

    thanks in advance
    Attached Files Attached Files
    Last edited by salmanisn; 01-24-2011 at 04:26 AM. Reason: Quote

+ 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