A numerical value between 0 and 1 (exclusive), indicating a confidence level for the calculated confidence interval. If the ranges of the timeline and values aren't of same size, will return the #N/A error.Ĭonfidence_level 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. If the target date is chronologically before the end of the historical timeline, returns the #NUM! error. The data point for which you want to predict a value. The function syntax has the following arguments: Syntaxį(target_date, values, timeline,, ,, ) A smaller interval would imply more confidence in the prediction for this specific point. Using confidence interval can help grasp the accuracy of the predicted model. A confidence interval of 95% means that 95% of future points are expected to fall within this radius from the result FORECAST.ETS forecasted (with normal distribution). Returns a confidence interval for the forecast value at the specified target date. 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 |