This video demonstrates how to predict values with exponential triple smoothing using the FORECAST.ETS function in Microsoft Excel 2016. The “Forecast Sheet” feature is also reviewed.
Dr Todd, Thanks for explaining in a Nice and Simple way. How much confidence you have in Excel Ets function compare to manually done? Have you compared the results and bench marked?
Hi. Could you tell how to manually replicate both forecast.ets() and also forecast.ets.confint() ? I'd like to undertand the inner calculations of Excel for those functions.