Sample Usage
=MSTL(A1:A100, 10, 0.95, "ets", false)
Syntax
MSTL(data_y, horizon, level, trend="ets", insample_forecast=false)
data_y - The range representing the array or matrix of dependent data.
horizon - The forecasting horizon.
level - The prediction interval level. A number between 0.5 and 1.0.
trend - The trend forecasting method (ets or naive).
insample_forecast - If true, the insample forecast is returned in addition to the forecast.
Notes
- Any text in the encountered in the
value will throw an error.