Excel FORECAST.ETS Function

What is FORECAST.ETS function in Excel?


The FORECAST.ETS function is one of the Statistical functions of Excel.

It returns the forecasted value for a specific future target date using the exponential smoothing method.

We can find this function in Statistical of insert function Tab.

How to use FORECAST.ETS function in excel

  1. Click on an empty cell (like F5).
 an empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

function list in excel

4. Select STATISTICAL category.

5. Select FORECAST.ETS function.

6. Then select ok.

excel FORECAST.ETS function

7. In the function arguments Tab you will see FORECAST.ETS function.

8. Target date is the data point for which Microsoft Excel predicts a value. It should carry on the pattern of values in the timeline.

9. Values are the array or range of numeric data you’re predicting.

10. Timeline is the independent array or range of numeric data. The dates in the timeline must have a consistent step between them and can’t be zero.

11. Seasonality is an optional numeric value that indicates the length of the seasonal pattern. The default value of 1 indicates seasonality is detected automatically.

12. Data_completion is an optional value for handling missing values. The default value of 1 replaces missing values by interpolation, and 0 replaces them with zeros.

13. You will see the results in the formula result section.

Examples of FORECAST.ETS function in Excel

FORECAST.ETS related functions 

Leave a Reply

Your email address will not be published. Required fields are marked *