Syntax
=FORECAST(x, known_ys, known_xs)Arguments
| Argument | Required | Description |
|---|---|---|
x | Required | The x value to predict for |
known_ys | Required | The dependent values |
known_xs | Required | The independent values |
How to use FORECAST
FORECAST is kept so older workbooks keep working. It calculates the same way as FORECAST.LINEAR, which is the name to use in new formulas.
FORECAST takes 3 required arguments. Type =FORECAST( 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(30, {6,7,9,15,21}, {20,28,31,38,40})Result Related statistical functions
- F.INV.RTReturns the inverse of the right tailed F distribution.
- F.TESTReturns the two tailed probability of an F test that two samples have the same variance.
- FISHERReturns the Fisher transformation of a value between -1 and 1.
- FISHERINVReturns the inverse of the Fisher transformation.
- FORECAST.ETSPredicts a future value with additive exponential triple smoothing (level, trend and season).
- FORECAST.ETS.CONFINTReturns the half width of the confidence interval around a FORECAST.ETS prediction.
- 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.