在Excel中插入数据点 [英] Interpolating data points in Excel
问题描述
我确信这是其他许多次以前解决的问题。
I'm sure this is the kind of problem other have solved many times before.
一群人要做测量（家庭能源使用是精确）。
所有这些都将在不同的时间和不同的时间间隔内进行。
A group of people are going to do measurements (Home energy usage to be exact). All of them will do that at different times and in different intervals.
所以我从每个人得到的是一组{date，value }对，在集合中缺少日期。
So what I'll get from each person is a set of {date, value} pairs where there are dates missing in the set.
我需要的是一组{date，value}对，对于每个日期，范围的值为已知（测量或计算）。
我希望一个简单的线性内插就足够了这个项目。
What I need is a complete set of {date, value} pairs where for each date withing the range a value is known (either measured or calculated). I expect that a simple linear interpolation would suffice for this project.
如果我认为它必须在Excel中完成。
在这样的数据集中插入最好的方式是什么（所以我每天都有一个值）？
If I assume that it must be done in Excel. What is the best way to interpolate in such a dataset (so I have a value for every day) ?
谢谢。
注意：当这些数据集完成后，我将确定斜率（即每天使用量），然后我们可以开始做家庭对比比较。
NOTE: When these datasets are complete I'll determine the slope (i.e. usage per day) and from that we can start doing home-to-home comparisons.
其他信息在第一个建议之后：
我不想手动找出我的测量集中的孔（太多的不完整的测量集!!）。
我正在寻找一些（现有的）自动为我做的事情。
所以如果我的输入是
ADDITIONAL INFO After first few suggestions: I do not want to manually figure out where the holes are in my measurement set (too many incomplete measurement sets!!). I'm looking for something (existing) automatic to do that for me. So if my input is
{2009-06-01, 10}
{2009-06-03, 20}
{2009-06-06, 110}
然后我期望自动获得
{2009-06-01, 10}
{2009-06-02, 15}
{2009-06-03, 20}
{2009-06-04, 50}
{2009-06-05, 80}
{2009-06-06, 110}
是的，我可以编写这样做的软件。我只是希望有人已经有了这个（相当通用的）问题的准备运行软件（Excel）功能。
Yes, I can write software that does this. I am just hoping that someone already has a "ready to run" software (Excel) feature for this (rather generic) problem.
推荐答案
p>最简单的方法可能如下：
The easiest way to do it probably is as follows:
-
下载Excel加载项： XlXtrFun™Microsoft Excel的额外功能
使用函数intepolate（）。
=插值（$ A $ 1：$ A $ 3，$ B $ 1：$ B $ 3，D1，FALSE，FALSE）
Use function intepolate(). =Interpolate($A$1:$A$3,$B$1:$B$3,D1,FALSE,FALSE)
列A和B应包含您的输入，列G应包含所有日期值。公式进入列E。
Columns A and B should contain your input, and column G should contain all your date values. Formula goes into the column E.
这篇关于在Excel中插入数据点的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
