Learn How to Use Microsoft Excel FORECAST.ETS.STAT Function

Microsoft Excel FORECAST.ETS.STAT Function

The main purpose of the Microsoft Excel FORECAST.ETS.STAT function is to get the statistical value related to forecasting. That implies, with the help of FORECAST.ETS.STAT function you can able to return a particular statistical value related to time series forecasting with the FORECAST.ETS function. The statistic-type argument determines which statistic is returned by FORECAST.ETS.STAT function. So, with the help of FORECAST.ETS.STAT function, you can able to get the statistical value related to forecasting.

Return Value of FORECAST.ETS.STAT Function

The return value will be statistical related to forecasting.

Syntax of FORECAST.ETS.STAT Function

=FORECAST.ETS.STAT(values, timeline, statistic-type, [seasonality] [data-completion], [aggregation])

Where the arguments:

• values: This is the existing or historical values (y values).
• timeline: This is the numeric timeline values (x values).
• statistic-type: This is the statistic to return, a numeric value between 1 and 8
• 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).
• aggregation: This is the Aggregation behavior. Default is 1 AVERAGE (optional).

How to Use Microsoft Excel FORECAST.ETS.STAT Function?

So we know that, Microsoft Excel FORECAST.ETS.STAT function you can able to get the statistical value related to forecasting. That implies, with the help of FORECAST.ETS.STAT function you can able to return a particular statistical value related to time series forecasting with the FORECAST.ETS function. The statistic-type argument determines which statistic is returned by FORECAST.ETS.STAT function. So, with the help of FORECAST.ETS.STAT function, you can able to get the statistical value related to forecasting.

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