Buzz
Apart from FORECAST.ETS.SEASONALITY in Excel for determining the repetition length, readers can explore other Excel functions like SWITCH and CONCATENATE on Mytour.
FORECAST.ETS.SEASONALITY Function
1. Description of FORECAST.ETS.SEASONALITY Function in Excel: Calculating the Length of Repetition Pattern
The Forecast.Ets.Seasonality function in Excel is utilized to determine the length of the repetition pattern within the timeline.
The syntax of the FORECAST.ETS.SEASONALITY function in Excel is as follows:
FORECAST.ETS.SEASONALITY( values, timeline, [data completion], [aggregation] )
In which:
- Values: An array of known historical values that you want to forecast the next time point.
- Timeline: An array of independent dates/times corresponding to each value.
This parameter must meet the following requirements:
+ The timeline array must have the same length as the values array.
+ Dates/times in the timeline must have consistent step lengths, although:
- Up to 30% of the points may be missing and processed, based on the value of the [data completion] parameter.
- Duplicates may exist in the timeline, and corresponding values will be aggregated, as defined by the [aggregation] parameter.
+ Dates/times in the timeline can use any format.
- [data completion]: Optional. This parameter specifies how the algorithm handles missing points in the timeline.
If provided, the [data completion] parameter can be either 0 or 1, meaning:
- [aggregation]: Optional. This parameter specifies how the algorithm aggregates values with the same time stamp.
If provided, this parameter can be any integer from 1 to 7, meaning:
Note:
- The pattern calculated by the Forecast.Ets.Seasonality function is the same pattern automatically calculated by the Forecast.Ets function.
- If the Forecast.Ets.Seasonality function requires a reasonable amount of data to determine the seasonality pattern. A higher number of values results in higher accuracy of the result.
2. Example of Excel Forecast.Ets.Seasonality Function
The spreadsheet below shows monthly income from January 2015 to April 2017. These values are illustrated on the chart below:
The Forecast.Ets.Seasonality function in Excel can be used to forecast the length of seasonality pattern in income from January 2015 to April 2017 as shown below:
= FORECAST.ETS.SEASONALITY( B2:B29, A2:A29 )
The function returns a result of 11.
Note in the example above:
- The function returns a seasonality value of 11 for the provided data. The seasonality value should be more accurate with more data values provided to the function.
- The [data completion] and [aggregation] parameters in the function are omitted, so the function uses default values of [data completion] = 1 and [aggregation] = 0.
To explore more detailed information about the Excel Forecast.Ets.Seasonality function, readers can visit the Microsoft Office official website.
3. Common Errors with FORECAST.ETS.SEASONALITY Function in Excel: Calculating the Length of Repeating Pattern
If the Forecast.Ets.Seasonality function in Excel returns an error message, it could be one of the following errors:
- Error #N/A: This error occurs if the provided values and timeline arrays have different lengths.
- Error #NUM!: This error occurs if:
+ The consistent step size in the date/time of the provided timeline is not determined.
+ The [data completion] value provided is not equal to 0 or 1.
+ The [aggregation] value provided is not within the valid range of 1 - 7.
- Error #VALUE!: This error occurs if one or more of the [data completion] or [aggregation] parameters is not of numeric type.
Above are the details and examples of the FORECAST.ETS.SEASONALITY function in Excel, calculating the length of the repeating pattern. Additionally, readers can refer to some previous articles to understand more about the FORECAST.ETS.STAT function, FORECAST.ETS function, and FORECAST.ETS.CONFINT function, as well as the ConcateNate function in Excel.
