如果known_y 和 known_x 为空或包含不同数量的数据点, 则Forecast 返回#N/A 错误值。如果known_x的方差等于零, 则Forecast 返回#DIV/0! 。FORECAST 的公式为 a+bx,其中 定义 其中x 和 y 为样本表示 AVERAGE (known_x 的) 和 AVERAGE (known_y 的) 。
Note:In Excel 2016, the FORECAST function was replaced with FORECAST.LINEAR as part of the newForecasting functions. The syntax and usage of the two functions are the same, but the older FORECAST function will eventually be deprecated. It's still available for backward compatib...
如果x 為非數值, Forecast 會傳回#VALUE! 錯誤值。如果known_y 的和 known_x 是空的,或包含不同數目的資料點, Forecast 會傳回#N/A 錯誤值。如果known_x的變異數等於零, Forecast 會傳回 #DIV/0! 錯誤值。FORECAST 的方程式是 a+bx,其中 以及 。其中 x 和 y 是範例表示 AVERAGE (known_x的) 和...
This article describes the formula syntax and usage of the FORECAST.LINEAR and FORECAST functions in Microsoft Excel. Note: In Excel 2016, the FORECAST function was replaced with FORECAST.LINEAR as part of the new Forecasting functions. The syntax and usage of the two functions are the same, ...
Important:TheFORECAST.ETSfunction is not available in Excel for the web, iOS, or Android. Calculates or predicts a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm. The predicted value is a continuation of the historical va...
Important: The function FORECAST.ETS.CONFINT is not available in Excel for the Web, iOS, or Android. Returns a confidence interval for the forecast value at the specified target date. A confidence interval of 95% means that 95% of future points are expected to fall within this radius fro...
You can use this function to predict future sales, inventory requirements, or consumer trends. C# 複製 public double Forecast (double Arg1, object Arg2, object Arg3); Parameters Arg1 Double X - the data point for which you want to predict a value. Arg2 Object Known_y's - the ...
打开包含可预测数值数据的 Excel 表。 单击“分析”选项卡上的“预测”。 指定要预测的列。 该工具会自动选择数据中具有可预测数据类型(即连续数值数据)的列。 如果某些具有连续数值数据的列包含许多 null 值或零值,由于缺少数据可能影响结果,该工具可能不会选择这些列。 如果发生这种情况,可以使用Re...
表达式。Forecast_ETS_STAT(Arg1、Arg2、Arg3、Arg4、Arg5、Arg6) 表达一个代表WorksheetFunction对象的变量。 参数 名称必需/可选数据类型说明 Arg1必需Variant值:要预测其下一点的历史值。 Arg2必需Variant时间线:日期或数值数据的独立数组或范围。 时间线中的值之间必须具有一致的步长,并且不能为零。 请参阅注解...
/ "ECMA.CEILING" / "ISO.CEILING" / "NETWORKDAYS.INTL" / "WORKDAY.INTL" / "FORECAST.ETS" / "FORECAST.ETS.CONFINT" / "FORECAST.ETS.SEASONALITY" / "FORECAST.LINEAR" / "FORECAST.ETS.STAT" ref-function-call = "CHOOSE" choose-params / "IF" if-params / "IF" if-worksheet-params / "...