Spline interpolation in Excel

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.

2

Best Answer

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

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

This is a free add-in for Excel that adds spline and linear interpolation workbook functions:

http://www.srs1software.com/SRS1CubicSplineForExcel.aspx

Random Posts

How to declare variable and use it in the same Oracle SQL script?How to open / edit an exe in visual studio 2019changing top padding in javascriptWhat exactly does normalization in CSS do?Why is `null + 1 = 1` but `undefined + 1 = NaN`?Stretch and scale CSS backgroundPosition of a string within a string using Linux shell script?ssis more than 4000 charsWhere IN a Comma delimited string [duplicate]Emulating density of 320 dpi on android emulatorMessage "Support for password authentication was removed."What is the difference between bare metal, RTOS and SoC? [closed]concatMap() behavior in a pipe()What’s the best way to reload / refresh an iframe?random number between 1000 & 2000 for time of dayF12 Jump to method -> go back to previous method after making the jump?How to kill a running process using ansible?How to use 'seq' function in R to get odd and even numbers? [duplicate]Swapping first and last items in a listHow do you call a function in a react-table accessor? (reactjs)