Forecast Excel Formula Example. The forecast linear function below predicts a future value along a linear trend. When you use a formula to create a forecast it returns a table with the historical and predicted data and a chart.
Forecast ets has three required arguments and three optional arguments. The tutorial explains how to use excel forecast and other related functions with formula examples. When we drag the forecast linear function down the absolute references b 2 b 11 and a 2 a 11 stay the same while the relative reference a12 changes to a13 and a14.
Forecast linear x known y s known x s parameters.
Forecast linear x known y s known x s parameters. X required argument this is a numeric x value for which we want to forecast a new y value. The forecast formula in excel to use is. Forecast c43 c23 c42 d23 d42 we get the results as follow.
