Excel中的样条插值 [英] Spline interpolation in Excel

问题描述

由于我将在截止日期前完成，因此我将使其变得简单明了.在为我的部分做一些报告时，我来到了一个可以真正在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.

现在，我从未对其功能或VBA进行过任何练习.因此，在某个地方，我可以，或者你们中的每个人都知道吗，...在这里，我可以选择简单的样条插值以及如何使其工作"教程(字面上，我不知道-我在每年一次的基础上使用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)?

我只需要一些可以在值的x和y列上放置样条曲线(或类似的东西)，并在给定X值的情况下为我提供内插结果.

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.但是我知道趋势线，但是在这种情况下它们对我没有用.我无法以编程方式"获得系数...

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.

推荐答案

这是Excel的免费加载项，它添加了样条和线性插值工作簿功能:

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

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

这篇关于Excel中的样条插值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！