![]() Any seasonality above that number will result in the #NUM! error.ĭata completion Optional. Maximum supported seasonality is 8,760 (number of hours in a year). For any other value, will return the #NUM! error. Positive whole numbers will indicate to the algorithm to use patterns of this length as the seasonality. 0 indicates no seasonality, meaning the prediction will be linear. The default value of 1 means Excel detects seasonality automatically for the forecast and uses positive, whole numbers for the length of the seasonal pattern. A numeric value between 1 and 8, indicating which statistic will be returned for the calculated forecast. If the ranges of the timeline and values aren't of same size, will return the #N/A error. 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: ![]() Syntaxį(values, timeline, statistic_type,, , ) ![]() Statistic type indicates which statistic is requested by this function. Returns a statistical value as a result of time series forecasting. Important: The function is not available in Excel for the Web, iOS, or Android.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |