Site hosted by Angelfire.com: Build your free website today!

New Functions for 2016

Function Basics Insert Function AutoSum IF Function
PMT Function Date Functions DATEDIF Function Lookup Functions
New 07 Functions Time Functions Text Functions Rounding Functions
Stat Functions Other Functions SUBTOTAL (.xls) SUMPRODUCT (.xls)

Only five new functions for Excel 2016 - all Statistical.

FORECAST.ETS
Syntax: FORECAST.ETS(target date, values, timeline, [seasonality], [data_completion], [aggregation])
Calculates a future value based on historical values. This function can be used to predict future sales, consumer trends, etc.
FORECAST.ETS.CONFINT
Syntax: FORECAST.ETS.CONFINT(target date, values, timeline, [confindence_level], [seasonality], [data_completion], [aggregation])
Returns a confidence level for the forecast value at the specified target date.
FORECAST.ETS.SEASONALITY
Syntax: FORECAST.ETS.SEASONALITY(target date, values, timeline, [seasonality], [data_completion])
Returns the length of the repetitive pattern Excel detects for the specified time series.
FORECAST.ETS.STAT
FORECAST.ETS.STAT(target date, values, timeline, [confindence_level], [seasonality], [data_completion], [aggregation])
Returns a statistical value as a result of time series forecasting.
FORECAST.LINEAR
Syntax: FORECAST.LINEAR(x, known_y's, known_x's))
Calculates a future value by using existing values.

Return to the Top