FORECAST.ETS(target_date, values, timeline [,seasonality] [,data_completion] [,aggregation])

Returns the future value based on historical values.

target_dateThe date you want to predict.
valuesThe historical values.
timelineThe array or range of cells.
seasonality(Optional) A number indicating whether to use seasonality:
1 - automatically detected uses positive whole numbers (default)
0 - no seasonality, therefore linear
data_completion(Optional) A number indicating how to handle missing points:
1 - use the average of the neighbouring points (default)
0 - use zero for any missing points
aggregation(Optional) The type of function to use:
1 = AVERAGE (default)
2 = COUNT
3 = COUNTA
4 = MAX
5 = MIN
6 = MEDIAN
7 = SUM

Remarks

* Added in Excel 2016.
* ETS stands for Exponential Triple Smoothing.
* The Aggregation Function will only be used when several values have the same time stamp.
* If "timeline" and "values" are not the same size, then #N/A is returned.
* If "timeline" contains duplicate values, then #NUM! is returned.
* If "seasonality" is left blank, then 1 is used.
* If "seasonality" > 8760, then #NUM! is returned.
* If "data_completion" is left blank, then 1 is used.
* If "aggregation" is left blank, then AVERAGE is used.
* If "aggregation" > 7, then #NUM! is returned.
* If "aggregation" < 1, then #NUM! is returned. Example 7
* If any of the arguments are not numeric, then #VALUE! is returned.
* The dates in the "timeline" must have a consistent step between them and can't be zero.
* If a constant step cannot be identified in the "timeline", then #NUM! is returned.
* You can use the FORECAST.LINEAR function to
* You can use the FORECAST.ETS.CONFINT function to
* You can use the FORECAST.ETS.SEASONALITY function to
* You can use the FORECAST.ETS.STAT function to
* For an illustrated example refer to the page under Advanced Functions.
* For the Microsoft documentation refer to support.office.com

 ABCD
1=FORECAST.ETS(B7,D1:D6,B1:B6) = 701/1/20194346610
2=FORECAST.ETS(43472,{10,20,30,40},{43466,43467,43468,43469}) = 701/2/20194346720
3=FORECAST.ETS(B7,D1:D6,B1:B6,1,1,1) = 701/3/20194346830
4=FORECAST.ETS(B7,D1:D6,B1:B6,1,1,2) = 11/4/20194346940
5=FORECAST.ETS(B7,D1:D6,B1:B6,1,1,3) = 11/5/20194347050
6=FORECAST.ETS(B7,D1:D6,B1:B6,1,1,4) = 701/6/20194347160
7=FORECAST.ETS(B7,D1:D6,B1:B6,1,1,0) = #NUM!1/7/201943472 


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top