copia de planilla de excel de suavizacion exponencial

1
Suavización Exponencial MAE MAPE MSE w 0.4 11.3034 1.20% 216.9313 t Forecast |Error| %Error 1 925 925 2 940 925 3 924 931 7 0.76% 49 4 925 928.2 3.2 0.35% 10.24 5 912 926.92 14.92 1.64% 222.6064 6 908 920.952 12.952 1.43% 167.7543 7 910 915.7712 5.7712 0.63% 33.306749 8 912 913.46272 1.46272 0.16% 2.1395498 9 915 912.877632 2.12237 0.23% 4.5044459 10 924 913.7265792 10.2734 1.11% 105.54317 11 943 917.83594752 25.1641 2.67% 633.22954 12 962 927.901568512 34.0984 3.54% 1162.703 13 960 941.5409411072 18.4591 1.92% 340.73686 14 958 948.9245646643 9.07544 0.95% 82.363527 15 955 952.5547387986 2.44526 0.26% 5.9793023 16 953.5328432792 Zt Error 2 0 2 4 6 8 10 12 Actual t Z A B C D E F G H I J K L M N O P Q 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

Upload: celeste

Post on 24-Dec-2015

227 views

Category:

Documents


3 download

DESCRIPTION

plantilla de suavizacion

TRANSCRIPT

Page 1: Copia de Planilla de Excel de Suavizacion Exponencial

Suavización Exponencial

MAE MAPE MSE

w 0.4 11.3034 1.20% 216.9313

t Forecast |Error| %Error1 925 9252 940 9253 924 931 7 0.76% 494 925 928.2 3.2 0.35% 10.245 912 926.92 14.92 1.64% 222.60646 908 920.952 12.952 1.43% 167.75437 910 915.7712 5.7712 0.63% 33.3067498 912 913.46272 1.46272 0.16% 2.13954989 915 912.877632 2.12237 0.23% 4.504445910 924 913.7265792 10.2734 1.11% 105.5431711 943 917.83594752 25.1641 2.67% 633.2295412 962 927.901568512 34.0984 3.54% 1162.70313 960 941.5409411072 18.4591 1.92% 340.7368614 958 948.9245646643 9.07544 0.95% 82.36352715 955 952.5547387986 2.44526 0.26% 5.979302316 953.5328432792

Zt Error2

0

2

4

6

8

10

12ActualForecast

t

Z

A B C D E F G H I J K L M N O P Q

3

45678910111213141516171819202122232425262728293031323334353637