Compare FORECAST.ETS.STAT vs FORECAST.ETS
2 vsCompare FORECAST.ETS.STAT vs FORECAST.ETS 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
5 / 100
35 / 100
Views
◉ 30 views
◉ 34 views
Output
Number
Number
Version
Excel 2016
Excel 2016
Volatile
No
No
Dynamic Array
No
No
Description
Returns a statistical value as a result of time series forecasting.
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.
Syntax
=FORECAST.ETS.STAT(values, timeline, statistic_type, [seasonality], [data_completion], [aggregation])=FORECAST.ETS(target_date, values, timeline, [seasonality], [data_completion], [aggregation])Arguments
6 Arguments
values
timeline
statistic_type
seasonality (Optional)
data (Optional)
aggregation (Optional)
6 Arguments
target_date
values
timeline
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.