AUTOETS

AUTOETS Forecasting in Google Sheets.

Sample Usage

AUTOETS(A1:A100, 14, 0.95, false)

Syntax

=AUTOETS(data_y, horizon, level, 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.

  • 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.

Examples