The Excel Forecast.Ets.Stat function calculates a specified statistical value, relating to a time series forecasting.
The syntax of the function is:
where the function arguments are:
values    The array of historical known values corresponding to an array of dates/times.  
timeline    The independent array of dates/times, corresponding to each of the values. This must satisfy the following:
 
statistic_type    A numeric value, indicating which statistical value is to be returned. This must be an integer between 1 and 8, meaning:
 
[seasonality]    An optional argument indicating the algorithm that should be used to detect seasonality in the data. If supplied, this must be a positive integer between 0 and 8784, meaning:
 
[data completion]    An optional argument specifying how the algorithm should handle missing points in the timeline. If supplied, the [data completion] argument can have the value 0 or 1 meaning:
 
[aggregation]    An optional argument specifying how the algorithm should aggregate values that have the same timestamp. If supplied, this can be any integer between 1 and 7 meaning:

Note: The Forecast.Ets.Stat function was first introduced in Excel 2016, so is not available in earlier versions of Excel. It is also not available in Excel 2016 for Mac.
A  B  

1  Month  Earnings 
2  Jan2015  879 
3  Feb2015  1259 
4  Mar2015  1230 
5  Apr2015  1471 
6  May2015  1638 
7  Jun2015  1371 
8  Jul2015  1562 
9  Aug2015  1526 
10  Sep2015  1125 
11  Oct2015  1340 
12  Nov2015  830 
13  Dec2015  726 
14  Jan2016  917 
15  Feb2016  1028 
16  Mar2016  1449 
17  Apr2016  1225 
18  May2016  1437 
19  Jun2016  1637 
20  Jul2016  1345 
21  Aug2016  1148 
22  Sep2016  1075 
23  Oct2016  928 
24  Nov2016  852 
25  Dec2016  752 
26  Jan2017  989 
27  Feb2017  1304 
28  Mar2017  1192 
29  Apr2017  1265 
The above spreadsheet on the right shows a set of monthly earnings between Jan2015 and Apr2017. These values are plotted in the chart below:
The Forecast.Ets function has previously calculated the forecast earnings for May 2017 to be 1461.632054.
The Excel Forecast.Ets.Stat function can be used to return statistical information relating to this forecast. For example, in order to return the Alpha parameter of the ETS algorithm:
which gives the result 0.126.
If you want to return the step size detected by the ETS algorithm:
which returns the value 31.
For further details of the Excel Forecast.Ets.Stat function, see the Microsoft Office website
If you get an error from the Forecast.Ets.Stat function, this is likely to be one of the following:
#N/A    Occurs if the supplied values and timeline arrays have different lengths. 
#NUM!    Occurs if either:

#VALUE!    Occurs if one or more of the supplied statistic_type, [seasonality], [data completion] or [aggregation] arguments is nonnumeric. 