Forecast Excel Formula Example. The tutorial explains how to use excel forecast and other related functions with formula examples. Forecast ets target date values timeline seasonality data completion aggregation where target date is the date you want to predict a value for values is the array of historical data sales in our case and timeline is the array of a timeframe with an equal interval such as daily the 1 st of the each month the 1 st of each year or even a continuous numerical index.
When you use a formula to create a forecast it returns a table with the historical and predicted data and a chart. Forecast linear x known y s known x s parameters. This known y values is a dependent array or.
The forecast linear function below predicts a future value along a linear trend.
This is a numeric value where we need to forecast new y value known y. Forecast ets has three required arguments and three optional arguments. X the target date for which you would like to predict a value known y s the timeline series range known x s the value series range. If you would like to calculate the forecast for the coming period based on simple moving average method then formula f t n will be the sum of actual occurrence or demands in the past period up to n periods divided by the number of periods to be averaged.
