Syntax
=FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation])Arguments
| Argument | Required | Description |
|---|---|---|
target_date | Required | The date or number to forecast for |
values | Required | The historical values |
timeline | Required | The dates or numbers of the values, evenly spaced |
confidence_level | Optional | The confidence level, between 0 and 1 (0.95 when left out) |
seasonality | Optional | 1 or left out to detect the season length, 0 for none, or the season length |
data_completion | Optional | 1 or left out to fill missing points by interpolation, 0 to use zeros |
aggregation | Optional | How to combine values with the same date: 1 average (default) to 7 sum |
How to use FORECAST.ETS.CONFINT
FORECAST.ETS.CONFINT takes 3 required arguments and 4 optional arguments. Type =FORECAST.ETS.CONFINT( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=FORECAST.ETS.CONFINT(10, {1,2,3,4,5,6,7,8}, {1,2,3,4,5,6,7,8})Result Related statistical functions
- FISHERReturns the Fisher transformation of a value between -1 and 1.
- FISHERINVReturns the inverse of the Fisher transformation.
- FORECASTPredicts a value for x from the straight line that best fits known x and y values.
- FORECAST.ETSPredicts a future value with additive exponential triple smoothing (level, trend and season).
- FORECAST.ETS.SEASONALITYReturns the length of the repeating pattern detected in a time series (1 when there is none).
- FORECAST.ETS.STATReturns a statistic of the exponential smoothing model: 1 alpha, 2 beta, 3 gamma, 4 MASE, 5 SMAPE, 6 MAE, 7 RMSE, 8 step size.
- FORECAST.LINEARPredicts a value for x from the straight line that best fits known x and y values.
- FREQUENCYCounts how many values fall into each bin and returns a vertical list with one more entry than there are bins.
- GAMMAReturns the gamma function value.