×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

interpolation from a curve in excel

interpolation from a curve in excel

interpolation from a curve in excel

(OP)
dear friends,
I have a curve, but i have not any formula or function,
how can i find a good fitting function and extract new data from this curve.
for example:
from a curve we can find that:
f(a1)=b1
f(a2)=b2
f(a3)=b3,...
then f(x)=?
Thank you,

RE: interpolation from a curve in excel

If the curve has been plotted by excel, then you can fit a "best line" through it (using Excels tools) and just use the equation of the best fit line to find your value of interest.  If the curve is on paper, then you need to first create the curve in excel just like you did in this post.

RE: interpolation from a curve in excel

I found the built in functions lacking for certain purposes.  After research and looking at a few add-ons, I found this one to be great:

http://preview.tinyurl.com/2prpo4

From the website:
"Three Dimensional Interpolate and Extrapolate Functions; Two Dimensional Interpolate, Extrapolate, Cubic Spline, Polynomial Curve Fitting, Line Intersections, Minima, Maxima, First Derivative, Second Derivative, and other functions."

RE: interpolation from a curve in excel

What's the model?  The data must represent something with a physical process that has some model.  You curve fit to the model.

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

RE: interpolation from a curve in excel

do trendline equation?

Not almost anymore!  smile

RE: interpolation from a curve in excel

I've fitted a curve of best fit to data in the past, or if it's difficult, derived my own least squares fit (say for a cosine function or a circle) and then cut and pasted the formula into cells to calculate any point on the curve. You have to edit the pasted term though to make sure it refers to a cell that contains the 'x' value.

corus

RE: interpolation from a curve in excel

Thanks for mentioning my site, zunzun.com. The source code for the middleware - the code that iteratively searches for the 'best' equation - is at

http://sourceforge.net/project/showfiles.php?group_id=187105

If you would like to make your own curve and surface fitting web site, the tutorial for this is at

http://wiki.pylonshq.com/display/pylonscookbook/Pylons+Curve+and+Surface+Fitting+Tutorial

Please let me know if you have any questions or suggestions for the site.

James

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources