Note: Starting with Excel 2016, the FORECAST function was replaced with theFORECAST.LINEAR function.
Microsoft recommends replacing FORECAST with FORECAST.LINEAR, since FORECAST will eventually be deprecated.
With these inputs, the FORECAST function returns 1505.36 in cell D13.
The chart to the right shows this data plotted in ascatter plot.
FORECAST.ETS can be used to predict numeric values like sales, inventory, expenses, etc.
with a seasonal pattern.
It is designed to be used along with theFORECAST.ETS functionas a way to show forecast accuracy.
Thestatistic_typeargument determines which statistic is returned by FORECAST.ETS.STAT…
