FORECAST.ETS.STAT

Excel Functions

Get statistical value related to forecasting

Syntax

EXCEL

=FORECAST.ETS.STAT(values, timeline, statistic_type, [seasonality], [data_completion], [aggregation])

Arguments

Parameter	Description
`values`	Existing or historical values (y values).
`timeline`	Numeric timeline values (x values).
`statistic_type`	The statistic to return, a numeric value between 1 and 8 (see table below).
`seasonality`	[optional] Seasonality calculation (0 = no seasonality, 1 = automatic, n = season length in timeline units).
`data_completion`	[optional] Missing data treatment (0 = treat as zero, 1 = average). Default is 1.
`aggregation`	[optional] Aggregation behavior. Default is 1 (AVERAGE). See other options below.

Return Value

Requested statistic

Details

The FORECAST.ETS.STAT function returns a given statistical value related to time series forecasting. The statistic_type argument determines which statistic is returned by FORECAST.ETS.STAT. The FORECAST.ETS.STAT function is (optionally) used to output forecast statistics as part of the "Forecast sheet" feature in Excel. These are statistics relevant to the forecast created by the feature, which relies on the FORECAST.ETS function. In the example shown above, the FORECAST.ETS.STAT function has been inserted manually to output all eight available forecast statistics based on the historical data and timeline shown. The statistic_type values come from column F*.* The statistical value to return is determined by the statistic_type argument. The table below shows the eight possible values and co

FORECAST.ETS.STAT

Syntax

Arguments

Return Value

Details

See Also