FORECAST.LINEAR函数通过使用现有值来计算或预测未来值。预测值是给定x值的y值。已知值是现有的x值和y值,并且通过使用线性回归来预测新值。
FORECAST.LINEAR(x, known_y's, known_x's)
Argument | 描述 | Required/Optional |
---|---|---|
X | The data point for which you want to predict a value. | Required |
Known_y's | The dependent array or range of data. | Required |
Known_x's | The independent array or range of data. | Required |
Excel 2016中添加了FORECAST.LINEAR函数,并替换了早期Excel版本的FORECAST函数。
来源:LearnFk无涯教程网
Excel 2016
祝学习愉快!(内容编辑有误?请选中要编辑内容 -> 右键 -> 修改 -> 提交!)