Compare FORECAST.ETS vs FORECAST.ETS.CONFINT
2 vsCompare FORECAST.ETS vs FORECAST.ETS.CONFINT side-by-side — differences, popularity and recommendation
Presets:
VLOOKUP vs XLOOKUP
SUM vs SUMIFS
INDEX vs MATCH vs XLOOKUP
IF vs IFS vs SWITCH
COUNT vs COUNTA vs COUNTIF
AVERAGE vs AVERAGEIF vs AVERAGEIFS
MAX vs LARGE vs MIN
TEXT vs TEXTJOIN vs CONCAT
FILTER vs SORT vs UNIQUE
ROUND vs ROUNDUP vs ROUNDDOWN
All functions
Pick at least 2 functions
Feature
Category
Statistical statistical
Statistical statistical
Popularity
35 / 100
10 / 100
Views
◉ 55 views
◉ 57 views
Output
Number
Number
Version
Excel 2016
Excel 2016
Volatile
No
No
Dynamic Array
No
No
Description
Calculates or predicts a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm. The predicted value is a continuation of the historical values in the specified target date, which should be a continuation of the timeline. You can use this function to predict future sales, inventory requirements, or consumer trends. This function requires the timeline to be organized with a constant step between the different points.
Returns a confidence interval for the forecast value at the specified target date.
Syntax
=FORECAST.ETS(target_date, values, timeline, [seasonality], [data_completion], [aggregation])=FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation])Arguments
6 Arguments
target_date
values
timeline
seasonality (Optional)
data (Optional)
aggregation (Optional)
7 Arguments
target_date
values
timeline
confidence_level (Optional)
seasonality (Optional)
data (Optional)
aggregation (Optional)
Examples
2
2
Tips
1
1
★ Recommendation — Winner: =FORECAST.ETS()
=FORECAST.ETS() is recommended based on higher popularity, newer version and Dynamic Array support.