![]() It'sn't necessary to sort the timeline ( Arg2), because Forecast_ETS_STAT sorts it implicitly for calculations. See Remarks.Īggregation: Although the timeline requires a constant step between data points, Forecast_ETS_STAT aggregates multiple points that have the same time stamp. See Remarks.ĭata completions: Although the timeline requires a constant step between data points, Forecast_ETS_STAT supports up to 30% missing data, and automatically adjusts for it. Statistic_type: A numeric value between 1 and 8, indicating which statistic will be returned for the calculated forecast.Ĭonfidence level: A numerical value between 0 and 1 (exclusive), indicating a confidence level for the calculated confidence interval. The values in the timeline must have a consistent step between them and can't be zero. Timeline: the independent array or range of dates or numeric data. Values: the historical values, for which you want to forecast the next points. ![]() Forecast_ETS_STAT ( Arg1, Arg2, Arg3, Arg4, Arg5, Arg6)Įxpression A variable that represents a WorksheetFunction object. Returns a statistical value as a result of time series forecasting.
0 Comments
Leave a Reply. |