Note: Starting with Excel 2016, theFORECAST functionwas replaced with the FORECAST.LINEAR function.
Microsoft recommends replacing FORECAST with FORECAST.LINEAR, since FORECAST will eventually be deprecated.
With these inputs, the FORECAST.LINEAR function returns 1505.36 in cell D13.
The chart to the right shows this data plotted in ascatter plot.
Mark at Excel Off The Grid has adetailed explanation here.
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…
