Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Spline interpolation in Excel

Tags:

excel-2007

I'll make this clear and simple, since I'm on a deadline here. Doing some reports for my section, and I came to a part where I could really use an interpolation in Excel.

Now, I've never had any practice with its functions, or VBA in general. So, is there a place where I could, or do anyone of you guys know some, ... where I could pick up a simple spline interpolation along with a tutorial of "how to make it work" (literally, I have no idea - I use Excel on a one-handful-of-times-on-an-annual-basis)?

I just need something that will put up a spline (or something similar) on an x and y column of values, and give me the interpolated result given values of X.

p.s. I know however of trendlines, but they're no use for me in this case. I cannot get the coefficients "programmatically" ...

I'd really appreciate some pragmatical help.

like image 672
Rook Avatar asked Feb 26 '23 22:02

Rook


1 Answers

http://www.ozgrid.com/Excel/excel-interpolate-cubic-curve-fit.htm

XlXtrFun.xll is what I use to get splines in Excel.

like image 86
masher Avatar answered Mar 30 '23 19:03

masher