seminar modelare

2
Valoare alpha 0.3 Vanzari Eroare t Xt Ft et=Xt-Ft |et| 1 21 21.00 0.0000 0.0000 2 22 21.00 1.0000 1.0000 3 16 21.30 -5.3000 5.3000 4 18 19.71 -1.7100 1.7100 5 19 19.20 -0.1970 0.1970 6 14 19.14 -5.1379 5.1379 7 18 17.60 0.4035 0.4035 8 20 17.72 2.2824 2.2824 9? 18.40 Medie -1.237 2.290 MSE Vanzari Eroare t Xt Ft et=Xt-Ft |et| 1 21 21.00 0.0000 0.0000 2 22 21.00 1.0000 1.0000 3 16 21.30 -5.3000 5.3000 4 18 19.71 -1.7100 1.7100 5 19 19.20 -0.1970 0.1970 6 14 19.14 -5.1379 5.1379 7 18 17.60 0.4035 0.4035 8 20 17.72 2.2824 2.2824 9 18.40 Valori alpha 0.30 0.90 0.36 Valoare vanzari medii 18.5 Luna calendaristi ca Valori ajustate sau previzionate Eroare absoluta Luna calendaristi ca Valori ajustate sau previzionate Eroare absoluta

Upload: cristina-moraru

Post on 03-Oct-2015

221 views

Category:

Documents


3 download

DESCRIPTION

Seminar Modelare

TRANSCRIPT

Sheet1Valoare alpha0.3Luna calendaristicaVanzariValori ajustate sau previzionateEroareEroare absolutaEroare patraticaEroare procentuala absolutatXtFtet=Xt-Ft|et||et|2|et|xt12121.000.00000.00000.00000.000022221.001.00001.00001.00000.045531621.30-5.30005.300028.09000.331341819.71-1.71001.71002.92410.095051919.20-0.19700.19700.03880.010461419.14-5.13795.137926.39800.367071817.600.40350.40350.16280.022482017.722.28242.28245.20950.11419?18.40Medie-1.23700014292.2909.11814.08%MSE9.118Luna calendaristicaVanzariValori ajustate sau previzionateEroareEroare absolutaEroare patraticaEroare procentuala absolutatXtFtet=Xt-Ft|et||et|2|et|xt2112121.000.00000.00000.00000.000021.322221.001.00001.00001.00000.045519.7131621.30-5.30005.300028.09000.331319.19741819.71-1.71001.71002.92410.095019.137951919.20-0.19700.19700.03880.010417.5965361419.14-5.13795.137926.39800.367017.71757171817.600.40350.40350.16280.022418.402299782017.722.28242.28245.20950.1141918.40Valori alpha0.300.900.36Valoare vanzari medii18.5

Sheet2

Sheet3