What is the syntax for FORECAST.ETS.STAT in Excel?

The syntax for FORECAST.ETS.STAT is: =FORECAST.ETS.STAT(values, timeline, statistic_type, [seasonality], [data_completion], [aggregation])

How do I use the FORECAST.ETS.STAT function?

To use FORECAST.ETS.STAT, type =FORECAST.ETS.STAT( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

What type of data does FORECAST.ETS.STAT work with?

FORECAST.ETS.STAT works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.

Why is FORECAST.ETS.STAT not working in my Excel?

Common issues with FORECAST.ETS.STAT include Statistic_type must be 1-8. Start by checking the syntax =FORECAST.ETS.STAT(values, timeline, statistic_type, [seasonality], [data_completion], [aggregation]), then verify each referenced cell or range.

Statistical

FORECAST.ETS.STAT Function in Excel

Returns a statistical value as a result of time series forecasting.

Syntax

=FORECAST.ETS.STAT(values, timeline, statistic_type, [seasonality], [data_completion], [aggregation])

Arguments

values (required): Historical values
timeline (required): Historical dates
statistic_type (required): Statistic to return (1-8)
seasonality (optional): Season length
data_completion (optional): Handle missing data
aggregation (optional): Aggregation method

Examples

=FORECAST.ETS.STAT(B2:B25, A2:A25, 1) - Alpha smoothing parameter - Result: 0.5

FORECAST.ETS.STAT for data analysis

Confirm whether you need entire columns, filtered subsets, or distinct values.
Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
Pivot tables complement single-cell statistical formulas for exploration.

Common errors

Statistic_type must be 1-8

Use cases

Model diagnostics
Forecast accuracy
Parameter analysis

Frequently asked questions

What is the FORECAST.ETS.STAT function in Excel? FORECAST.ETS.STAT returns a statistical value as a result of time series forecasting. The syntax is =FORECAST.ETS.STAT(values, timeline, statistic_type, [seasonality], [data_completion], [aggregation]). Typical use cases include model diagnostics, forecast accuracy, parameter analysis.
How do I use the FORECAST.ETS.STAT function? To use FORECAST.ETS.STAT, type =FORECAST.ETS.STAT( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
What type of data does FORECAST.ETS.STAT work with? FORECAST.ETS.STAT works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.
Why is FORECAST.ETS.STAT not working in my Excel? Common issues with FORECAST.ETS.STAT include Statistic_type must be 1-8. Start by checking the syntax =FORECAST.ETS.STAT(values, timeline, statistic_type, [seasonality], [data_completion], [aggregation]), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.