Parameter Definitions


After observing month t, we will have used all data observed through the end of month t to estimate the following quantities of interest:

  • Lt=Level of series

  • Tt=Trend of series

  • St=Seasonal index for current month

The key to Winter’s method is the following three equations, which are used to update Lt, Tt, and St. In the following formulas, alp, bet, and gam are called smoothing parameters. The values of these parameters will be chosen to optimize our forecasts. In the following formulas, c equals the number of periods in a seasonal cycle (c=12 months for example) and xt equals the observed value of the time series at time t.

  • Formula 1: Lt=alp(xt/st–c)+(1–alp)(Lt–1*Tt–1)

  • Formula 2: Tt=bet(Lt/Lt–1)+(1–bet)Tt–1

  • Formula 3: St=gam(xt/Lt)+(1–gam)st–-c

Formula 1 indicates that our new base estimate is a weighted average of the current observation (deseasonalized) and last period’s base updated by our last trend estimate. Formula 2 indicates that our new trend estimate is a weighted average of the ratio of our current base to last period’s base (this is a current estimate of trend) and last period’s trend. Formula 3 indicates that we update our seasonal index estimate as a weighted average of the estimate of the seasonal index based on the current period and the previous estimate. Note that larger values of the smoothing parameters correspond to putting more weight on the current observation.

We define Ft,k as our forecast (F) after period t for the period t+k. This results in the formula Ft,k=Lt*(Tt)kst+k–c.

This formula first uses the current trend estimate to update the base k periods forward. Then the resulting base estimate for period t+k is adjusted by the appropriate seasonal index.




Microsoft Press - Microsoft Office Excel 2007. Data Analysis and Business Modeling
MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)
ISBN: 0735623961
EAN: 2147483647
Year: 2007
Pages: 200

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net