Excel

FORECAST.ETS: Excel Formulae Explained

How do you use FORECAST.ETS in Excel?

FORECAST.ETS is a function in Excel that allows you to predict future values based on existing data. You can use it to forecast values for a single variable, or to predict pairs of values for two variables. The function takes four arguments: the data set you're using for your predictions, the number of periods you want to forecast, the interval you want to use for your predictions, and the method you want to use for your predictions. The data set can be a range of cells, a named range, or a table. The number of periods can be a number, a cell reference, or a range of cells. The interval can be a number, a cell reference, or a range of cells. The method can be one of six options: linear, exponential, polynomial, power, logarithmic, or moving average.

What is the syntax of FORECAST.ETS in Excel?

The syntax of FORECAST.ETS in Excel is as follows:

FORECAST.ETS(x, y, h)

x is the independent variable

y is the dependent variable

h is the number of periods for which the forecast is desired

What is an example of how to use FORECAST.ETS in Excel?

The FORECAST.ETS function in Excel is used to predict future values in a data set. The function takes four arguments: the first is the data set you want to predict values for, the second is the lower bound of the prediction interval, the third is the upper bound of the prediction interval, and the fourth is the "Type" argument, which can be set to "Linear" or "Logarithmic". The function will then return the predicted value for the data set within the given prediction interval. An example of how to use the FORECAST.ETS function in Excel can be seen below. In this example, we are using the FORECAST.ETS function to predict the value of the stock market on January 1st, 2020. We are using the lower bound of the prediction interval as -200 and the upper bound of the prediction interval as 200. The "Type" argument is set to "Linear".

=FORECAST.ETS(A2:A11,-200,200,1)

This function will return the predicted value for the stock market on January 1st, 2020. In our example, the function returns the value of 9500.

When should you not use FORECAST.ETS in Excel?

There are a few instances in which you should not use FORECAST.ETS in Excel. One instance is when you have a time series that is not stationary. A time series is stationary if its statistical properties (mean, variance, etc.) do not change over time. Another instance is when you have a time series that is cyclical. A time series is cyclical if its statistical properties (mean, variance, etc.) change over time in a predictable manner. FORECAST.ETS is not designed to handle time series that are non-stationary or cyclical.

What are some similar formulae to FORECAST.ETS in Excel?

The Microsoft Excel FORECAST.ETS function is used to forecast future values of a specified data series. The function uses the Exponential Smoothing algorithm to calculate the forecast values. Other similar functions that can be used to forecast future values include the FORECAST.LINEAR and FORECAST.LOGISTIC functions. The FORECAST.LINEAR function uses a linear regression to calculate the forecast values, while the FORECAST.LOGISTIC function uses a logistic regression to calculate the forecast values.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.