FORECAST.ETS.STAT
Returns a statistical value as a result of time series forecasting
Syntax
FORECAST.ETS.STAT(values, timeline, statistic_type, [seasonality], [data_completion], [aggregation])
Parameters
- values: Required. The historical values
- timeline: Required. The independent array or range
- statistic_type: Required. A number 1-8 indicating the requested statistic
- seasonality: Optional. The length of the seasonal pattern
- data_completion: Optional. How to handle missing points
- aggregation: Optional. The aggregation method
Example
=FORECAST.ETS.STAT(B2:B14, A2:A14, 1)