0 will indicate the algorithm to account for missing points as zeros. Although the timeline requires a constant step between data points, supports up to 30% missing data, and will automatically adjust for it.
If the ranges of the timeline and values aren't of same size, will return the #N/A error.ĭata completion Optional. If timeline contains duplicate values, will return the #VALUE! error. If a constant step can't be identified in the provided timeline, will return the #NUM! error. The timeline isn't required to be sorted, as will sort it implicitly for calculations. The dates in the timeline must have a consistent step between them and can’t be zero. The independent array or range of numeric data. Values are the historical values, for which you want to forecast the next points. The function syntax has the following arguments: While it can also be used independently of FORECAST.ETS, the functions are tied since the seasonality detected in this function is identical to the one used by FORECAST.ETS, considering the same input parameters that affect data completion. can be used following FORECAST.ETS to identify which automatic seasonality was detected and used in FORECAST.ETS. Returns the length of the repetitive pattern Excel detects for the specified time series. Important: The function is not available in Excel for the Web, iOS, or Android.
