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

description

Seminar Modelare

Transcript of Seminar Modelare

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