Valor Inicial Media Stdev : Dias Clientes Error T ZT Z'T RT - RT - Estimado Abs Error

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 7

Valor Inicial 90

Media= 172.96
StDev= 84.11 RM= RAM=
23.8 37.7

RMCR=

dias clientes estimado error abs error


t Zt Z't rt |rt|
Semana 1.00 90.00 90.00 - -
2.00 55.00 55.00 - -
3.00 74.00 74.00 - -
1.00 4.00 85.00 85.00 - -
5.00 98.00 98.00 - -
6.00 169.00 169.00 - -
7.00 215.00 215.00 - -
1.00 149.00 90.00 59.00 59.00
2.00 80.00 55.00 25.00 25.00
3.00 121.00 74.00 47.00 47.00
2.00 4.00 106.00 85.00 21.00 21.00
5.00 160.00 98.00 62.00 62.00
6.00 226.00 169.00 57.00 57.00
7.00 197.00 215.00 - 18.00 18.00
1.00 120.00 119.50 0.50 0.50
2.00 60.00 67.50 - 7.50 7.50
3.00 116.00 97.50 18.50 18.50
3.00 4.00 132.00 95.50 36.50 36.50
5.00 149.00 129.00 20.00 20.00
6.00 213.00 197.50 15.50 15.50
7.00 280.00 206.00 74.00 74.00
1.00 138.00 119.67 18.33 18.33
2.00 134.00 65.00 69.00 69.00
3.00 107.00 103.67 3.33 3.33
4.00 4.00 183.00 107.67 75.33 75.33
5.00 214.00 135.67 78.33 78.33
6.00 333.00 202.67 130.33 130.33
7.00 365.00 230.67 134.33 134.33
1.00 138.00 124.25 13.75 13.75
2.00 115.00 82.25 32.75 32.75
3.00 137.00 104.50 32.50 32.50
5.00 4.00 161.00 126.50 34.50 34.50
5.00
5.00 154.00 155.25 - 1.25 1.25
6.00 208.00 235.25 - 27.25 27.25
7.00 213.00 264.25 - 51.25 51.25
1.00 104.00 127.00 - 23.00 23.00
2.00 84.00 88.80 - 4.80 4.80
3.00 120.00 111.00 9.00 9.00
6.00 4.00 132.00 133.40 - 1.40 1.40
5.00 117.00 155.00 - 38.00 38.00
6.00 201.00 229.80 - 28.80 28.80
7.00 249.00 254.00 - 5.00 5.00
1.00 89.00 123.17 - 34.17 34.17
2.00 49.00 88.00 - 39.00 39.00
3.00 84.00 112.50 - 28.50 28.50
7.00 4.00 124.00 133.17 - 9.17 9.17
5.00 249.00 148.67 100.33 100.33
6.00 322.00 225.00 97.00 97.00
7.00 329.00 253.17 75.83 75.83
1.00 96.00 118.29 - 22.29 22.29
2.00 102.00 82.43 19.57 19.57
3.00 112.00 108.43 3.57 3.57
8.00 4.00 163.00 131.86 31.14 31.14
5.00 199.00 163.00 36.00 36.00
6.00 346.00 238.86 107.14 107.14
7.00 401.00 264.00 137.00 137.00
1.00 116.00 115.50 0.50 0.50
2.00 98.00 84.88 13.13 13.13
3.00 131.00 108.88 22.13 22.13
9.00 4.00 212.00 135.75 76.25 76.25
5.00 230.00 167.50 62.50 62.50
6.00 337.00 252.25 84.75 84.75
7.00 297.00 281.13 15.88 15.88
1.00 101.00 115.56 - 14.56 14.56
2.00 134.00 86.33 47.67 47.67
3.00 131.00 111.33 19.67 19.67
10.00 4.00 206.00 144.22 61.78 61.78
5.00 237.00 174.44 62.56 62.56
6.00 235.00 261.67 - 26.67 26.67
7.00 366.00 282.89 83.11 83.11
1.00 78.00 114.10 - 36.10 36.10
2.00 115.00 91.10 23.90 23.90
3.00 107.00 113.30 - 6.30 6.30
11.00 4.00 199.00 150.40 48.60 48.60
5.00 251.00 180.70 70.30 70.30
6.00 253.00 259.00 - 6.00 6.00
7.00 202.00 291.20 - 89.20 89.20
1.00 86.00 110.82 - 24.82 24.82
2.00 126.00 93.27 32.73 32.73

12.00
3.00 126.00 112.73 13.27 13.27
12.00 4.00 162.00 154.82 7.18 7.18
5.00 244.00 187.09 56.91 56.91
6.00 223.00 258.45 - 35.45 35.45
7.00 359.00 283.09 75.91 75.91
108.75
96.00
113.83
155.42
191.83
255.50
289.42
Media Acumulada
MCR= RPM= RPAM=
450.00
2,547.2 8.9% 20.7%
400.00

50.47 350.00

300.00

250.00
error rel
error2 error rel abs 200.00
rt2 rt/Zt |rt|/Zt 150.00
- - -
100.00
- - -
- - - 50.00

- - - -
1.00 2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10
- - -
- - - Column F Column G
- - -
3,481.00 0.40 0.40
625.00 0.31 0.31
2,209.00 0.39 0.39
441.00 0.20 0.20
3,844.00 0.39 0.39
3,249.00 0.25 0.25
324.00 - 0.09 0.09
0.25 0.00 0.00
56.25 - 0.13 0.13
342.25 0.16 0.16
1,332.25 0.28 0.28
400.00 0.13 0.13
240.25 0.07 0.07
5,476.00 0.26 0.26
336.11 0.13 0.13
4,761.00 0.51 0.51
11.11 0.03 0.03
5,675.11 0.41 0.41
6,136.11 0.37 0.37
16,986.78 0.39 0.39
18,045.44 0.37 0.37
189.06 0.10 0.10
1,072.56 0.28 0.28
1,056.25 0.24 0.24
1,190.25 0.21 0.21
1.56 - 0.01 0.01
742.56 - 0.13 0.13
2,626.56 - 0.24 0.24
529.00 - 0.22 0.22
23.04 - 0.06 0.06
81.00 0.08 0.08
1.96 - 0.01 0.01
1,444.00 - 0.32 0.32
829.44 - 0.14 0.14
25.00 - 0.02 0.02
1,167.36 - 0.38 0.38
1,521.00 - 0.80 0.80
812.25 - 0.34 0.34
84.03 - 0.07 0.07
10,066.78 0.40 0.40
9,409.00 0.30 0.30
5,750.69 0.23 0.23
496.65 - 0.23 0.23
383.04 0.19 0.19
12.76 0.03 0.03
969.88 0.19 0.19
1,296.00 0.18 0.18
11,479.59 0.31 0.31
18,769.00 0.34 0.34
0.25 0.00 0.00
172.27 0.13 0.13
489.52 0.17 0.17
5,814.06 0.36 0.36
3,906.25 0.27 0.27
7,182.56 0.25 0.25
252.02 0.05 0.05
211.86 - 0.14 0.14
2,272.11 0.36 0.36
386.78 0.15 0.15
3,816.49 0.30 0.30
3,913.20 0.26 0.26
711.11 - 0.11 0.11
6,907.46 0.23 0.23
1,303.21 - 0.46 0.46
571.21 0.21 0.21
39.69 - 0.06 0.06
2,361.96 0.24 0.24
4,942.09 0.28 0.28
36.00 - 0.02 0.02
7,956.64 - 0.44 0.44
615.94 - 0.29 0.29
1,071.07 0.26 0.26
176.17 0.11 0.11
51.58 0.04 0.04
3,238.64 0.23 0.23
1,257.02 - 0.16 0.16
5,762.19 0.21 0.21
edia Acumulada

6.00 7.00 8.00 9.00 10.00 11.00 12.00

umn F Column G

You might also like