Learn How to Use Microsoft Excel FORECAST.ETS Function

Microsoft Excel FORECAST.ETS Function

The main purpose of the Microsoft Excel FORECAST.ETS function is to predict the value with a seasonal trend. That implies, with the help of FORECAST.ETS function you can able to predict a value based on already given values that follows the seasonal trend. The FORECAST.ETS function calculates future value predictions using a seasonal pattern and can be used to predict numeric values like sales, expenses, inventory, measurements, etc. So, with the help of FORECAST.ETS function, you can able to predict the value with a seasonal trend.

Return Value of FORECAST.ETS Function

The return value will be the predicted value.

Syntax of FORECAST.ETS Function

=FORECAST.ETS(target-date, values, timeline, [seasonality], [data-completion], [aggregation])

Where the arguments:

• target-date: This is the time or period for the prediction (x value).
• values: This is the existing or historical values (y values).
• timeline: This is the numeric timeline values (x values).
• seasonality: This is the Seasonality calculation, where 0 = no seasonality, 1 = automatic, n = season length in timeline units (optional).
• data-completion: This is the Missing data treatment, where, 0 = treat as zero, 1 = average and default is 1 (optional).
• aggregations: This is the Aggregation behavior. Default is 1 AVERAGE (optional).

How to Use Microsoft Excel FORECAST.ETS Function?

So we know that, Microsoft Excel FORECAST.ETS function you can able to predict the value with a seasonal trend. That implies, with the help of FORECAST.ETS function you can able to predict a value based on already given values that follows the seasonal trend. The FORECAST.ETS function calculates future value predictions using the seasonal patterns and can be used to predict numeric values like sales, expenses, inventory, measurements, etc. So, with the help of FORECAST.ETS function, you can able to predict the value with a seasonal trend.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel