New Functions in 2016

Excel 2016 introduced 5 new worksheet functions.

FORECAST.ETSReturns a future value based on historical values.
FORECAST.ETS.CONFINTReturns a confidence interval for a future value.
FORECAST.ETS.SEASONALITYReturns the length of the repetitive seasonality pattern.
FORECAST.ETS.STATReturns a statistical value for a future value.
FORECAST.LINEARReturns the future y-value based on existing values.
FORECAST.ETS
Returns a future value based on historical values.
FORECAST.ETS.CONFINT
Returns a confidence interval for a future value.
FORECAST.ETS.SEASONALITY
Returns the length of the repetitive seasonality pattern.
FORECAST.ETS.STAT
Returns a statistical value for a future value.
FORECAST.LINEAR
Returns the future y-value based on existing values.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext