HELP with exponential smoothing, PLEASE!
- To: mathgroup at smc.vnet.net
- Subject: [mg7672] HELP with exponential smoothing, PLEASE!
- From: arosa at mail.telepac.pt (Antonio Rosa)
- Date: Thu, 26 Jun 1997 01:36:56 -0400 (EDT)
- Organization: PORTUGAL TELECOM
- Sender: owner-wri-mathgroup at wolfram.com
Hi !, i'm using an programm called STATISTICA to forecast
telephones demand per month. I've acheived good results using an
linear trend in exponential smoothing, but now i'm trying to develop
an program to make the same calculations.....but i'm getting different
results. Can you help me? here are the results from the program
STATISTICA:
month: JANUARY
S0 (estimated from data) = 341884
T0 (estimated from data) = 102675
alpha=0.55 ; beta=0.1 (constants)
case Real Values Smoothed Series Resids
1 393221 444559 -51337.5
2 562774 614586 2380.3
3 611754 682960 -71206.1
4 803921 736751 67169.7
5 870344 (* forecasted)
I'm using the following formulas:
T0=(Xn-X1)/(N-1) , where N is the length of series
S0=X1-(T0/2)
Formula of trend: T(t)=beta* ( F(t) - F(t-1) ) + (1-beta)*T(t-1) ,
where T is trend and F is forecast
F(t+1)=alpha*( A(t) ) + (1-alpha)*( F(t-1) - T(t-1) ) , where A is
the real value
I think that this last formula is wrong, can anyone tell me the
correct formula(s) so that i can get the same values of STATISTICA ?
Thanks in Advance!
Antonio Rosa
----
Antonio Rosa
Portugal Telecom
Special Systems and Services
Coimbra - Portugal
mail: arosa at mail.telepac.pt