Exceljet

Quick, clean, and to the point

Excel 2016

The functions below were introduced in Excel 2016, and are available in later versions, including Excel 365.

Excel FORECAST.ETS function

The Excel FORECAST.ETS function predicts a value based on existing values that follow a seasonal trend. FORECAST.ETS can be used to predict numeric values like sales, inventory, expenses, etc. with a seasonal pattern.

Excel FORECAST.ETS.CONFINT function

The Excel FORECAST.ETS.CONFINT function returns a confidence interval for a forecast value at a specific point on a timeline. It is designed to be used along with the FORECAST.ETS function...

Excel FORECAST.ETS.SEASONALITY function

The Excel FORECAST.ETS.SEASONALITY function returns the length in time of a seasonal pattern based on existing values and a timeline.

Excel FORECAST.ETS.STAT function

The Excel FORECAST.ETS.STAT function returns a particular statistical value relating related to time series forecasting with the FORECAST.ETS function. The statistic_type...

Excel FORECAST.LINEAR function

The Excel FORECAST function predicts a value based on existing values along a linear trend. FORECAST calculates future value predictions using linear regression, and can be used to predict numeric values like sales, inventory, expenses,...