Factores de R

Fecha MXPUSD MXPEUR Cetes28 Libor28

1 31/12/2012 12.97 17.14 4.04% 20.68%
2 02/01/2013 12.75 16.79 4.30% 20.58%
3 03/01/2013 12.74 16.65 4.35% 20.56%
4 04/01/2013 12.76 16.66 4.40% 20.56%
5 07/01/2013 12.77 16.74 4.45% 20.56%
6 08/01/2013 12.80 16.74 4.12% 20.56%
309 25/03/2014 13.13 18.16 3.19% 15.10%
310 26/03/2014 13.13 18.11 3.25% 15.04%
311 27/03/2014 13.08 17.98 3.30% 14.98%
312 28/03/2014 13.08 17.99 3.30% 14.89%
313 31/03/2014 13.05 17.99 3.48% 14.93%
314 01/04/2014 13.03 17.97 3.22% 14.83%
315 02/04/2014 13.10 18.03 3.40% 14.94%
316 03/04/2014 13.13 18.02 3.40% 14.98%
317 04/04/2014 13.03 17.87 3.40% 14.99%
318 07/04/2014 13.02 17.89 3.40% 14.92%
Factores de Riesgo
Pag28 IPC CEMEX AMX BIMBO NAFTRAC
4.55% 43,705.8 4.2 14.9 33.5 43.7
4.55% 44,304.2 4.4 14.9 33.8 44.3
4.55% 44,370.6 4.4 15.5 33.8 44.3
4.55% 44,562.3 4.4 15.5 34.1 44.5
4.55% 44,625.9 4.4 15.5 33.8 44.6
4.55% 44,571.2 4.4 15.5 33.7 44.5
3.52% 39,793.0 5.7 13.0 35.0 39.8
3.53% 39,761.3 5.6 12.7 34.8 39.8
3.53% 39,911.0 5.6 12.6 34.6 39.9
3.53% 40,048.2 5.5 12.5 35.3 40.0
3.53% 40,461.6 5.5 13.0 35.2 40.4
3.53% 40,470.0 5.5 13.1 35.4 40.5
3.53% 40,900.5 5.7 13.2 35.5 40.9
3.52% 40,563.1 5.7 13.1 35.4 40.5
3.52% 40,598.3 5.9 13.5 35.3 40.6
3.52% 40,595.7 5.7 13.4 35.8 40.6
 Rendimientos de los Factores
Fecha MXPUSD MXPEUR Cetes28 Libor28 Pag28
31/12/2012
02/01/2013 -1.6736% -2.0344% 6.4356% -0.4817% 0.0000%
03/01/2013 -0.0455% -0.8045% 1.1628% -0.0748% 0.0000%
04/01/2013 0.1311% 0.0429% 1.1494% -0.0034% 0.0000%
07/01/2013 0.0643% 0.4589% 1.1364% 0.0000% 0.0000%
08/01/2013 0.2632% 0.0146% -7.4157% -0.0024% 0.0000%
25/03/2014 -0.5075% -0.5902% -3.3333% -0.3261% 0.0000%
26/03/2014 -0.0579% -0.3144% 1.8809% -0.3935% 0.2841%
27/03/2014 -0.3321% -0.6754% 1.5385% -0.4010% 0.0000%
28/03/2014 0.0031% 0.0431% 0.0000% -0.5642% 0.0000%
31/03/2014 -0.2232% 0.0163% 5.4545% 0.2216% 0.0000%
01/04/2014 -0.1808% -0.1047% -7.4713% -0.6264% 0.0000%
02/04/2014 0.5203% 0.2834% 5.5901% 0.7133% 0.0000%
03/04/2014 0.2542% -0.0554% 0.0000% 0.2925% -0.2833%
04/04/2014 -0.7455% -0.8359% 0.0000% 0.0554% 0.0000%
07/04/2014 -0.1274% 0.1350% 0.0000% -0.4490% 0.0000%
de los Factores de Riesgo
IPC CEMEX AMX BIMBO NAFTRAC

1.3690% 4.4882% 0.0000% 1.0158% 1.3733%

0.1500% -0.8289% 4.0268% -0.1183% 0.1129%
0.4320% 0.4559% -0.3226% 1.0068% 0.4060%
0.1427% 0.7564% 0.0000% -0.8209% 0.2022%
-0.1226% -0.0751% 0.3883% -0.4434% -0.1569%
-0.0720% 0.9451% -1.8839% -0.2850% -0.1255%
-0.0797% -1.5214% -2.6882% -0.6859% -0.0754%
0.3765% -0.4159% -0.2975% -0.4029% 0.3522%
0.3437% -1.6110% -0.8099% 2.0803% 0.3760%
1.0323% 0.0606% 3.7510% -0.2547% 0.9990%
0.0208% 0.3636% 0.7692% 0.3689% 0.0247%
1.0638% 3.2005% 0.7634% 0.2545% 1.1125%
-0.8251% -0.2341% -0.7576% -0.1128% -0.9291%
0.0870% 3.4018% 3.0534% -0.2259% 0.1728%
-0.0065% -2.3256% -0.7407% 1.3865% -0.0493%
 Datos
Fecha IPC
Ordenados
31/12/2012 43,705.8 37,517.2 1 Tamaño de la muestra
02/01/2013 44,304.2 37,517.4 1 Número ce Intervalos
03/01/2013 44,370.6 37,901.8 1 Límite Inferior
04/01/2013 44,562.3 37,951.0 1 Límite Superior
07/01/2013 44,625.9 38,036.5 2 Tamaño del Intervalo
08/01/2013 44,571.2 38,037.5 2

09/01/2013 44,862.5 38,534.8 3 Distribuc

10/01/2013 44,859.8 38,605.6 3 Intervalo de Clas

Número de Límite
11/01/2013 44,888.1 38,634.8 3 Intervalo Inferior

14/01/2013 44,862.9 38,671.0

15/01/2013 44,748.1 38,689.6 3
16/01/2013 44,865.3 38,782.9 3 1 37,517.23
17/01/2013 44,943.3 38,805.3 3 2 38,011.07
18/01/2013 45,212.5 38,811.9 3 3 38,504.91
21/01/2013 45,223.9 38,814.7 3 4 38,998.75
22/01/2013 45,320.3 38,912.9 3 5 39,492.59
23/01/2013 45,443.0 38,913.0 3 6 39,986.43
24/01/2013 45,428.7 39,021.1 3 7 40,480.27
25/01/2013 45,575.9 39,023.7 4 8 40,974.11
28/01/2013 45,912.5 39,045.0 4 9 41,467.95
29/01/2013 45,908.0 39,084.4 4 10 41,961.79
30/01/2013 45,753.2 39,162.5 4 11 42,455.63
31/01/2013 45,278.1 39,176.3 4 12 42,949.47
01/02/2013 45,768.5 39,248.1 4 13 43,443.31
05/02/2013 45,688.1 39,269.3 4 14 43,937.15
06/02/2013 45,570.7 39,460.0 4 15 44,430.99
07/02/2013 45,019.2 39,480.4 4 16 44,924.83
08/02/2013 45,089.4 39,481.5 4 17 45,418.67
11/02/2013 45,063.9 39,492.4 4

12/02/2013 44,873.4 39,541.5 4

13/02/2013 44,096.3 39,549.5 5
14/02/2013 43,878.3 39,594.6 5 Promedio
15/02/2013 44,153.0 39,616.2 5
18/02/2013 44,141.9 39,650.8 5
19/02/2013 44,639.8 39,654.2 5
20/02/2013 44,299.6 39,656.0 5
21/02/2013 44,136.6 39,659.5 5
22/02/2013 43,875.7 39,686.5 5
25/02/2013 43,497.2 39,686.8 5
26/02/2013 43,489.2 39,724.6 5
27/02/2013 43,772.9 39,761.3 5
28/02/2013 44,121.0 39,765.9 5
01/03/2013 43,995.7 39,773.5 5
04/03/2013 43,871.3 39,792.7 5
05/03/2013 44,017.1 39,793.0 5
06/03/2013 44,159.7 39,821.7 5
07/03/2013 43,968.6 39,864.2 5
08/03/2013 44,322.5 39,866.2 5
11/03/2013 44,013.3 39,880.9 5
12/03/2013 43,965.4 39,890.2 5
13/03/2013 43,278.1 39,891.7 5
14/03/2013 43,348.5 39,911.0 5
15/03/2013 42,605.1 39,915.1 5
19/03/2013 42,060.6 39,916.8 5
20/03/2013 42,498.0 39,999.0 5
21/03/2013 42,531.1 40,006.4 6
22/03/2013 42,686.7 40,009.9 6
25/03/2013 42,900.8 40,021.7 6
26/03/2013 43,664.7 40,048.2 6
27/03/2013 44,077.1 40,071.6 6
01/04/2013 43,932.5 40,085.5 6
02/04/2013 44,113.5 40,116.4 6
03/04/2013 43,717.6 40,117.7 6
04/04/2013 43,566.7 40,119.0 6
05/04/2013 43,244.1 40,129.0 6
08/04/2013 43,431.0 40,144.7 6
09/04/2013 43,973.2 40,185.2 6
10/04/2013 44,380.8 40,199.5 6
11/04/2013 44,408.4 40,218.3 6
12/04/2013 44,004.3 40,221.0 6
15/04/2013 42,984.4 40,226.3 6
16/04/2013 43,223.7 40,232.7 6
17/04/2013 42,610.7 40,236.6 6
18/04/2013 42,460.2 40,240.2 6
19/04/2013 42,808.2 40,245.3 6
22/04/2013 42,914.2 40,246.7 6
23/04/2013 43,113.6 40,280.1 6
24/04/2013 42,294.9 40,288.8 6
25/04/2013 42,547.5 40,304.5 6
26/04/2013 41,898.2 40,306.7 6
29/04/2013 41,910.5 40,309.0 6
30/04/2013 42,263.5 40,322.3 6
02/05/2013 42,090.0 40,329.8 6
03/05/2013 42,602.1 40,341.9 6
06/05/2013 42,198.0 40,345.8 6
07/05/2013 42,406.7 40,355.3 6
08/05/2013 42,102.1 40,412.7 6
09/05/2013 41,682.6 40,419.9 6
10/05/2013 41,741.5 40,421.9 6
13/05/2013 41,766.9 40,451.2 6
14/05/2013 41,925.1 40,461.6 6
15/05/2013 41,905.2 40,470.0 6
16/05/2013 41,761.1 40,479.8 6
17/05/2013 41,806.7 40,490.0 6
20/05/2013 41,080.4 40,505.3 7
21/05/2013 40,548.4 40,521.3 7
22/05/2013 40,119.0 40,525.7 7
23/05/2013 40,505.3 40,548.4 7
24/05/2013 40,521.3 40,552.6 7
27/05/2013 40,144.7 40,563.1 7
28/05/2013 40,764.0 40,579.1 7
29/05/2013 40,639.0 40,595.7 7
30/05/2013 40,984.5 40,598.3 7
31/05/2013 41,588.3 40,623.1 7
03/06/2013 41,094.8 40,623.3 7
04/06/2013 40,750.4 40,639.0 7
05/06/2013 40,226.3 40,643.3 7
06/06/2013 40,579.1 40,660.9 7
07/06/2013 40,232.7 40,671.6 7
10/06/2013 40,721.4 40,689.9 7
11/06/2013 39,890.2 40,690.1 7
12/06/2013 39,480.4 40,710.9 7
13/06/2013 39,481.5 40,721.4 7
14/06/2013 39,269.3 40,735.5 7
17/06/2013 39,549.5 40,750.4 7
18/06/2013 39,460.0 40,752.1 7
19/06/2013 39,045.0 40,759.6 7
20/06/2013 37,517.2 40,764.0 7
21/06/2013 38,036.5 40,785.7 7
24/06/2013 37,517.4 40,790.2 7
25/06/2013 37,901.8 40,795.6 7
26/06/2013 38,805.3 40,813.5 7
27/06/2013 39,650.8 40,828.9 7
28/06/2013 40,623.3 40,832.5 7
01/07/2013 41,176.8 40,837.9 7
02/07/2013 40,832.5 40,839.0 7
03/07/2013 40,828.9 40,841.1 7
04/07/2013 41,200.4 40,863.4 7
05/07/2013 40,623.1 40,879.8 7
08/07/2013 40,071.6 40,882.1 7
09/07/2013 40,221.0 40,900.5 7
10/07/2013 39,999.0 40,903.7 7
11/07/2013 40,479.8 40,909.5 7
12/07/2013 40,329.8 40,925.1 7
15/07/2013 40,322.3 40,948.4 7
16/07/2013 39,659.5 40,953.9 7
17/07/2013 40,240.2 40,975.4 7
18/07/2013 40,245.3 40,979.8 8
19/07/2013 39,891.7 40,984.5 8
22/07/2013 40,117.7 40,998.4 8
23/07/2013 40,790.2 41,002.7 8
24/07/2013 40,839.0 41,007.4 8
25/07/2013 40,752.1 41,008.3 8
26/07/2013 41,064.6 41,013.7 8
29/07/2013 40,341.9 41,034.1 8
30/07/2013 40,236.6 41,038.7 8
31/07/2013 40,837.9 41,050.1 8
01/08/2013 41,863.8 41,064.6 8
02/08/2013 42,051.6 41,079.6 8
05/08/2013 41,918.4 41,080.4 8
06/08/2013 41,914.8 41,094.8 8
07/08/2013 42,246.5 41,122.5 8
08/08/2013 42,712.1 41,125.0 8
09/08/2013 42,648.7 41,137.7 8
12/08/2013 42,124.8 41,176.8 8
13/08/2013 42,366.5 41,199.0 8
14/08/2013 42,430.1 41,200.4 8
15/08/2013 42,155.3 41,210.0 8
16/08/2013 42,049.7 41,226.0 8
19/08/2013 41,484.3 41,284.4 8
20/08/2013 41,825.4 41,300.7 8
21/08/2013 41,458.2 41,314.7 8
22/08/2013 41,007.4 41,327.6 8
23/08/2013 40,925.1 41,335.3 8
26/08/2013 40,419.9 41,458.2 8
27/08/2013 39,656.0 41,484.3 8
28/08/2013 39,248.1 41,515.5 9
29/08/2013 39,162.5 41,526.0 9
30/08/2013 39,492.4 41,531.8 9
02/09/2013 40,129.0 41,585.5 9
03/09/2013 39,541.5 41,588.3 9
04/09/2013 39,773.5 41,640.5 9
05/09/2013 39,686.5 41,682.6 9
06/09/2013 39,915.1 41,724.0 9
09/09/2013 40,953.9 41,733.0 9
10/09/2013 41,733.0 41,741.5 9
11/09/2013 41,640.5 41,752.3 9
12/09/2013 40,785.7 41,758.6 9
13/09/2013 41,122.5 41,761.1 9
17/09/2013 41,137.7 41,766.9 9
18/09/2013 41,902.2 41,778.6 9
19/09/2013 41,752.3 41,806.7 9
20/09/2013 41,226.0 41,825.4 9
23/09/2013 41,314.7 41,838.6 9
24/09/2013 41,210.0 41,863.8 9
25/09/2013 41,724.0 41,872.6 9
26/09/2013 41,327.6 41,876.9 9
27/09/2013 40,903.7 41,884.8 9
30/09/2013 40,185.2 41,898.2 9
01/10/2013 41,335.3 41,902.2 9
02/10/2013 41,300.7 41,905.2 9
03/10/2013 40,841.1 41,910.1 9
04/10/2013 40,909.5 41,910.5 9
07/10/2013 40,451.2 41,911.3 9
08/10/2013 39,916.8 41,914.8 9
09/10/2013 39,866.2 41,918.4 9
10/10/2013 40,490.0 41,925.1 9
11/10/2013 40,975.4 41,925.5 9
14/10/2013 40,882.1 41,976.4 9
15/10/2013 40,218.3 42,003.7 10
16/10/2013 40,355.3 42,049.7 10
17/10/2013 40,199.5 42,051.6 10 41961.79
18/10/2013 40,412.7 42,054.0 10
21/10/2013 40,345.8 42,060.6 10
22/10/2013 40,813.5 42,062.8 10
23/10/2013 40,552.6 42,065.0 10
24/10/2013 40,246.7 42,079.9 10
25/10/2013 40,671.6 42,090.0 10
28/10/2013 41,125.0 42,102.1 10
29/10/2013 41,284.4 42,124.8 10
30/10/2013 41,050.1 42,138.6 10
31/10/2013 41,038.7 42,155.3 10
01/11/2013 41,079.6 42,158.6 10
04/11/2013 41,013.7 42,160.4 10
05/11/2013 40,304.5 42,172.7 10
06/11/2013 40,280.1 42,183.8 10
07/11/2013 40,009.9 42,188.5 10
08/11/2013 39,864.2 42,198.0 10
11/11/2013 39,686.8 42,198.3 10
12/11/2013 39,594.6 42,246.5 10
13/11/2013 39,765.9 42,263.5 10
14/11/2013 40,306.7 42,289.2 10
15/11/2013 41,034.1 42,294.9 10
19/11/2013 40,643.3 42,304.6 10
20/11/2013 40,795.6 42,366.5 10
21/11/2013 40,998.4 42,406.7 10
22/11/2013 41,199.0 42,430.1 10
25/11/2013 40,948.4 42,439.8 10
26/11/2013 41,002.7 42,458.5 10
27/11/2013 41,872.6 42,460.2 11
28/11/2013 42,160.4 42,490.1 11
29/11/2013 42,499.1 42,498.0 11
02/12/2013 42,138.6 42,499.1 11
03/12/2013 41,876.9 42,508.0 11
04/12/2013 42,003.7 42,511.3 11
05/12/2013 41,910.1 42,531.1 11
06/12/2013 41,925.5 42,540.3 11
09/12/2013 42,289.2 42,547.5 11
10/12/2013 42,490.1 42,585.7 11
11/12/2013 42,304.6 42,602.1 11
13/12/2013 41,884.8 42,605.1 11
16/12/2013 42,054.0 42,610.7 11
17/12/2013 41,758.6 42,648.7 11
18/12/2013 42,079.9 42,686.7 11
19/12/2013 42,198.3 42,712.1 11
20/12/2013 42,183.8 42,727.1 11
23/12/2013 42,508.0 42,753.2 11
24/12/2013 42,585.7 42,808.2 11
26/12/2013 42,540.3 42,900.8 11
27/12/2013 42,753.2 42,914.2 11
30/12/2013 42,958.8 42,958.8 12
31/12/2013 42,727.1 42,984.4 12
02/01/2014 42,188.5 43,113.6 12
03/01/2014 42,065.0 43,223.7 12
06/01/2014 41,526.0 43,244.1 12
07/01/2014 41,778.6 43,278.1 12
08/01/2014 41,515.5 43,348.5 12
09/01/2014 41,585.5 43,431.0 12
10/01/2014 42,458.5 43,489.2 13
13/01/2014 42,158.6 43,497.2 13
14/01/2014 42,439.8 43,566.7 13
15/01/2014 42,511.3 43,664.7 13
16/01/2014 42,172.7 43,705.8 13
17/01/2014 41,911.3 43,717.6 13
20/01/2014 41,976.4 43,772.9 13
21/01/2014 41,838.6 43,871.3 13
22/01/2014 42,062.8 43,875.7 13
23/01/2014 41,531.8 43,878.3 13
24/01/2014 40,979.8 43,932.5 13
27/01/2014 40,863.4 43,965.4 14
28/01/2014 40,660.9 43,968.6 14
29/01/2014 40,689.9 43,973.2 14
30/01/2014 41,008.3 43,995.7 14
31/01/2014 40,879.8 44,004.3 14
04/02/2014 40,085.5 44,013.3 14
05/02/2014 39,880.9 44,017.1 14
06/02/2014 40,288.8 44,077.1 14
07/02/2014 40,525.7 44,096.3 14
10/02/2014 40,116.4 44,113.5 14
11/02/2014 40,759.6 44,121.0 14
12/02/2014 40,690.1 44,136.6 14
13/02/2014 40,309.0 44,141.9 14
14/02/2014 40,710.9 44,153.0 14
17/02/2014 40,735.5 44,159.7 14
18/02/2014 40,421.9 44,299.6 14
19/02/2014 40,006.4 44,304.2 14
20/02/2014 39,654.2 44,322.5 14
21/02/2014 39,724.6 44,370.6 14
24/02/2014 39,792.7 44,380.8 14
25/02/2014 39,023.7 44,408.4 14
26/02/2014 38,605.6 44,562.3 15
27/02/2014 38,912.9 44,571.2 15
28/02/2014 38,782.9 44,625.9 15
03/03/2014 38,534.8 44,639.8 15
04/03/2014 39,084.4 44,748.1 15
05/03/2014 39,021.1 44,859.8 15
06/03/2014 39,176.3 44,862.5 15
07/03/2014 38,913.0 44,862.9 15
10/03/2014 38,671.0 44,865.3 15
11/03/2014 38,689.6 44,873.4 15
12/03/2014 38,634.8 44,888.1 15
13/03/2014 38,037.5 44,943.3 16
14/03/2014 37,951.0 45,019.2 16
18/03/2014 38,814.7 45,063.9 16
19/03/2014 38,811.9 45,089.4 16
20/03/2014 39,616.2 45,212.5 16
21/03/2014 40,021.7 45,223.9 16
24/03/2014 39,821.7 45,278.1 16
25/03/2014 39,793.0 45,320.3 16
26/03/2014 39,761.3 45,428.7 17
27/03/2014 39,911.0 45,443.0 17
28/03/2014 40,048.2 45,570.7 17
31/03/2014 40,461.6 45,575.9 17
01/04/2014 40,470.0 45,688.1 17
02/04/2014 40,900.5 45,753.2 17
03/04/2014 40,563.1 45,768.5 17
04/04/2014 40,598.3 45,908.0 17
07/04/2014 40,595.7 45,912.5 17
17
ño de la muestra 318
ro ce Intervalos 17
e Inferior 37,517.2
e Superior 45,912.5
ño del Intervalo 493.84

Distribucion de Frecuencias del IPC

ervalo de Clase

Limite Marca de Frecuencia Frecuencia Frecuencia

𝑴𝑪𝒊 𝑭𝑨𝒊
Superior Clase absoluta Relativa Acumulada

38,011.07 37,764.15 4 0.01 4

38,504.91 38,257.99 2 0.01 6
38,998.75 38,751.83 11 0.03 17
39,492.59 39,245.67 12 0.04 29
39,986.43 39,739.51 25 0.08 54
40,480.27 40,233.35 39 0.12 93
40,974.11 40,727.19 43 0.14 136
41,467.95 41,221.03 29 0.09 165
41,961.79 41,714.87 33 0.10 198
42,455.63 42,208.71 30 0.09 228
42,949.47 42,702.55 22 0.07 250
43,443.31 43,196.39 8 0.03 258
43,937.15 43,690.23 11 0.03 269
44,430.99 44,184.07 21 0.07 290
44,924.83 44,677.91 11 0.03 301
45,418.67 45,171.75 8 0.03 309
45,913.51 45,666.09 9 0.03 318

Total 318 1
41,617.05
42455.63
 Evolución Histo
46,500.0

45,500.0

44,500.0

43,500.0

42,500.0

41,500.0

Frecuencia Con 40,500.0

Relativa Función

𝑭𝑹𝒊
39,500.0
Acumulada Contar
38,500.0

37,500.0
31/12/201221/02/201317/04/201307/06/201329/07/2

1.26% 4
1.89% 2
5.35% 11
9.12% 12 Histograma de
16.98% 25 50
29.25% 39 45
40
42.77% 43
35
51.89% 29 30
62.26% 33 25
71.70% 30 20
78.62% 22 15
10
81.13% 8
5
84.59% 11
0
91.19% 21 .1
5
.9
9
.8
3
.6
7
.5
1
.3
5
.1
9
.0
3
.8
7
4 7 1 5 9 3 7 1 4
94.65% 11 ,76 ,25 ,75 ,24 ,73 ,23 ,72 ,22 ,71
3 7 3 8 3 8 3 9 3 9 4 0 4 0 4 1 4 1 4
97.17% 8
100.00% 9
318
Histograma de Frecu
0.16
0.14
0.12
0.10
 Histograma de Frecu
0.16
0.14
0.12
0.10
0.08
0.06
0.04
0.02
0.00
5 9 3 7 1 5 9 3 7
4 .1 7 .9 1 .8 5 .6 9 .5 3 .3 7 .1 1 .0 4 .8
76 25 75 24 73 23 72 22 71
3 7, 3 8, 3 8, 3 9, 3 9, 4 0, 4 0, 4 1, 4 1, 4

Histograma de Frecu
350

300

250

200

150

100

50

-
5 9 3 7 1 5 9 3 7
4 .1 7 .9 1 .8 5 .6 9 .5 3 .3 7 .1 1 .0 4 .8
76 25 75 24 73 23 72 22 71
3 7, 3 8, 3 8, 3 9, 3 9, 4 0, 4 0, 4 1, 4 1,

Histograma de Frecu
120.00%

100.00%

80.00%

60.00%

40.00%

20.00%

0.00%
15 99 83 67 51 35 19 03
6 4. 5 7. 5 1. 4 5. 3 9. 3 3. 2 7. 2 1. 14
7 ,7 8 ,2 8 ,7 9 ,2 9 ,7 0 ,2 0 ,7 1 ,2 1 ,7
3 3 3 3 3 4 4 4 4
40.00%

20.00%

0.00%
5 9 3 7 1 5 9 3
4 .1 7 .9 1 .8 5 .6 9 .5 3 .3 7 .1 1 .0
6 5 5 4 3 3 2 2 14
7 ,7 8 ,2 8 ,7 9 ,2 9 ,7 0 ,2 0 ,7 1 ,2 1 ,7
3 3 3 3 3 4 4 4 4
 Evolución Historica del IPC

17/04/201307/06/201329/07/201318/09/201307/11/201302/01/201424/02/2014

Histograma de Frecuencias

1 5 9 3 7 1 5 9 3 7 1 5 9
9 .5 3 .3 7 .1 1 .0 4 .8 8 .7 2 .5 6 .3 0 .2 4 .0 7 .9 1 .7 6 .0
,73 ,23 ,72 ,22 ,71 ,20 ,70 ,19 ,69 ,18 ,67 ,17 ,66
9 4 0 4 0 4 1 4 1 4 2 4 2 4 3 4 3 4 4 4 4 4 5 4 5

stograma de Frecuencias Relativas

stograma de Frecuencias Relativas

1 5 9 3 7 1 5 9 3 7 1 5 9
9 .5 3 .3 7 .1 1 .0 4 .8 8 .7 2 .5 6 .3 0 .2 4 .0 7 .9 1 .7 6 .0
73 23 72 22 71 20 70 19 69 18 67 17 66
9, 4 0, 4 0, 4 1, 4 1, 4 2, 4 2, 4 3, 4 3, 4 4, 4 4, 4 5, 4 5,

stograma de Frecuencia Acumulada

1 5 9 3 7 1 5 9 3 7 1 5 9
9 .5 3 .3 7 .1 1 .0 4 .8 8 .7 2 .5 6 .3 0 .2 4 .0 7 .9 1 .7 6 .0
73 23 72 22 71 20 70 19 69 18 67 17 66
9, 4 0, 4 0, 4 1, 4 1, 4 2, 4 2, 4 3, 4 3, 4 4, 4 4, 4 5, 4 5,

stograma de Frecuencia Acumulada

67 51 35 19 03 87 71 55 39 23 07 91 75 09
5. 3 9. 3 3. 2 7. 2 1. 1 4. 0 8. 0 2. 9 6. 9 0. 8 4. 7 7. 7 1. 6 6.
,7 ,2 ,7 ,2 ,7 ,2 ,7 ,1 ,6 ,1 ,6 ,1 ,6
39 40 40 41 41 42 42 43 43 44 44 45 45
 67 .5
1
.3
5
.1
9
.0
3
.8
7
.7
1
.5
5
.3
9
.2
3
.0
7
.9
1
.7
5
.0
9
5. 3 9 3 3 2 7 2 1 1 4 0 8 0 2 9 6 9 0 8 4 7 7 7 1 6 6
,7 ,2 ,7 ,2 ,7 ,2 ,7 ,1 ,6 ,1 ,6 ,1 ,6
39 40 40 41 41 42 42 43 43 44 44 45 45
 Datos
Fecha MXPUSD
Ordenados

31/12/2012 12.97 12.0 Tamaño de la muestra

02/01/2013 12.75 12.0 Número ce Intervalos
03/01/2013 12.74 12.1 Límite Inferior
04/01/2013 12.76 12.1 Límite Superior
07/01/2013 12.77 12.1 Tamaño del Intervalo
08/01/2013 12.80 12.1

09/01/2013 12.75 12.1 Distribuc

10/01/2013 12.66 12.1 Intervalo de Clas
Número de Límite
Intervalo Inferior
11/01/2013 12.65 12.1

14/01/2013 12.65 12.1

15/01/2013 12.65 12.1
16/01/2013 12.63 12.1 1 11.98
17/01/2013 12.59 12.1 2 12.07
18/01/2013 12.66 12.1 3 12.16
21/01/2013 12.71 12.1 4 12.25
22/01/2013 12.68 12.2 5 12.34
23/01/2013 12.66 12.2 6 12.43
24/01/2013 12.63 12.2 7 12.51
25/01/2013 12.70 12.2 8 12.60
28/01/2013 12.78 12.2 9 12.69
29/01/2013 12.71 12.2 10 12.78
30/01/2013 12.74 12.2 11 12.87
31/01/2013 12.71 12.2 12 12.96
01/02/2013 12.64 12.2 13 13.05
05/02/2013 12.63 12.2 14 13.14
06/02/2013 12.67 12.2 15 13.23
07/02/2013 12.71 12.2 16 13.32
08/02/2013 12.73 12.3 17 13.40
11/02/2013 12.77 12.3
12/02/2013 12.74 12.3
13/02/2013 12.71 12.3
14/02/2013 12.70 12.3 Promedio
15/02/2013 12.69 12.3
18/02/2013 12.70 12.3
19/02/2013 12.69 12.3
20/02/2013 12.67 12.3
21/02/2013 12.77 12.3
22/02/2013 12.75 12.4
25/02/2013 12.70 12.4
26/02/2013 12.87 12.4
27/02/2013 12.83 12.4
28/02/2013 12.78 12.4
01/03/2013 12.80 12.4
04/03/2013 12.78 12.4
05/03/2013 12.74 12.4
06/03/2013 12.73 12.4
07/03/2013 12.78 12.5
08/03/2013 12.67 12.5
11/03/2013 12.53 12.5
12/03/2013 12.46 12.5
13/03/2013 12.40 12.5
14/03/2013 12.45 12.5
15/03/2013 12.44 12.5
19/03/2013 12.43 12.5
20/03/2013 12.39 12.5
21/03/2013 12.38 12.5
22/03/2013 12.37 12.5
25/03/2013 12.36 12.5
26/03/2013 12.35 12.6
27/03/2013 12.36 12.6
01/04/2013 12.34 12.6
02/04/2013 12.27 12.6
03/04/2013 12.33 12.6
04/04/2013 12.32 12.6
05/04/2013 12.24 12.6
08/04/2013 12.16 12.6
09/04/2013 12.13 12.6
10/04/2013 12.11 12.6
11/04/2013 12.07 12.6
12/04/2013 12.08 12.6
15/04/2013 12.17 12.6
16/04/2013 12.17 12.6
17/04/2013 12.24 12.7
18/04/2013 12.25 12.7
19/04/2013 12.23 12.7
22/04/2013 12.32 12.7
23/04/2013 12.25 12.7
24/04/2013 12.28 12.7
25/04/2013 12.12 12.7
26/04/2013 12.16 12.7
29/04/2013 12.13 12.7
30/04/2013 12.15 12.7
02/05/2013 12.18 12.7
03/05/2013 12.09 12.7
06/05/2013 12.11 12.7
07/05/2013 12.07 12.7
08/05/2013 12.04 12.7
09/05/2013 11.98 12.7
10/05/2013 12.11 12.7
13/05/2013 12.14 12.7
14/05/2013 12.15 12.7
15/05/2013 12.23 12.7
16/05/2013 12.24 12.7
17/05/2013 12.32 12.7
20/05/2013 12.33 12.7
21/05/2013 12.34 12.7
22/05/2013 12.31 12.7
23/05/2013 12.48 12.7
24/05/2013 12.52 12.7
27/05/2013 12.48 12.7
28/05/2013 12.53 12.7
29/05/2013 12.63 12.7
30/05/2013 12.78 12.7
31/05/2013 12.80 12.7
03/06/2013 12.79 12.7
04/06/2013 12.73 12.7
05/06/2013 12.82 12.7
06/06/2013 12.91 12.7
07/06/2013 12.72 12.7
10/06/2013 12.86 12.7
11/06/2013 12.88 12.7
12/06/2013 12.84 12.8
13/06/2013 12.78 12.8
14/06/2013 12.69 12.8
17/06/2013 12.74 12.8
18/06/2013 12.88 12.8
19/06/2013 12.87 12.8
20/06/2013 13.40 12.8
21/06/2013 13.40 12.8
24/06/2013 13.40 12.8
25/06/2013 13.24 12.8
26/06/2013 13.19 12.8
27/06/2013 13.02 12.8
28/06/2013 13.03 12.8
01/07/2013 12.91 12.8
02/07/2013 12.99 12.8
03/07/2013 13.04 12.8
04/07/2013 12.89 12.8
05/07/2013 13.06 12.8
08/07/2013 12.93 12.8
09/07/2013 12.87 12.8
10/07/2013 12.95 12.8
11/07/2013 12.86 12.8
12/07/2013 12.82 12.8
15/07/2013 12.74 12.8
16/07/2013 12.63 12.8
17/07/2013 12.55 12.8
18/07/2013 12.50 12.8
19/07/2013 12.55 12.8
22/07/2013 12.51 12.9
23/07/2013 12.51 12.9
24/07/2013 12.63 12.9
25/07/2013 12.65 12.9
26/07/2013 12.71 12.9
29/07/2013 12.73 12.9
30/07/2013 12.76 12.9
31/07/2013 12.85 12.9
01/08/2013 12.81 12.9
02/08/2013 12.69 12.9
05/08/2013 12.68 12.9
06/08/2013 12.64 12.9
07/08/2013 12.70 12.9
08/08/2013 12.65 12.9
09/08/2013 12.59 12.9
12/08/2013 12.57 12.9
13/08/2013 12.75 12.9
14/08/2013 12.73 12.9
15/08/2013 12.86 12.9
16/08/2013 12.87 12.9
19/08/2013 13.01 12.9
20/08/2013 13.01 12.9
21/08/2013 13.14 12.9
22/08/2013 13.15 12.9
23/08/2013 13.00 12.9
26/08/2013 13.11 12.9
27/08/2013 13.34 12.9
28/08/2013 13.25 12.9
29/08/2013 13.31 12.9
30/08/2013 13.34 12.9
02/09/2013 13.31 13.0
03/09/2013 13.44 13.0
04/09/2013 13.31 13.0
05/09/2013 13.41 13.0
06/09/2013 13.24 13.0
09/09/2013 13.15 13.0
10/09/2013 13.11 13.0
11/09/2013 13.09 13.0
12/09/2013 13.09 13.0
13/09/2013 13.05 13.0
17/09/2013 12.92 13.0
18/09/2013 12.97 13.0
19/09/2013 12.72 13.0
20/09/2013 12.77 13.0
23/09/2013 12.78 13.0
24/09/2013 12.88 13.0
25/09/2013 12.95 13.0
26/09/2013 13.01 13.0
27/09/2013 13.15 13.0
30/09/2013 13.17 13.0
01/10/2013 13.13 13.0
02/10/2013 13.16 13.0
03/10/2013 13.27 13.0
04/10/2013 13.10 13.0
07/10/2013 13.10 13.0
08/10/2013 13.14 13.0
09/10/2013 13.21 13.0
10/10/2013 13.09 13.0
11/10/2013 13.05 13.0
14/10/2013 13.05 13.0
15/10/2013 12.97 13.0
16/10/2013 12.88 13.0
17/10/2013 12.77 13.0 41961.79
18/10/2013 12.80 13.0
21/10/2013 12.93 13.0
22/10/2013 12.87 13.1
23/10/2013 12.94 13.1
24/10/2013 12.99 13.1
25/10/2013 12.87 13.1
28/10/2013 12.89 13.1
29/10/2013 12.89 13.1
30/10/2013 12.86 13.1
31/10/2013 13.01 13.1
01/11/2013 13.08 13.1
04/11/2013 12.99 13.1
05/11/2013 13.13 13.1
06/11/2013 13.14 13.1
07/11/2013 13.19 13.1
08/11/2013 13.24 13.1
11/11/2013 13.23 13.1
12/11/2013 13.19 13.1
13/11/2013 13.10 13.1
14/11/2013 13.02 13.1
15/11/2013 12.95 13.1
19/11/2013 12.89 13.1
20/11/2013 12.97 13.1
21/11/2013 13.06 13.1
22/11/2013 13.02 13.1
25/11/2013 13.03 13.1
26/11/2013 13.07 13.1
27/11/2013 13.09 13.1
28/11/2013 13.08 13.1
29/11/2013 13.11 13.1
02/12/2013 13.20 13.1
03/12/2013 13.24 13.1
04/12/2013 13.08 13.1
05/12/2013 13.01 13.1
06/12/2013 12.93 13.1
09/12/2013 12.86 13.1
10/12/2013 12.86 13.1
11/12/2013 12.93 13.1
13/12/2013 12.95 13.1
16/12/2013 12.94 13.1
17/12/2013 12.96 13.1
18/12/2013 12.99 13.1
19/12/2013 12.97 13.1
20/12/2013 12.96 13.1
23/12/2013 12.96 13.1
24/12/2013 13.02 13.1
26/12/2013 13.05 13.2
27/12/2013 13.08 13.2
30/12/2013 13.07 13.2
31/12/2013 13.08 13.2
02/01/2014 13.10 13.2
03/01/2014 13.09 13.2
06/01/2014 13.09 13.2
07/01/2014 13.03 13.2
08/01/2014 13.08 13.2
09/01/2014 13.14 13.2
10/01/2014 13.01 13.2
13/01/2014 12.99 13.2
14/01/2014 13.10 13.2
15/01/2014 13.17 13.2
16/01/2014 13.29 13.2
17/01/2014 13.27 13.2
20/01/2014 13.24 13.2
21/01/2014 13.30 13.2
22/01/2014 13.32 13.2
23/01/2014 13.37 13.2
24/01/2014 13.49 13.2
27/01/2014 13.44 13.2
28/01/2014 13.31 13.2
29/01/2014 13.37 13.2
30/01/2014 13.32 13.2
31/01/2014 13.38 13.2
04/02/2014 13.39 13.2
05/02/2014 13.37 13.2
06/02/2014 13.22 13.2
07/02/2014 13.33 13.2
10/02/2014 13.31 13.3
11/02/2014 13.29 13.3
12/02/2014 13.31 13.3
13/02/2014 13.33 13.3
14/02/2014 13.25 13.3
17/02/2014 13.19 13.3
18/02/2014 13.23 13.3
19/02/2014 13.27 13.3
20/02/2014 13.29 13.3
21/02/2014 13.27 13.3
24/02/2014 13.21 13.3
25/02/2014 13.22 13.3
26/02/2014 13.30 13.3
27/02/2014 13.31 13.3
28/02/2014 13.24 13.3
03/03/2014 13.32 13.3
04/03/2014 13.28 13.3
05/03/2014 13.25 13.3
06/03/2014 13.15 13.3
07/03/2014 13.18 13.3
10/03/2014 13.22 13.3
11/03/2014 13.24 13.3
12/03/2014 13.27 13.3
13/03/2014 13.25 13.3
14/03/2014 13.23 13.3
18/03/2014 13.17 13.3
19/03/2014 13.17 13.3
20/03/2014 13.27 13.3
21/03/2014 13.22 13.4
24/03/2014 13.20 13.4
25/03/2014 13.13 13.4
26/03/2014 13.13 13.4
27/03/2014 13.08 13.4
28/03/2014 13.08 13.4
31/03/2014 13.05 13.4
01/04/2014 13.03 13.4
02/04/2014 13.10 13.4
03/04/2014 13.13 13.4
04/04/2014 13.03 13.4
07/04/2014 13.02 13.5
0 -
ño de la muestra 319
ro ce Intervalos 17
e Inferior 11.98
e Superior 13.49
ño del Intervalo 0.0889588235

Distribucion de Frecuencias del IPC

ervalo de Clase
Limite Marca de Frecuencia Frecuencia Frecuencia

𝑭𝑨𝒊
Superior Clase absoluta Relativa Acumulada

𝑴𝑪𝒊

12.07 12.03 3 0.01 3

12.16 12.11 13 0.04 16
12.25 12.20 9 0.03 25
12.34 12.29 10 0.03 35
12.43 12.38 9 0.03 44
12.51 12.47 9 0.03 53
12.60 12.56 8 0.03 61
12.69 12.65 25 0.08 86
12.78 12.74 39 0.12 125
12.87 12.83 24 0.08 149
12.96 12.91 25 0.08 174
13.05 13.00 29 0.09 203
13.14 13.09 37 0.12 240
13.23 13.18 27 0.09 267
13.32 13.27 32 0.10 299
13.40 13.36 14 0.04 313
13.49 13.45 4 0.01 317

TOTAL 317 1
42455.63
 Evolución Histo
16.00

14.00

12.00

10.00

8.00

6.00
Frecuencia Con
Relativa Función

𝑭𝑹𝒊
4.00
Acumulada Contar
2.00

-
31/12/2012 15/02/2013 05/04/2013 22/05/2013 05/07/2013 20/0

0.95% 3
5.05% 13
7.89% 9
11.04% 10 Histograma de
13.88% 9 45
16.72% 9 40
19.24% 8 35
27.13% 25 30
39.43% 39
25
47.00% 24
20
54.89% 25
15
64.04% 29
75.71% 37 10

84.23% 27 5

94.32% 32 0
12.03 12.11 12.20 12.29 12.38 12.47 12.56 12.65 12.7
98.74% 14
100.00% 4

Histograma de Frecu
0.14

0.12

0.10
 Histograma de Frecu
0.14

0.12

0.10

0.08

0.06

0.04

0.02

-
12.03 12.11 12.20 12.29 12.38 12.47 12.56 12.65 12

Histograma de Frecu
350

300

250

200

150

100

50

-
12.03 12.11 12.20 12.29 12.38 12.47 12.56 12.65 12

Histograma de Frecu
120.00%

100.00%

80.00%

60.00%

40.00%

20.00%

0.00%
12.03 12.11 12.20 12.29 12.38 12.47 12.56 12.65 1
60.00%

40.00%

20.00%

0.00%
12.03 12.11 12.20 12.29 12.38 12.47 12.56 12.65 1
 Evolución Historica del IPC

/2013 22/05/2013 05/07/2013 20/08/2013 04/10/2013 20/11/2013 08/01/2014 24/02/2014

Histograma de Frecuencias

9 12.38 12.47 12.56 12.65 12.74 12.83 12.91 13.00 13.09 13.18 13.27 13.36 13.45

stograma de Frecuencias Relativas

stograma de Frecuencias Relativas

.29 12.38 12.47 12.56 12.65 12.74 12.83 12.91 13.00 13.09 13.18 13.27 13.36 13.45

stograma de Frecuencia Acumulada

29 12.38 12.47 12.56 12.65 12.74 12.83 12.91 13.00 13.09 13.18 13.27 13.36 13.45

stograma de Frecuencia Acumulada

12.29 12.38 12.47 12.56 12.65 12.74 12.83 12.91 13.00 13.09 13.18 13.27 13.36 13.45
12.29 12.38 12.47 12.56 12.65 12.74 12.83 12.91 13.00 13.09 13.18 13.27 13.36 13.45
 Rendimientos
FECHA Fix Banxico Rendimientos Continuos al
Cuadrado
Fri
Discretos Continuos
1 31/12/2012 12.9658
2 02/01/2013 12.7488 -1.67363% -0.017 0.000284865944
3 03/01/2013 12.7430 -0.04549% 0.000 2.070689534E-07
4 04/01/2013 12.7597 0.13105% 0.001 1.71522356E-06

5 07/01/2013 12.7679 0.06426% 0.001 4.12731631E-07

6 08/01/2013 12.8015 0.26316% 0.003 6.907135434E-06

7 09/01/2013 12.7503 -0.39995% -0.004 1.606046358E-05

8 10/01/2013 12.6555 -0.74351% -0.007 5.569483832E-05
9 11/01/2013 12.6478 -0.06084% -0.001 3.704137839E-07
10 14/01/2013 12.6533 0.04349% 0.000 1.890194859E-07
11 15/01/2013 12.6526 -0.00553% 0.000 3.060641739E-09
12 16/01/2013 12.6305 -0.17467% -0.002 3.056216493E-06
13 17/01/2013 12.5868 -0.34599% -0.003 1.201231092E-05
14 18/01/2013 12.6555 0.54581% 0.005 2.962905241E-05
15 21/01/2013 12.7098 0.42906% 0.004 1.833078109E-05
16 22/01/2013 12.6817 -0.22109% -0.002 4.898874014E-06
17 23/01/2013 12.6616 -0.15850% -0.002 2.516088769E-06
18 24/01/2013 12.6286 -0.26063% -0.003 6.810575886E-06
19 25/01/2013 12.6993 0.55984% 0.006 3.116755318E-05
20 28/01/2013 12.7802 0.63704% 0.006 4.032535049E-05
21 29/01/2013 12.7134 -0.52268% -0.005 2.746329041E-05
22 30/01/2013 12.7408 0.21552% 0.002 4.634923262E-06
23 31/01/2013 12.7094 -0.24645% -0.002 6.088878794E-06
24 01/02/2013 12.6377 -0.56415% -0.006 3.200693316E-05
25 05/02/2013 12.6294 -0.06568% -0.001 4.316238249E-07
26 06/02/2013 12.6664 0.29297% 0.003 8.557900271E-06

27 07/02/2013 12.7105 0.34817% 0.003 1.207983238E-05

28 08/02/2013 12.7307 0.15892% 0.002 2.521666962E-06
29 11/02/2013 12.7706 0.31342% 0.003 9.792235527E-06
30 12/02/2013 12.7364 -0.26780% -0.003 7.19107734E-06
31 13/02/2013 12.7116 -0.19472% -0.002 3.798886478E-06
32 14/02/2013 12.6982 -0.10542% -0.001 1.112415868E-06
33 15/02/2013 12.6866 -0.09135% -0.001 8.352731826E-07
34 18/02/2013 12.6959 0.07331% 0.001 5.36978797E-07
35 19/02/2013 12.6873 -0.06774% -0.001 4.591601443E-07
36 20/02/2013 12.6694 -0.14109% -0.001 1.993337021E-06
37 21/02/2013 12.7699 0.79325% 0.008 6.242899158E-05
38 22/02/2013 12.7517 -0.14252% -0.001 2.03416941E-06
39 25/02/2013 12.7028 -0.38348% -0.004 1.476215078E-05
40 26/02/2013 12.8680 1.30050% 0.013 0.000166956577
41 27/02/2013 12.8322 -0.27821% -0.003 7.761641875E-06
42 28/02/2013 12.7795 -0.41069% -0.004 1.693579684E-05
43 01/03/2013 12.8012 0.16980% 0.002 2.87842434E-06
44 04/03/2013 12.7814 -0.15467% -0.002 2.396079285E-06
45 05/03/2013 12.7355 -0.35912% -0.004 1.294286663E-05
46 06/03/2013 12.7345 -0.00785% 0.000 6.16597986E-09
47 07/03/2013 12.7839 0.38792% 0.004 1.499022297E-05
48 08/03/2013 12.6684 -0.90348% -0.009 8.237128763E-05
49 11/03/2013 12.5308 -1.08617% -0.011 0.00011927021
50 12/03/2013 12.4641 -0.53229% -0.005 2.848465173E-05
51 13/03/2013 12.3967 -0.54075% -0.005 2.940029668E-05
52 14/03/2013 12.4545 0.46625% 0.005 2.163826849E-05
53 15/03/2013 12.4390 -0.12445% -0.001 1.550784942E-06
54 19/03/2013 12.4339 -0.04100% 0.000 1.681696065E-07
55 20/03/2013 12.3909 -0.34583% -0.003 1.20012437E-05
56 21/03/2013 12.3841 -0.05488% -0.001 3.013356483E-07
57 22/03/2013 12.3724 -0.09448% -0.001 8.934151005E-07
58 25/03/2013 12.3579 -0.11720% -0.001 1.375109637E-06
59 26/03/2013 12.3546 -0.02670% 0.000 7.132709091E-08
60 27/03/2013 12.3612 0.05342% 0.001 2.852321914E-07
61 01/04/2013 12.3438 -0.14076% -0.001 1.984215853E-06
62 02/04/2013 12.2728 -0.57519% -0.006 3.32753751E-05
63 03/04/2013 12.3266 0.43837% 0.004 1.913272806E-05
64 04/04/2013 12.3197 -0.05598% -0.001 3.135124085E-07
65 05/04/2013 12.2383 -0.66073% -0.007 4.394667197E-05
66 08/04/2013 12.1588 -0.64960% -0.007 4.247377972E-05
67 09/04/2013 12.1304 -0.23358% -0.002 5.468530585E-06
68 10/04/2013 12.1140 -0.13520% -0.001 1.830311206E-06
69 11/04/2013 12.0691 -0.37065% -0.004 1.378890336E-05
70 12/04/2013 12.0824 0.11020% 0.001 1.213040059E-06
71 15/04/2013 12.1729 0.74902% 0.007 5.568623802E-05
72 16/04/2013 12.1668 -0.05011% -0.001 2.512402619E-07
 73 17/04/2013 12.2370 0.57698% 0.006 3.309952011E-05
74 18/04/2013 12.2479 0.08907% 0.001 7.927137208E-07
75 19/04/2013 12.2254 -0.18370% -0.002 3.380961337E-06
76 22/04/2013 12.3227 0.79588% 0.008 6.284264458E-05
77 23/04/2013 12.2492 -0.59646% -0.006 3.578984204E-05
78 24/04/2013 12.2768 0.22532% 0.002 5.065532129E-06
79 25/04/2013 12.1231 -1.25195% -0.013 0.000158724191
80 26/04/2013 12.1550 0.26313% 0.003 6.905775654E-06
81 29/04/2013 12.1326 -0.18429% -0.002 3.402413327E-06
82 30/04/2013 12.1456 0.10715% 0.001 1.146868988E-06
83 02/05/2013 12.1756 0.24700% 0.002 6.086013945E-06
84 03/05/2013 12.0851 -0.74329% -0.007 5.566145102E-05
85 06/05/2013 12.1074 0.18452% 0.002 3.398665821E-06
86 07/05/2013 12.0733 -0.28165% -0.003 7.954842533E-06
87 08/05/2013 12.0393 -0.28161% -0.003 7.952987824E-06
88 09/05/2013 11.9807 -0.48674% -0.005 2.380734363E-05
89 10/05/2013 12.1094 1.07423% 0.011 0.000114168986
90 13/05/2013 12.1448 0.29233% 0.003 8.52105215E-06
91 14/05/2013 12.1485 0.03047% 0.000 9.27877021E-08
92 15/05/2013 12.2313 0.68157% 0.007 4.613852722E-05
93 16/05/2013 12.2378 0.05314% 0.001 2.822609074E-07
94 17/05/2013 12.3177 0.65290% 0.007 4.235054973E-05
95 20/05/2013 12.3258 0.06576% 0.001 4.321408114E-07
96 21/05/2013 12.3414 0.12656% 0.001 1.599814371E-06
97 22/05/2013 12.3113 -0.24389% -0.002 5.962994827E-06
98 23/05/2013 12.4764 1.34104% 0.013 0.000177457566
99 24/05/2013 12.5219 0.36469% 0.004 1.32514314E-05
100 27/05/2013 12.4831 -0.30986% -0.003 9.630978689E-06
101 28/05/2013 12.5275 0.35568% 0.004 1.260603832E-05
102 29/05/2013 12.6328 0.84055% 0.008 7.00632332E-05
103 30/05/2013 12.7781 1.15018% 0.011 0.0001307858
104 31/05/2013 12.8035 0.19878% 0.002 3.943413348E-06
105 03/06/2013 12.7882 -0.11950% -0.001 1.429699233E-06
106 04/06/2013 12.7317 -0.44181% -0.004 1.960651336E-05
107 05/06/2013 12.8167 0.66762% 0.007 4.427653571E-05
108 06/06/2013 12.9079 0.71157% 0.007 5.02754592E-05
109 07/06/2013 12.7173 -1.47662% -0.015 0.000221302987
110 10/06/2013 12.8572 1.10008% 0.011 0.000119698796
111 11/06/2013 12.8846 0.21311% 0.002 4.53193447E-06
112 12/06/2013 12.8442 -0.31355% -0.003 9.862439982E-06
113 13/06/2013 12.7812 -0.49049% -0.005 2.417695119E-05
114 14/06/2013 12.6916 -0.70103% -0.007 4.949099912E-05
115 17/06/2013 12.7370 0.35772% 0.004 1.275051479E-05
116 18/06/2013 12.8800 1.12271% 0.011 0.000124647781
117 19/06/2013 12.8695 -0.08152% -0.001 6.651215769E-07
118 20/06/2013 13.4015 4.13380% 0.041 0.001640774126
119 21/06/2013 13.4041 0.01940% 0.000 3.763185483E-08
120 24/06/2013 13.3966 -0.05595% -0.001 3.132494131E-07
121 25/06/2013 13.2424 -1.15104% -0.012 0.000134030181
122 26/06/2013 13.1884 -0.40778% -0.004 1.66966023E-05
123 27/06/2013 13.0235 -1.25034% -0.013 0.0001583127
124 28/06/2013 13.0279 0.03379% 0.000 1.141046171E-07
125 01/07/2013 12.9131 -0.88119% -0.009 7.833863688E-05
126 02/07/2013 12.9850 0.55680% 0.006 3.08307576E-05
127 03/07/2013 13.0377 0.40585% 0.004 1.640505532E-05
128 04/07/2013 12.8902 -1.13133% -0.011 0.000129454966
129 05/07/2013 13.0567 1.29168% 0.013 0.00016471359
130 08/07/2013 12.9267 -0.99566% -0.010 0.000100129486
131 09/07/2013 12.8654 -0.47421% -0.005 2.259483467E-05
132 10/07/2013 12.9494 0.65291% 0.007 4.235299234E-05
133 11/07/2013 12.8599 -0.69115% -0.007 4.810133081E-05
134 12/07/2013 12.8234 -0.28383% -0.003 8.078759054E-06
135 15/07/2013 12.7387 -0.66051% -0.007 4.391743143E-05
136 16/07/2013 12.6299 -0.85409% -0.009 7.357497209E-05
137 17/07/2013 12.5455 -0.66826% -0.007 4.495679883E-05
138 18/07/2013 12.4976 -0.38181% -0.004 1.463375912E-05
139 19/07/2013 12.5499 0.41848% 0.004 1.743957355E-05
140 22/07/2013 12.5054 -0.35458% -0.004 1.261774401E-05
141 23/07/2013 12.5093 0.03119% 0.000 9.722962592E-08
142 24/07/2013 12.6330 0.98886% 0.010 9.682698096E-05
143 25/07/2013 12.6468 0.10924% 0.001 1.191985529E-06
144 26/07/2013 12.7091 0.49261% 0.005 2.414792242E-05
145 29/07/2013 12.7321 0.18097% 0.002 3.269194171E-06
146 30/07/2013 12.7635 0.24662% 0.002 6.067213154E-06
147 31/07/2013 12.8464 0.64951% 0.006 4.191373092E-05
148 01/08/2013 12.8068 -0.30826% -0.003 9.531647195E-06
149 02/08/2013 12.6904 -0.90889% -0.009 8.336562395E-05
150 05/08/2013 12.6759 -0.11426% -0.001 1.307018821E-06
151 06/08/2013 12.6445 -0.24771% -0.002 6.151465723E-06
152 07/08/2013 12.6989 0.43023% 0.004 1.843017115E-05
153 08/08/2013 12.6460 -0.41657% -0.004 1.742574814E-05
154 09/08/2013 12.5889 -0.45153% -0.005 2.048002649E-05
155 12/08/2013 12.5666 -0.17714% -0.002 3.143431762E-06
156 13/08/2013 12.7545 1.49523% 0.015 0.000220274568
157 14/08/2013 12.7255 -0.22737% -0.002 5.181524009E-06
158 15/08/2013 12.8625 1.07658% 0.011 0.000114666549
159 16/08/2013 12.8722 0.07541% 0.001 5.682838071E-07
160 19/08/2013 13.0124 1.08917% 0.011 0.000117349595
161 20/08/2013 13.0064 -0.04611% 0.000 2.127100364E-07
162 21/08/2013 13.1424 1.04564% 0.010 0.0001082037
163 22/08/2013 13.1486 0.04718% 0.000 2.224483435E-07
164 23/08/2013 12.9979 -1.14613% -0.012 0.000132882867
165 26/08/2013 13.1090 0.85475% 0.009 7.244071719E-05
166 27/08/2013 13.3366 1.73621% 0.017 0.000296291439
167 28/08/2013 13.2539 -0.62010% -0.006 3.869196654E-05
168 29/08/2013 13.3104 0.42629% 0.004 1.809511903E-05
169 30/08/2013 13.3415 0.23365% 0.002 5.446591619E-06
170 02/09/2013 13.3070 -0.25859% -0.003 6.704295222E-06
171 03/09/2013 13.4394 0.99497% 0.010 9.801947809E-05
172 04/09/2013 13.3065 -0.98888% -0.010 9.876490925E-05
173 05/09/2013 13.4079 0.76203% 0.008 5.763008018E-05
174 06/09/2013 13.2413 -1.24255% -0.013 0.000156333823
175 09/09/2013 13.1471 -0.71141% -0.007 5.097290313E-05
176 10/09/2013 13.1119 -0.26774% -0.003 7.18769222E-06
177 11/09/2013 13.0938 -0.13804% -0.001 1.908208163E-06
178 12/09/2013 13.0854 -0.06415% -0.001 4.11818499E-07
179 13/09/2013 13.0540 -0.23996% -0.002 5.772028622E-06
180 17/09/2013 12.9241 -0.99510% -0.010 0.000100016295
181 18/09/2013 12.9687 0.34509% 0.003 1.186786327E-05
182 19/09/2013 12.7179 -1.93389% -0.020 0.000381354972
183 20/09/2013 12.7685 0.39786% 0.004 1.576685873E-05
184 23/09/2013 12.7846 0.12609% 0.001 1.58790556E-06
185 24/09/2013 12.8754 0.71023% 0.007 5.008665281E-05
186 25/09/2013 12.9530 0.60270% 0.006 3.610696958E-05
187 26/09/2013 13.0119 0.45472% 0.005 2.058347812E-05
188 27/09/2013 13.1450 1.02291% 0.010 0.000103574073
189 30/09/2013 13.1747 0.22594% 0.002 5.093442282E-06
190 01/10/2013 13.1294 -0.34384% -0.003 1.186343241E-05
191 02/10/2013 13.1593 0.22773% 0.002 5.174453896E-06
192 03/10/2013 13.2663 0.81311% 0.008 6.558168637E-05
193 04/10/2013 13.0976 -1.27164% -0.013 0.000163788234
194 07/10/2013 13.0959 -0.01298% 0.000 1.68488696E-08
195 08/10/2013 13.1417 0.34973% 0.003 1.218831349E-05
196 09/10/2013 13.2126 0.53950% 0.005 2.895020121E-05
197 10/10/2013 13.0913 -0.91806% -0.009 8.506432509E-05
198 11/10/2013 13.0514 -0.30478% -0.003 9.317632531E-06
199 14/10/2013 13.0492 -0.01686% 0.000 2.841871083E-08
200 15/10/2013 12.9725 -0.58778% -0.006 3.475216802E-05
201 16/10/2013 12.8816 -0.70071% -0.007 4.944615071E-05
202 17/10/2013 12.7717 -0.85315% -0.009 7.341320931E-05
203 18/10/2013 12.7988 0.21219% 0.002 4.492834881E-06
204 21/10/2013 12.9314 1.03603% 0.010 0.000106235191
205 22/10/2013 12.8713 -0.46476% -0.005 2.170102264E-05
206 23/10/2013 12.9433 0.55938% 0.006 3.111690805E-05
207 24/10/2013 12.9916 0.37317% 0.004 1.387350201E-05
208 25/10/2013 12.8693 -0.94138% -0.009 8.946066268E-05
209 28/10/2013 12.8948 0.19815% 0.002 3.918417285E-06
210 29/10/2013 12.8903 -0.03490% 0.000 1.218280766E-07
211 30/10/2013 12.8640 -0.20403% -0.002 4.171308301E-06
212 31/10/2013 13.0067 1.10930% 0.011 0.000121702749
213 01/11/2013 13.0789 0.55510% 0.006 3.064325841E-05
214 04/11/2013 12.9869 -0.70342% -0.007 4.983071694E-05
215 05/11/2013 13.1341 1.13345% 0.011 0.000127029681
216 06/11/2013 13.1388 0.03578% 0.000 1.280087601E-07
217 07/11/2013 13.1912 0.39882% 0.004 1.584243718E-05
218 08/11/2013 13.2412 0.37904% 0.004 1.43129067E-05
219 11/11/2013 13.2314 -0.07401% -0.001 5.481746997E-07
220 12/11/2013 13.1879 -0.32876% -0.003 1.084417899E-05
221 13/11/2013 13.1030 -0.64377% -0.006 4.171262148E-05
222 14/11/2013 13.0173 -0.65405% -0.007 4.305944528E-05
223 15/11/2013 12.9524 -0.49857% -0.005 2.498143189E-05
224 19/11/2013 12.8869 -0.50570% -0.005 2.570294952E-05
225 20/11/2013 12.9697 0.64251% 0.006 4.101859684E-05
226 21/11/2013 13.0617 0.70935% 0.007 4.996250574E-05
227 22/11/2013 13.0223 -0.30165% -0.003 9.126509548E-06
228 25/11/2013 13.0267 0.03379% 0.000 1.14125644E-07
229 26/11/2013 13.0745 0.36694% 0.004 1.341515845E-05
230 27/11/2013 13.0925 0.13767% 0.001 1.892767498E-06
231 28/11/2013 13.0836 -0.06798% -0.001 4.624131286E-07
232 29/11/2013 13.1101 0.20254% 0.002 4.094098972E-06
233 02/12/2013 13.2041 0.71700% 0.007 5.104333603E-05
234 03/12/2013 13.2372 0.25068% 0.003 6.26831518E-06
235 04/12/2013 13.0826 -1.16792% -0.012 0.000138014206
236 05/12/2013 13.0057 -0.58780% -0.006 3.475550688E-05
237 06/12/2013 12.9299 -0.58282% -0.006 3.416711242E-05
238 09/12/2013 12.8612 -0.53133% -0.005 2.838152903E-05
239 10/12/2013 12.8574 -0.02955% 0.000 8.732378325E-08
240 11/12/2013 12.9342 0.59732% 0.006 3.546732456E-05
241 13/12/2013 12.9515 0.13375% 0.001 1.786621268E-06
242 16/12/2013 12.9439 -0.05868% -0.001 3.445418276E-07
243 17/12/2013 12.9575 0.10507% 0.001 1.102786422E-06
244 18/12/2013 12.9937 0.27937% 0.003 7.783282726E-06
245 19/12/2013 12.9730 -0.15931% -0.002 2.541951999E-06
246 20/12/2013 12.9574 -0.12025% -0.001 1.447740955E-06
247 23/12/2013 12.9610 0.02778% 0.000 7.717002169E-08
248 24/12/2013 13.0200 0.45521% 0.005 2.062784132E-05
249 26/12/2013 13.0547 0.26651% 0.003 7.08403687E-06
250 27/12/2013 13.0765 0.16699% 0.002 2.783905392E-06
251 30/12/2013 13.0652 -0.08641% -0.001 7.473934364E-07
252 31/12/2013 13.0843 0.14619% 0.001 2.134027943E-06
253 02/01/2014 13.1011 0.12840% 0.001 1.646494366E-06
254 03/01/2014 13.0911 -0.07633% -0.001 5.830637976E-07
255 06/01/2014 13.0905 -0.00458% 0.000 2.100729457E-09
256 07/01/2014 13.0337 -0.43390% -0.004 1.890915107E-05
257 08/01/2014 13.0846 0.39053% 0.004 1.519171638E-05
258 09/01/2014 13.1403 0.42569% 0.004 1.804446483E-05
259 10/01/2014 13.0065 -1.01824% -0.010 0.000104747269
260 13/01/2014 12.9889 -0.13532% -0.001 1.833548705E-06
261 14/01/2014 13.0956 0.82147% 0.008 6.693120471E-05
262 15/01/2014 13.1689 0.55973% 0.006 3.115529879E-05
263 16/01/2014 13.2907 0.92491% 0.009 8.476062571E-05
264 17/01/2014 13.2737 -0.12791% -0.001 1.638166085E-06
265 20/01/2014 13.2420 -0.23882% -0.002 5.717059815E-06
266 21/01/2014 13.2984 0.42592% 0.004 1.806361128E-05
267 22/01/2014 13.3194 0.15791% 0.002 2.489742575E-06
268 23/01/2014 13.3722 0.39641% 0.004 1.565235732E-05
269 24/01/2014 13.4930 0.90337% 0.009 8.087598029E-05
270 27/01/2014 13.4408 -0.38687% -0.004 1.502473508E-05
271 28/01/2014 13.3104 -0.97018% -0.010 9.50463661E-05
272 29/01/2014 13.3671 0.42598% 0.004 1.806912656E-05
273 30/01/2014 13.3207 -0.34712% -0.003 1.209125218E-05
274 31/01/2014 13.3769 0.42190% 0.004 1.772513133E-05
275 04/02/2014 13.3928 0.11886% 0.001 1.411131003E-06
276 05/02/2014 13.3705 -0.16651% -0.002 2.777094088E-06
277 06/02/2014 13.2211 -1.11739% -0.011 0.000126264536
278 07/02/2014 13.3285 0.81234% 0.008 6.545718544E-05
279 10/02/2014 13.3134 -0.11329% -0.001 1.284942196E-06
280 11/02/2014 13.2916 -0.16374% -0.002 2.685632887E-06
281 12/02/2014 13.3056 0.10533% 0.001 1.108266753E-06
282 13/02/2014 13.3320 0.19841% 0.002 3.928963039E-06
283 14/02/2014 13.2477 -0.63231% -0.006 4.023628756E-05
284 17/02/2014 13.1949 -0.39856% -0.004 1.594853074E-05
285 18/02/2014 13.2261 0.23645% 0.002 5.577904585E-06
286 19/02/2014 13.2714 0.34250% 0.003 1.169088638E-05
287 20/02/2014 13.2913 0.14995% 0.001 2.245028569E-06
288 21/02/2014 13.2704 -0.15725% -0.002 2.476515259E-06
289 24/02/2014 13.2090 -0.46268% -0.005 2.150710771E-05
290 25/02/2014 13.2248 0.11962% 0.001 1.429075156E-06
291 26/02/2014 13.2992 0.56258% 0.006 3.147241737E-05
292 27/02/2014 13.3066 0.05564% 0.001 3.09435979E-07
293 28/02/2014 13.2379 -0.51629% -0.005 2.679330614E-05
294 03/03/2014 13.3201 0.62094% 0.006 3.831913235E-05
295 04/03/2014 13.2752 -0.33708% -0.003 1.14010201E-05
296 05/03/2014 13.2519 -0.17552% -0.002 3.08597574E-06
297 06/03/2014 13.1476 -0.78706% -0.008 6.24369564E-05
298 07/03/2014 13.1795 0.24263% 0.002 5.872671879E-06
299 10/03/2014 13.2248 0.34372% 0.003 1.17735635E-05
300 11/03/2014 13.2430 0.13762% 0.001 1.891329583E-06
301 12/03/2014 13.2659 0.17292% 0.002 2.985023527E-06
302 13/03/2014 13.2456 -0.15302% -0.002 2.345220253E-06
303 14/03/2014 13.2340 -0.08758% -0.001 7.676322013E-07
304 18/03/2014 13.1675 -0.50249% -0.005 2.537744615E-05
305 19/03/2014 13.1695 0.01519% 0.000 2.306680142E-08
306 20/03/2014 13.2703 0.76540% 0.008 5.813918406E-05
307 21/03/2014 13.2200 -0.37904% -0.004 1.442192564E-05
308 24/03/2014 13.2019 -0.13691% -0.001 1.877107686E-06
309 25/03/2014 13.1349 -0.50750% -0.005 2.588722265E-05
310 26/03/2014 13.1273 -0.05786% -0.001 3.349847152E-07
311 27/03/2014 13.0837 -0.33213% -0.003 1.106793475E-05
312 28/03/2014 13.0841 0.00306% 0.000 9.346425539E-10
313 31/03/2014 13.0549 -0.22317% -0.002 4.99169588E-06
314 01/04/2014 13.0313 -0.18078% -0.002 3.27387878E-06
315 02/04/2014 13.0991 0.52029% 0.005 2.692955721E-05
316 03/04/2014 13.1324 0.25422% 0.003 6.446183641E-06
317 04/04/2014 13.0345 -0.74548% -0.007 5.59918579E-05
318 07/04/2014 13.0179 -0.12735% -0.001 1.623980499E-06

Promedio 12.8632 0.00003 0.00001

Varianza 0.1212 0.00003769 0.00003750 0.00003750

0.00003750
Volatilidad Diaría 0.0061 0.0061 0.0061

Volatilidad Anual 0.0975 0.0972 0.0972

 Rendimientos
continuos ( datos
ordenados)
Tamaño de la muestra
Número ce Intervalos
Límite Inferior
-0.020 Límite Superior
-0.017 Tamaño del Intervalo
-0.015

-0.013 Distribucion de Frec

-0.013 Intervalo de Clase
Número
de
Interval Límite Limite
-0.013 o Inferior Superior
-0.013
-0.012
-0.012 1 -0.02 -0.02
-0.012 2 -0.02 -0.01
-0.011 3 -0.01 -0.01
-0.011 4 -0.01 -0.01
-0.011 5 -0.01 0.00
-0.010 6 0.00 0.00
-0.010 7 0.00 0.01
-0.010 8 0.01 0.01
-0.010 9 0.01 0.01
-0.010 10 0.01 0.02
-0.009 11 0.02 0.02
-0.009 12 0.02 0.02
-0.009 13 0.02 0.03
-0.009 14 0.03 0.03
-0.009 15 0.03 0.03
-0.009 16 0.03 0.04
-0.009 17 0.04 0.04
-0.008 Suma
-0.007
-0.007

Fix Banxico: distribuc

d
-0.007
-0.007
Fix Banxico: distribuc
-0.007 d
-0.007
-0.007 100
-0.007
-0.007 90
-0.007
80
-0.007
-0.007 70
-0.007

frecuencia absoluta
-0.006 60
-0.006
-0.006 50
-0.006
-0.006 40
-0.006
-0.006 30
-0.006
20
-0.006
-0.005 10
-0.005
-0.005 0
-0.005 6) 3) 0) 7) 4) 1)
1 77 1 42 1 07 0 71 0 36 0 01
-0.005 .0 .0 .0 .0 .0 .0
(0 (0 (0 (0 (0 (0
-0.005
-0.005
-0.005
-0.005
-0.005
-0.005
-0.005
-0.005
-0.005
-0.005
-0.004
-0.004
-0.004
-0.004
-0.004
-0.004
-0.004
-0.004
-0.004
-0.004
-0.004
-0.004
-0.004
-0.004
-0.003
-0.003
-0.003
-0.003
-0.003
-0.003
-0.003
-0.003
-0.003
-0.003
-0.003
-0.003
-0.003
-0.003
-0.003
-0.003
-0.003
-0.003
-0.003
-0.003
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.002
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
-0.001
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.001
0.002
0.002
0.002
0.002
0.002
0.002
0.002
0.002
0.002
0.002
0.002
0.002
0.002
0.002
0.002
0.002
0.002
0.002
0.002
0.002
0.002
0.002
0.003
0.003
0.003
0.003
0.003
0.003
0.003
0.003
0.003
0.003
0.003
0.003
0.003
0.003
0.004
0.004
0.004
0.004
0.004
0.004
0.004
0.004
0.004
0.004
0.004
0.004
0.004
0.004
0.004
0.004
0.004
0.004
0.004
0.004
0.004
0.005
0.005
0.005
0.005
0.005
0.005
0.005
0.006
0.006
0.006
0.006
0.006
0.006
0.006
0.006
0.006
0.006
0.006
0.006
0.006
0.007
0.007
0.007
0.007
0.007
0.007
0.007
0.007
0.007
0.008
0.008
0.008
0.008
0.008
0.008
0.008
0.008
0.009
0.009
0.009
0.010
0.010
0.010
0.010
0.010
0.011
0.011
0.011
0.011
0.011
0.011
0.011
0.011
0.013
0.013
0.013
0.015
0.017
0.041
 317
17
(0.0195)
0.0405
0.00353146

on de Frecuencias del Fix Banxico

Frecuencia
Marca Frecuencia Frecuencia Frecuencia Relativa
de Clase absoluta Relativa Acumulada Acumulada
MCi Fi fi FAi FRi

(0.01776) 2 0.01 2 0.63%

(0.01423) 5 0.02 7 2.21%
(0.01070) 15 0.05 22 6.94%
(0.00717) 27 0.09 49 15.46%
(0.00364) 59 0.19 108 34.07%
(0.00011) 95 0.30 203 64.04%
0.00343 60 0.19 263 82.97%
0.00696 33 0.10 296 93.38%
0.01049 15 0.05 311 98.11%
0.01402 4 0.01 315 99.37%
0.01755 1 0.00 316 99.68%
0.02108 0 0.00 316 99.68%
0.02461 0 0.00 316 99.68%
0.02815 0 0.00 316 99.68%
0.03168 0 0.00 316 99.68%
0.03521 0 0.00 316 99.68%
0.04 1 0.00 317 100.00%
317 1.00

nxico: distribución de frecuencia de los ren-

dimientos
nxico: distribución de frecuencia de los ren-
dimientos

) 0) 7) 4) 1) 3 6 9 2 5 8 1 5 8 1 4
23 07 71 36 01 34 69 04 40 75 10 46 81 16 52 87
1 0 0 0 0 0 0 0 0 1 0 1 0 1 0 2 0 2 0 2 0 3 0 3 0 3
.0 .0 .0 .0 0. 0. 0. 0. 0. 0. 0. 0. 0. 0. 0.
(0 (0 (0 (0
 Rendimientos
FECHA MXPEUR Rendimientos Continuos al

𝑭𝑹 𝑹𝒊 𝑹𝟐
Cuadrado

Discretos Continuos
1 31/12/2012 17.1382
2 02/01/2013 16.7895
3 03/01/2013 16.6545
4 04/01/2013 16.6616
5 07/01/2013 16.7381
6 08/01/2013 16.7405
316 03/04/2014 18.0157
317 04/04/2014 17.8651
318 07/04/2014 17.8892

Promedio

Varianza

Volatilidad Diaría

Volatilidad Anual
 Datos
Fecha IPC
Posición Ordenados
1 31/12/2012 43,705.8 37,517.2
2 02/01/2013 44,304.2 37,517.4
3 03/01/2013 44,370.6 37,901.8
4 04/01/2013 44,562.3 37,951.0
5 07/01/2013 44,625.9 38,036.5
6 08/01/2013 44,571.2 38,037.5
7 09/01/2013 44,862.5 38,534.8
8 10/01/2013 44,859.8 38,605.6
9 11/01/2013 44,888.1 38,634.8
10 14/01/2013 44,862.9 38,671.0
11 15/01/2013 44,748.1 38,689.6
12 16/01/2013 44,865.3 38,782.9
13 17/01/2013 44,943.3 38,805.3
14 18/01/2013 45,212.5 38,811.9
15 21/01/2013 45,223.9 38,814.7
16 22/01/2013 45,320.3 38,912.9
17 23/01/2013 45,443.0 38,913.0
18 24/01/2013 45,428.7 39,021.1
19 25/01/2013 45,575.9 39,023.7
20 28/01/2013 45,912.5 39,045.0
21 29/01/2013 45,908.0 39,084.4
22 30/01/2013 45,753.2 39,162.5
23 31/01/2013 45,278.1 39,176.3
24 01/02/2013 45,768.5 39,248.1
25 05/02/2013 45,688.1 39,269.3
26 06/02/2013 45,570.7 39,460.0
27 07/02/2013 45,019.2 39,480.4
28 08/02/2013 45,089.4 39,481.5
29 11/02/2013 45,063.9 39,492.4
30 12/02/2013 44,873.4 39,541.5
31 13/02/2013 44,096.3 39,549.5
32 14/02/2013 43,878.3 39,594.6
33 15/02/2013 44,153.0 39,616.2
34 18/02/2013 44,141.9 39,650.8
35 19/02/2013 44,639.8 39,654.2
36 20/02/2013 44,299.6 39,656.0
37 21/02/2013 44,136.6 39,659.5
38 22/02/2013 43,875.7 39,686.5
39 25/02/2013 43,497.2 39,686.8
40 26/02/2013 43,489.2 39,724.6
41 27/02/2013 43,772.9 39,761.3
42 28/02/2013 44,121.0 39,765.9
43 01/03/2013 43,995.7 39,773.5
44 04/03/2013 43,871.3 39,792.7
45 05/03/2013 44,017.1 39,793.0
46 06/03/2013 44,159.7 39,821.7
47 07/03/2013 43,968.6 39,864.2
48 08/03/2013 44,322.5 39,866.2
49 11/03/2013 44,013.3 39,880.9
50 12/03/2013 43,965.4 39,890.2
51 13/03/2013 43,278.1 39,891.7
52 14/03/2013 43,348.5 39,911.0
53 15/03/2013 42,605.1 39,915.1
54 19/03/2013 42,060.6 39,916.8
55 20/03/2013 42,498.0 39,999.0
56 21/03/2013 42,531.1 40,006.4
57 22/03/2013 42,686.7 40,009.9
58 25/03/2013 42,900.8 40,021.7
59 26/03/2013 43,664.7 40,048.2
60 27/03/2013 44,077.1 40,071.6
61 01/04/2013 43,932.5 40,085.5
62 02/04/2013 44,113.5 40,116.4
63 03/04/2013 43,717.6 40,117.7
64 04/04/2013 43,566.7 40,119.0
65 05/04/2013 43,244.1 40,129.0
66 08/04/2013 43,431.0 40,144.7
67 09/04/2013 43,973.2 40,185.2
68 10/04/2013 44,380.8 40,199.5
69 11/04/2013 44,408.4 40,218.3
70 12/04/2013 44,004.3 40,221.0
71 15/04/2013 42,984.4 40,226.3
72 16/04/2013 43,223.7 40,232.7
73 17/04/2013 42,610.7 40,236.6
74 18/04/2013 42,460.2 40,240.2
75 19/04/2013 42,808.2 40,245.3
76 22/04/2013 42,914.2 40,246.7
77 23/04/2013 43,113.6 40,280.1
78 24/04/2013 42,294.9 40,288.8
79 25/04/2013 42,547.5 40,304.5
80 26/04/2013 41,898.2 40,306.7
81 29/04/2013 41,910.5 40,309.0
82 30/04/2013 42,263.5 40,322.3
83 02/05/2013 42,090.0 40,329.8
84 03/05/2013 42,602.1 40,341.9
85 06/05/2013 42,198.0 40,345.8
86 07/05/2013 42,406.7 40,355.3
87 08/05/2013 42,102.1 40,412.7
88 09/05/2013 41,682.6 40,419.9
89 10/05/2013 41,741.5 40,421.9
90 13/05/2013 41,766.9 40,451.2
91 14/05/2013 41,925.1 40,461.6
92 15/05/2013 41,905.2 40,470.0
93 16/05/2013 41,761.1 40,479.8
94 17/05/2013 41,806.7 40,490.0
95 20/05/2013 41,080.4 40,505.3
96 21/05/2013 40,548.4 40,521.3
97 22/05/2013 40,119.0 40,525.7
98 23/05/2013 40,505.3 40,548.4
99 24/05/2013 40,521.3 40,552.6
100 27/05/2013 40,144.7 40,563.1
101 28/05/2013 40,764.0 40,579.1
102 29/05/2013 40,639.0 40,595.7
103 30/05/2013 40,984.5 40,598.3
104 31/05/2013 41,588.3 40,623.1
105 03/06/2013 41,094.8 40,623.3
106 04/06/2013 40,750.4 40,639.0
107 05/06/2013 40,226.3 40,643.3
108 06/06/2013 40,579.1 40,660.9
109 07/06/2013 40,232.7 40,671.6
110 10/06/2013 40,721.4 40,689.9
111 11/06/2013 39,890.2 40,690.1
112 12/06/2013 39,480.4 40,710.9
113 13/06/2013 39,481.5 40,721.4
114 14/06/2013 39,269.3 40,735.5
115 17/06/2013 39,549.5 40,750.4
116 18/06/2013 39,460.0 40,752.1
117 19/06/2013 39,045.0 40,759.6
118 20/06/2013 37,517.2 40,764.0
119 21/06/2013 38,036.5 40,785.7
120 24/06/2013 37,517.4 40,790.2
121 25/06/2013 37,901.8 40,795.6
122 26/06/2013 38,805.3 40,813.5
123 27/06/2013 39,650.8 40,828.9
124 28/06/2013 40,623.3 40,832.5
125 01/07/2013 41,176.8 40,837.9
126 02/07/2013 40,832.5 40,839.0
127 03/07/2013 40,828.9 40,841.1
128 04/07/2013 41,200.4 40,863.4
129 05/07/2013 40,623.1 40,879.8
130 08/07/2013 40,071.6 40,882.1
131 09/07/2013 40,221.0 40,900.5
132 10/07/2013 39,999.0 40,903.7
133 11/07/2013 40,479.8 40,909.5
134 12/07/2013 40,329.8 40,925.1
135 15/07/2013 40,322.3 40,948.4
136 16/07/2013 39,659.5 40,953.9
137 17/07/2013 40,240.2 40,975.4
138 18/07/2013 40,245.3 40,979.8
139 19/07/2013 39,891.7 40,984.5
140 22/07/2013 40,117.7 40,998.4
141 23/07/2013 40,790.2 41,002.7
142 24/07/2013 40,839.0 41,007.4
143 25/07/2013 40,752.1 41,008.3
144 26/07/2013 41,064.6 41,013.7
145 29/07/2013 40,341.9 41,034.1
146 30/07/2013 40,236.6 41,038.7
147 31/07/2013 40,837.9 41,050.1
148 01/08/2013 41,863.8 41,064.6
149 02/08/2013 42,051.6 41,079.6
150 05/08/2013 41,918.4 41,080.4
151 06/08/2013 41,914.8 41,094.8
152 07/08/2013 42,246.5 41,122.5
153 08/08/2013 42,712.1 41,125.0
154 09/08/2013 42,648.7 41,137.7
155 12/08/2013 42,124.8 41,176.8
156 13/08/2013 42,366.5 41,199.0
157 14/08/2013 42,430.1 41,200.4
158 15/08/2013 42,155.3 41,210.0
159 16/08/2013 42,049.7 41,226.0
160 19/08/2013 41,484.3 41,284.4
161 20/08/2013 41,825.4 41,300.7
162 21/08/2013 41,458.2 41,314.7
163 22/08/2013 41,007.4 41,327.6
164 23/08/2013 40,925.1 41,335.3
165 26/08/2013 40,419.9 41,458.2
166 27/08/2013 39,656.0 41,484.3
167 28/08/2013 39,248.1 41,515.5
168 29/08/2013 39,162.5 41,526.0
169 30/08/2013 39,492.4 41,531.8
170 02/09/2013 40,129.0 41,585.5
171 03/09/2013 39,541.5 41,588.3
172 04/09/2013 39,773.5 41,640.5
173 05/09/2013 39,686.5 41,682.6
174 06/09/2013 39,915.1 41,724.0
175 09/09/2013 40,953.9 41,733.0
176 10/09/2013 41,733.0 41,741.5
177 11/09/2013 41,640.5 41,752.3
178 12/09/2013 40,785.7 41,758.6
179 13/09/2013 41,122.5 41,761.1
180 17/09/2013 41,137.7 41,766.9
181 18/09/2013 41,902.2 41,778.6
182 19/09/2013 41,752.3 41,806.7
183 20/09/2013 41,226.0 41,825.4
184 23/09/2013 41,314.7 41,838.6
185 24/09/2013 41,210.0 41,863.8
186 25/09/2013 41,724.0 41,872.6
187 26/09/2013 41,327.6 41,876.9
188 27/09/2013 40,903.7 41,884.8
189 30/09/2013 40,185.2 41,898.2
190 01/10/2013 41,335.3 41,902.2
191 02/10/2013 41,300.7 41,905.2
192 03/10/2013 40,841.1 41,910.1
193 04/10/2013 40,909.5 41,910.5
194 07/10/2013 40,451.2 41,911.3
195 08/10/2013 39,916.8 41,914.8
196 09/10/2013 39,866.2 41,918.4
197 10/10/2013 40,490.0 41,925.1
198 11/10/2013 40,975.4 41,925.5
199 14/10/2013 40,882.1 41,976.4
200 15/10/2013 40,218.3 42,003.7
201 16/10/2013 40,355.3 42,049.7
202 17/10/2013 40,199.5 42,051.6
203 18/10/2013 40,412.7 42,054.0
204 21/10/2013 40,345.8 42,060.6
205 22/10/2013 40,813.5 42,062.8
206 23/10/2013 40,552.6 42,065.0
207 24/10/2013 40,246.7 42,079.9
208 25/10/2013 40,671.6 42,090.0
209 28/10/2013 41,125.0 42,102.1
210 29/10/2013 41,284.4 42,124.8
211 30/10/2013 41,050.1 42,138.6
212 31/10/2013 41,038.7 42,155.3
213 01/11/2013 41,079.6 42,158.6
214 04/11/2013 41,013.7 42,160.4
215 05/11/2013 40,304.5 42,172.7
216 06/11/2013 40,280.1 42,183.8
217 07/11/2013 40,009.9 42,188.5
218 08/11/2013 39,864.2 42,198.0
219 11/11/2013 39,686.8 42,198.3
220 12/11/2013 39,594.6 42,246.5
221 13/11/2013 39,765.9 42,263.5
222 14/11/2013 40,306.7 42,289.2
223 15/11/2013 41,034.1 42,294.9
224 19/11/2013 40,643.3 42,304.6
225 20/11/2013 40,795.6 42,366.5
226 21/11/2013 40,998.4 42,406.7
227 22/11/2013 41,199.0 42,430.1
228 25/11/2013 40,948.4 42,439.8
229 26/11/2013 41,002.7 42,458.5
230 27/11/2013 41,872.6 42,460.2
231 28/11/2013 42,160.4 42,490.1
232 29/11/2013 42,499.1 42,498.0
233 02/12/2013 42,138.6 42,499.1
234 03/12/2013 41,876.9 42,508.0
235 04/12/2013 42,003.7 42,511.3
236 05/12/2013 41,910.1 42,531.1
237 06/12/2013 41,925.5 42,540.3
238 09/12/2013 42,289.2 42,547.5
239 10/12/2013 42,490.1 42,585.7
240 11/12/2013 42,304.6 42,602.1
241 13/12/2013 41,884.8 42,605.1
242 16/12/2013 42,054.0 42,610.7
243 17/12/2013 41,758.6 42,648.7
244 18/12/2013 42,079.9 42,686.7
245 19/12/2013 42,198.3 42,712.1
246 20/12/2013 42,183.8 42,727.1
247 23/12/2013 42,508.0 42,753.2
248 24/12/2013 42,585.7 42,808.2
249 26/12/2013 42,540.3 42,900.8
250 27/12/2013 42,753.2 42,914.2
251 30/12/2013 42,958.8 42,958.8
252 31/12/2013 42,727.1 42,984.4
253 02/01/2014 42,188.5 43,113.6
254 03/01/2014 42,065.0 43,223.7
255 06/01/2014 41,526.0 43,244.1
256 07/01/2014 41,778.6 43,278.1
257 08/01/2014 41,515.5 43,348.5
258 09/01/2014 41,585.5 43,431.0
259 10/01/2014 42,458.5 43,489.2
260 13/01/2014 42,158.6 43,497.2
261 14/01/2014 42,439.8 43,566.7
262 15/01/2014 42,511.3 43,664.7
263 16/01/2014 42,172.7 43,705.8
264 17/01/2014 41,911.3 43,717.6
265 20/01/2014 41,976.4 43,772.9
266 21/01/2014 41,838.6 43,871.3
267 22/01/2014 42,062.8 43,875.7
268 23/01/2014 41,531.8 43,878.3
269 24/01/2014 40,979.8 43,932.5
270 27/01/2014 40,863.4 43,965.4
271 28/01/2014 40,660.9 43,968.6
272 29/01/2014 40,689.9 43,973.2
273 30/01/2014 41,008.3 43,995.7
274 31/01/2014 40,879.8 44,004.3
275 04/02/2014 40,085.5 44,013.3
276 05/02/2014 39,880.9 44,017.1
277 06/02/2014 40,288.8 44,077.1
278 07/02/2014 40,525.7 44,096.3
279 10/02/2014 40,116.4 44,113.5
280 11/02/2014 40,759.6 44,121.0
281 12/02/2014 40,690.1 44,136.6
282 13/02/2014 40,309.0 44,141.9
283 14/02/2014 40,710.9 44,153.0
284 17/02/2014 40,735.5 44,159.7
285 18/02/2014 40,421.9 44,299.6
286 19/02/2014 40,006.4 44,304.2
287 20/02/2014 39,654.2 44,322.5
288 21/02/2014 39,724.6 44,370.6
289 24/02/2014 39,792.7 44,380.8
290 25/02/2014 39,023.7 44,408.4
291 26/02/2014 38,605.6 44,562.3
292 27/02/2014 38,912.9 44,571.2
293 28/02/2014 38,782.9 44,625.9
294 03/03/2014 38,534.8 44,639.8
295 04/03/2014 39,084.4 44,748.1
296 05/03/2014 39,021.1 44,859.8
297 06/03/2014 39,176.3 44,862.5
298 07/03/2014 38,913.0 44,862.9
299 10/03/2014 38,671.0 44,865.3
300 11/03/2014 38,689.6 44,873.4
301 12/03/2014 38,634.8 44,888.1
302 13/03/2014 38,037.5 44,943.3
303 14/03/2014 37,951.0 45,019.2
304 18/03/2014 38,814.7 45,063.9
305 19/03/2014 38,811.9 45,089.4
306 20/03/2014 39,616.2 45,212.5
307 21/03/2014 40,021.7 45,223.9
308 24/03/2014 39,821.7 45,278.1
309 25/03/2014 39,793.0 45,320.3
310 26/03/2014 39,761.3 45,428.7
311 27/03/2014 39,911.0 45,443.0
312 28/03/2014 40,048.2 45,570.7
313 31/03/2014 40,461.6 45,575.9
314 01/04/2014 40,470.0 45,688.1
315 02/04/2014 40,900.5 45,753.2
316 03/04/2014 40,563.1 45,768.5
317 04/04/2014 40,598.3 45,908.0
318 07/04/2014 40,595.7 45,912.5
Tamaño de la muestra 318
k% 5%
Posición del valor al k% 15.9
Valor de E 15
Valor de E+1 16
Valor de D 0.9
Valor al Percentil al k% 38,912.9 Con datos ordenados. Se calcula, sin ser exacto
Valor al Percentil al k%. Excel 38,913.0 Con datos sin ordenar. Función PERCENTIL. To
Valor al Percentil al k%. Excel 38,908.0 Con datos sin ordenar. Función PERC
Valor al Percentil al k%. Excel 38,913.0 Con datos sin ordenar. Función PERCENTIL.INC
41961.79 42455.63
rdenados. Se calcula, sin ser exacto.
in ordenar. Función PERCENTIL. Toma el valoR E+1
s sin ordenar. Función PERCENTIL.EXE. INTERPOLA, de acuerdo al valor de posicón al k%
in ordenar. Función PERCENTIL.INC. Toma el valoR E+1
 Datos
Posición Fecha MXPUSD Ordenados
1 31/12/2012 12.97
2 02/01/2013 12.75
3 03/01/2013 12.74
4 04/01/2013 12.76
5 07/01/2013 12.77
6 08/01/2013 12.80
7 09/01/2013 12.75
8 10/01/2013 12.66
9 11/01/2013 12.65
10 14/01/2013 12.65
11 15/01/2013 12.65
12 16/01/2013 12.63
13 17/01/2013 12.59
14 18/01/2013 12.66
15 21/01/2013 12.71
16 22/01/2013 12.68
17 23/01/2013 12.66
18 24/01/2013 12.63
19 25/01/2013 12.70
20 28/01/2013 12.78
21 29/01/2013 12.71
22 30/01/2013 12.74
23 31/01/2013 12.71
24 01/02/2013 12.64
25 05/02/2013 12.63
26 06/02/2013 12.67
27 07/02/2013 12.71
28 08/02/2013 12.73
29 11/02/2013 12.77
30 12/02/2013 12.74
31 13/02/2013 12.71
32 14/02/2013 12.70
33 15/02/2013 12.69
34 18/02/2013 12.70
35 19/02/2013 12.69
36 20/02/2013 12.67
37 21/02/2013 12.77
38 22/02/2013 12.75
39 25/02/2013 12.70
40 26/02/2013 12.87
41 27/02/2013 12.83
42 28/02/2013 12.78
43 01/03/2013 12.80
44 04/03/2013 12.78
45 05/03/2013 12.74
46 06/03/2013 12.73
47 07/03/2013 12.78
48 08/03/2013 12.67
49 11/03/2013 12.53
50 12/03/2013 12.46
51 13/03/2013 12.40
52 14/03/2013 12.45
53 15/03/2013 12.44
54 19/03/2013 12.43
55 20/03/2013 12.39
56 21/03/2013 12.38
57 22/03/2013 12.37
58 25/03/2013 12.36
59 26/03/2013 12.35
60 27/03/2013 12.36
61 01/04/2013 12.34
62 02/04/2013 12.27
63 03/04/2013 12.33
64 04/04/2013 12.32
65 05/04/2013 12.24
66 08/04/2013 12.16
67 09/04/2013 12.13
68 10/04/2013 12.11
69 11/04/2013 12.07
70 12/04/2013 12.08
71 15/04/2013 12.17
72 16/04/2013 12.17
73 17/04/2013 12.24
74 18/04/2013 12.25
75 19/04/2013 12.23
76 22/04/2013 12.32
77 23/04/2013 12.25
78 24/04/2013 12.28
79 25/04/2013 12.12
80 26/04/2013 12.16
81 29/04/2013 12.13
82 30/04/2013 12.15
83 02/05/2013 12.18
84 03/05/2013 12.09
85 06/05/2013 12.11
86 07/05/2013 12.07
87 08/05/2013 12.04
88 09/05/2013 11.98
89 10/05/2013 12.11
90 13/05/2013 12.14
91 14/05/2013 12.15
92 15/05/2013 12.23
93 16/05/2013 12.24
94 17/05/2013 12.32
95 20/05/2013 12.33
96 21/05/2013 12.34
97 22/05/2013 12.31
98 23/05/2013 12.48
99 24/05/2013 12.52
100 27/05/2013 12.48
101 28/05/2013 12.53
102 29/05/2013 12.63
103 30/05/2013 12.78
104 31/05/2013 12.80
105 03/06/2013 12.79
106 04/06/2013 12.73
107 05/06/2013 12.82
108 06/06/2013 12.91
109 07/06/2013 12.72
110 10/06/2013 12.86
111 11/06/2013 12.88
112 12/06/2013 12.84
113 13/06/2013 12.78
114 14/06/2013 12.69
115 17/06/2013 12.74
116 18/06/2013 12.88
117 19/06/2013 12.87
118 20/06/2013 13.40
119 21/06/2013 13.40
120 24/06/2013 13.40
121 25/06/2013 13.24
122 26/06/2013 13.19
123 27/06/2013 13.02
124 28/06/2013 13.03
125 01/07/2013 12.91
126 02/07/2013 12.99
127 03/07/2013 13.04
128 04/07/2013 12.89
129 05/07/2013 13.06
130 08/07/2013 12.93
131 09/07/2013 12.87
132 10/07/2013 12.95
133 11/07/2013 12.86
134 12/07/2013 12.82
135 15/07/2013 12.74
136 16/07/2013 12.63
137 17/07/2013 12.55
138 18/07/2013 12.50
139 19/07/2013 12.55
140 22/07/2013 12.51
141 23/07/2013 12.51
142 24/07/2013 12.63
143 25/07/2013 12.65
144 26/07/2013 12.71
145 29/07/2013 12.73
146 30/07/2013 12.76
147 31/07/2013 12.85
148 01/08/2013 12.81
149 02/08/2013 12.69
150 05/08/2013 12.68
151 06/08/2013 12.64
152 07/08/2013 12.70
153 08/08/2013 12.65
154 09/08/2013 12.59
155 12/08/2013 12.57
156 13/08/2013 12.75
157 14/08/2013 12.73
158 15/08/2013 12.86
159 16/08/2013 12.87
160 19/08/2013 13.01
161 20/08/2013 13.01
162 21/08/2013 13.14
163 22/08/2013 13.15
164 23/08/2013 13.00
165 26/08/2013 13.11
166 27/08/2013 13.34
167 28/08/2013 13.25
168 29/08/2013 13.31
169 30/08/2013 13.34
170 02/09/2013 13.31
171 03/09/2013 13.44
172 04/09/2013 13.31
173 05/09/2013 13.41
174 06/09/2013 13.24
175 09/09/2013 13.15
176 10/09/2013 13.11
177 11/09/2013 13.09
178 12/09/2013 13.09
179 13/09/2013 13.05
180 17/09/2013 12.92
181 18/09/2013 12.97
182 19/09/2013 12.72
183 20/09/2013 12.77
184 23/09/2013 12.78
185 24/09/2013 12.88
186 25/09/2013 12.95
187 26/09/2013 13.01
188 27/09/2013 13.15
189 30/09/2013 13.17
190 01/10/2013 13.13
191 02/10/2013 13.16
192 03/10/2013 13.27
193 04/10/2013 13.10
194 07/10/2013 13.10
195 08/10/2013 13.14
196 09/10/2013 13.21
197 10/10/2013 13.09
198 11/10/2013 13.05
199 14/10/2013 13.05
200 15/10/2013 12.97
201 16/10/2013 12.88
202 17/10/2013 12.77
203 18/10/2013 12.80
204 21/10/2013 12.93
205 22/10/2013 12.87
206 23/10/2013 12.94
207 24/10/2013 12.99
208 25/10/2013 12.87
209 28/10/2013 12.89
210 29/10/2013 12.89
211 30/10/2013 12.86
212 31/10/2013 13.01
213 01/11/2013 13.08
214 04/11/2013 12.99
215 05/11/2013 13.13
216 06/11/2013 13.14
217 07/11/2013 13.19
218 08/11/2013 13.24
219 11/11/2013 13.23
220 12/11/2013 13.19
221 13/11/2013 13.10
222 14/11/2013 13.02
223 15/11/2013 12.95
224 19/11/2013 12.89
225 20/11/2013 12.97
226 21/11/2013 13.06
227 22/11/2013 13.02
228 25/11/2013 13.03
229 26/11/2013 13.07
230 27/11/2013 13.09
231 28/11/2013 13.08
232 29/11/2013 13.11
233 02/12/2013 13.20
234 03/12/2013 13.24
235 04/12/2013 13.08
236 05/12/2013 13.01
237 06/12/2013 12.93
238 09/12/2013 12.86
239 10/12/2013 12.86
240 11/12/2013 12.93
241 13/12/2013 12.95
242 16/12/2013 12.94
243 17/12/2013 12.96
244 18/12/2013 12.99
245 19/12/2013 12.97
246 20/12/2013 12.96
247 23/12/2013 12.96
248 24/12/2013 13.02
249 26/12/2013 13.05
250 27/12/2013 13.08
251 30/12/2013 13.07
252 31/12/2013 13.08
253 02/01/2014 13.10
254 03/01/2014 13.09
255 06/01/2014 13.09
256 07/01/2014 13.03
257 08/01/2014 13.08
258 09/01/2014 13.14
259 10/01/2014 13.01
260 13/01/2014 12.99
261 14/01/2014 13.10
262 15/01/2014 13.17
263 16/01/2014 13.29
264 17/01/2014 13.27
265 20/01/2014 13.24
266 21/01/2014 13.30
267 22/01/2014 13.32
268 23/01/2014 13.37
269 24/01/2014 13.49
270 27/01/2014 13.44
271 28/01/2014 13.31
272 29/01/2014 13.37
273 30/01/2014 13.32
274 31/01/2014 13.38
275 04/02/2014 13.39
276 05/02/2014 13.37
277 06/02/2014 13.22
278 07/02/2014 13.33
279 10/02/2014 13.31
280 11/02/2014 13.29
281 12/02/2014 13.31
282 13/02/2014 13.33
283 14/02/2014 13.25
284 17/02/2014 13.19
285 18/02/2014 13.23
286 19/02/2014 13.27
287 20/02/2014 13.29
288 21/02/2014 13.27
289 24/02/2014 13.21
290 25/02/2014 13.22
291 26/02/2014 13.30
292 27/02/2014 13.31
293 28/02/2014 13.24
294 03/03/2014 13.32
295 04/03/2014 13.28
296 05/03/2014 13.25
297 06/03/2014 13.15
298 07/03/2014 13.18
299 10/03/2014 13.22
300 11/03/2014 13.24
301 12/03/2014 13.27
302 13/03/2014 13.25
303 14/03/2014 13.23
304 18/03/2014 13.17
305 19/03/2014 13.17
306 20/03/2014 13.27
307 21/03/2014 13.22
308 24/03/2014 13.20
309 25/03/2014 13.13
310 26/03/2014 13.13
311 27/03/2014 13.08
312 28/03/2014 13.08
313 31/03/2014 13.05
314 01/04/2014 13.03
315 02/04/2014 13.10
316 03/04/2014 13.13
317 04/04/2014 13.03
318 07/04/2014 13.02
Tamaño de la muestra
k%
Posición del valor al k%
Valor de E
Valor de E+1
Valor de D
Valor al Percentil al k% Con datos ordenados. Se calcula, sin ser exacto
Valor al Percentil al k%. Excel Con datos sin ordenar. Función PERCENTIL. To
Valor al Percentil al k%. Excel Con datos sin ordenar. Función PERC
Valor al Percentil al k%. Excel Con datos sin ordenar. Función PERCENTIL.INC
41961.79 42455.63
rdenados. Se calcula, sin ser exacto.
in ordenar. Función PERCENTIL. Toma el valoR E+1
s sin ordenar. Función PERCENTIL.EXE. INTERPOLA, de acuerdo al valor de posicón al k%
in ordenar. Función PERCENTIL.INC. Toma el valoR E+1
 𝑭𝟏𝒊 𝑭𝟐 𝑹𝟏𝒊
FECHA MXPUSD MXPEUR Rendimientos Continuos
𝒊

MXPUSD
1 31/12/2012 12.966 17.138
2 02/01/2013 12.749 16.790 -1.68780%
3 03/01/2013 12.743 16.654 -0.04550%
4 04/01/2013 12.760 16.662 0.13097%
5 07/01/2013 12.768 16.738 0.06424%
6 08/01/2013 12.802 16.741 0.26281%
316 03/04/2014 13.132 18.016 0.25389%
317 04/04/2014 13.035 17.865 -0.74828%
318 07/04/2014 13.018 17.889 -0.12744%

Promedio 0.00127%

Varianza 0.000037

Volatilidad Diaría 0.61237%

Covarianza 0.000032618

Correlación 0.768815099
Correlación. Excel 0.768815099

Matriz de Varianza-Covarianza Bivariada. Función Excel

MXPUSD MXPEUR
MXPUSD 0.0000375 0.000032618
MXPEUR 0.000032618 0.0000480

Matriz de Correlación Bivariada. Función Excel

MXPUSD MXPEUR
MXPUSD 1.0000000 0.768815099
MXPEUR 0.768815099 1.0000000
 Rendimientos Continuos al

𝑹𝟐 ൫𝑹𝟏𝒊 ൯
𝟐
൫𝑹𝟐 ൯
𝟐
dimientos Continuos Cuadrado
𝒊 𝒊
MXPEUR MXPUSD MXPEUR

-2.05539% 0.0002848659 0.0004224645

-0.80774% 0.0000002071 0.0000652439
0.04293% 0.0000017152 0.0000001843
0.45787% 0.0000004127 0.0000209642
0.01459% 0.0000069071 0.0000000213
-0.05543% 0.0000064462 0.0000003073
-0.83944% 0.0000559919 0.0000704651
0.13488% 0.0000016240 0.0000018192

0.01353%

0.000048 0.00003750 0.00004802

0.00003750 0.00004802
0.69282% 0.61237% 0.69295%

0.000032620

0.768706907

Matriz de Varianza-Covarianza Bivariada. Media Cero

MXPUSD MXPEUR
MXPUSD 0.00003750 0.000032620
MXPEUR 0.000032620 0.00004802

Matriz de Correlación Bivariada. Media Cero

MXPUSD MXPEUR
MXPUSD 1.0000000 0.768706907
MXPEUR 0.768706907 1.0000000
 𝑭𝒊
𝟏
𝑭𝟐 𝑹𝟏𝒊
FECHA IPC NAFTRAC Rendimientos Continuos
𝒊

MXPUSD
1 31/12/2012 43,705.8 43.690
2 02/01/2013 44,304.2 44.290
3 03/01/2013 44,370.6 44.340
4 04/01/2013 44,562.3 44.520
5 07/01/2013 44,625.9 44.610
6 08/01/2013 44,571.2 44.540
316 03/04/2014 40,563.1 40.520
317 04/04/2014 40,598.3 40.590
318 07/04/2014 40,595.7 40.570

Promedio

Varianza

Volatilidad Diaría

Covarianza

Correlación
Correlación. Excel

Matriz de Varianza-Covarianza Bivariada. Función Excel

MXPUSD MXPEUR
MXPUSD #DIV/0! #VALUE!
MXPEUR #VALUE! #DIV/0!

Matriz de Correlación Bivariada. Función Excel

MXPUSD MXPEUR
MXPUSD #VALUE! #VALUE!
MXPEUR #VALUE! #VALUE!
 Rendimientos Continuos al

𝑹𝟐 ൫𝑹𝟏𝒊 ൯
𝟐
൫𝑹𝟐 ൯
𝟐
dimientos Continuos Cuadrado
𝒊 𝒊
MXPEUR IPC NAFTRAC

Matriz de Varianza-Covarianza Bivariada. Media Cero

MXPUSD MXPEUR
MXPUSD - -
MXPEUR - -

Matriz de Correlación Bivariada. Media Cero

MXPUSD MXPEUR
MXPUSD 1.0000000 #DIV/0!
MXPEUR #DIV/0! 1.0000000
 𝑭𝟏𝒊 𝑭𝟐 𝑭𝟑
FECHA IPC AMX NAFTRAC
𝒊 𝒊

1 31/12/2012 43,705.8 14.900 43.690

2 02/01/2013 44,304.2 14.900 44.290
3 03/01/2013 44,370.6 15.500 44.340
4 04/01/2013 44,562.3 15.450 44.520
5 07/01/2013 44,625.9 15.450 44.610
6 08/01/2013 44,571.2 15.510 44.540
316 03/04/2014 40,563.1 13.100 40.520
317 04/04/2014 40,598.3 13.500 40.590
318 07/04/2014 40,595.7 13.400 40.570

Promedio

Varianza

Volatilidad Diaría

Volatilidad Anual

Coeficiente de variación

Matriz de Varianza-Covarianza Multivariada. Función Excel

IPC AMX NAFTRAC
IPC 0.00009485 0.00007661 0.00009410
AMX 0.00007661 0.00036563 0.00007444
NAFTRAC 0.00009410 0.00007444 0.00009425

Matriz de Correlación Multivariada. Función Excel

IPC AMX NAFTRAC
IPC 1.00000000 0.41136931 0.99523453
AMX 0.41136931 0.00036563 0.40101750
NAFTRAC 0.99523453 0.40101750 1.00000000
Matriz de Volatilidades
IPC AMX NAFTRAC
IPC 0.0097392 - -
AMX - 0.0191214 -
NAFTRAC - - 0.0097080

Matriz de Varianza-Covarianza Multivariada. Función Excel

IPC AMX NAFTRAC
IPC 0.00009485 0.00007661 0.00009410
AMX 0.00007661 0.00000013 0.00007444
NAFTRAC 0.00009410 0.00007444 0.00009425
𝑹𝟏𝒊 𝑹𝟐 𝑹𝟑
Rendimientos Continuos
𝒊 𝒊

IPC AMX NAFTRAC

1.35973% 0.00000% 1.36397%

0.14992% 3.94788% 0.11283%
0.43109% -0.32310% 0.40513%
0.14262% 0.00000% 0.20195%
-0.12272% 0.38760% -0.15704%
-0.82852% -0.76046% -0.93344%
0.08694% 3.00775% 0.17261%
-0.00650% -0.74350% -0.04929%

-0.02329% -0.03347% -0.02337%

0.00009485 0.00036563 0.00009425 0.00009491 0.00036574

0.97392% 1.91214% 0.97080% 0.97420% 1.91243%

15.460% 30.354% 15.411% 15.465% 30.359%

(41.82) (57.13) (41.54)

Matriz de Varianza-Covarianza Multivariada. Media Cero

IPC AMX NAFTRAC
IPC 0.0000949 0.0000767 0.0000942
AMX 0.0000767 0.0003657 0.0000745
NAFTRAC 0.0000942 0.0000745 0.0000943

Matriz de Correlación Multivariada. Media Cero

IPC AMX NAFTRAC
IPC 1.00000000 0.41160790 0.99523727
AMX 0.41160790 1.00000000 0.40126194
NAFTRAC 0.99523727 0.40126194 1.00000000
Matriz de Volatilidades. Media Cero
IPC AMX NAFTRAC
IPC 0.00974196 - -
AMX - 0.01912430 -
NAFTRAC - - 0.00971085

Matriz de Varianza-Covarianza Multivariada. Media Cero

IPC AMX NAFTRAC
IPC 0.00009491 0.00007669 0.00009415
AMX 0.00007669 0.00036574 0.00007452
NAFTRAC 0.00009415 0.00007452 0.00009430
0.00009430

0.97109%

15.415%
 𝑭𝟏𝒊 𝑭𝟐 𝑭𝟑
FECHA IPC AMX NAFTRAC
𝒊 𝒊

1 31/12/2012 43,705.8 14.900 43.690

2 02/01/2013 44,304.2 14.900 44.290
3 03/01/2013 44,370.6 15.500 44.340
4 04/01/2013 44,562.3 15.450 44.520
5 07/01/2013 44,625.9 15.450 44.610
6 08/01/2013 44,571.2 15.510 44.540
316 03/04/2014 40,563.1 13.100 40.520
317 04/04/2014 40,598.3 13.500 40.590
318 07/04/2014 40,595.7 13.400 40.570

Promedio

Varianza

Volatilidad Diaría

Volatilidad Anual

Coeficiente de variación

Matriz de Varianza-Covarianza Multivariada. Función Excel

IPC AMX NAFTRAC
IPC
AMX
NAFTRAC
BIMBO
MXPUSD
MXPEUR

Matriz de Correlación Multivariada. Función Excel

IPC AMX NAFTRAC
IPC
AMX
 NAFTRAC
BIMBO
MXPUSD
MXPEUR

Matriz de Volatilidades
IPC AMX NAFTRAC
IPC
AMX
NAFTRAC
BIMBO
MXPUSD
MXPEUR

Matriz de Varianza-Covarianza Multivariada. Función Excel

IPC AMX NAFTRAC
IPC
AMX
NAFTRAC
BIMBO
MXPUSD
MXPEUR
𝑭𝒊
𝟒
𝑭𝟓𝒊 𝑭𝟔 𝑹𝟏𝒊
BIMBO MXPUSD MXPEUR R
𝒊

IPC
33.470 12.966 17.138
33.810 12.749 16.790
33.770 12.743 16.654
34.110 12.760 16.662
33.830 12.768 16.738
33.680 12.802 16.741
35.420 13.132 18.016
35.340 13.035 17.865
35.830 13.018 17.889

BIMBO MXPUSD MXPEUR

BIMBO MXPUSD MXPEUR

BIMBO MXPUSD MXPEUR

BIMBO MXPUSD MXPEUR

 𝑹𝟐 𝑹𝟑 𝑹𝟒 𝑹𝟓𝒊 𝑹𝟔
Rendimientos Continuos
𝒊 𝒊 𝒊 𝒊

AMX NAFTRAC BIMBO MXPUSD MXPEUR

Matriz de Varianza-Covarianza Multivariada. Media Cero

IPC AMX NAFTRAC BIMBO
IPC
AMX
NAFTRAC
BIMBO
MXPUSD
MXPEUR

Matriz de Correlación Multivariada. Media Cero

IPC AMX NAFTRAC BIMBO
IPC
AMX
 NAFTRAC
BIMBO
MXPUSD
MXPEUR

Matriz de Volatilidades. Media Cero

IPC AMX NAFTRAC BIMBO
IPC
AMX
NAFTRAC
BIMBO
MXPUSD
MXPEUR

Matriz de Varianza-Covarianza Multivariada. Media Cero

IPC AMX NAFTRAC BIMBO
IPC
AMX
NAFTRAC
BIMBO
MXPUSD
MXPEUR
MXPUSD MXPEUR

MXPUSD MXPEUR
MXPUSD MXPEUR

MXPUSD MXPEUR
 media móvil
media móvil
t FECHA Fix Banxico centrada (7
(15 días)
días)
1 31/12/2012 12.9658
2 02/01/2013 12.7488
3 03/01/2013 12.7430
4 04/01/2013 12.7597
5 07/01/2013 12.7679
6 08/01/2013 12.8015 12.73775
7 09/01/2013 12.7503 12.70025
8 10/01/2013 12.6555 12.715 12.686264285714
9 11/01/2013 12.6478 12.696 12.683735714286
10 14/01/2013 12.6533 12.690 12.678507142857
11 15/01/2013 12.6526 12.683 12.669285714286
12 16/01/2013 12.6305 12.679 12.652235714286
13 17/01/2013 12.5868 12.680 12.650378571429
14 18/01/2013 12.6555 12.674 12.668071428571
15 21/01/2013 12.7098 12.673 12.674628571429
16 22/01/2013 12.6817 12.677 12.677435714286
17 23/01/2013 12.6616 12.676 12.6777
18 24/01/2013 12.6286 12.674 12.680907142857
19 25/01/2013 12.6993 12.675 12.694778571429
20 28/01/2013 12.7802 12.681 12.696564285714
21 29/01/2013 12.7134 12.690 12.6938
22 30/01/2013 12.7408 12.698 12.697014285714
23 31/01/2013 12.7094 12.700 12.697435714286
24 01/02/2013 12.6377 12.702 12.699421428571
25 05/02/2013 12.6294 12.704 12.70235
26 06/02/2013 12.6664 12.708 12.702285714286
27 07/02/2013 12.7105 12.708 12.704964285714
28 08/02/2013 12.7307 12.702 12.70605
29 11/02/2013 12.7706 12.699 12.704878571429
30 12/02/2013 12.7364 12.701 12.702928571429
31 13/02/2013 12.7116 12.703 12.710235714286
32 14/02/2013 12.6982 12.708 12.714542857143
33 15/02/2013 12.6866 12.724 12.713828571429
34 18/02/2013 12.6959 12.735 12.723685714286
35 19/02/2013 12.6873 12.739 12.726192857143
36 20/02/2013 12.6694 12.744 12.735171428571
37 21/02/2013 12.7699 12.745 12.74745
38 22/02/2013 12.7517 12.745 12.7486
39 25/02/2013 12.7028 12.746 12.7604
40 26/02/2013 12.8680 12.752 12.7724
41 27/02/2013 12.8322 12.751 12.772978571429
42 28/02/2013 12.7795 12.740 12.770692857143
43 01/03/2013 12.8012 12.725 12.75375
44 04/03/2013 12.7814 12.707 12.728514285714
45 05/03/2013 12.7355 12.686 12.7033
46 06/03/2013 12.7345 12.665 12.677221428571
47 07/03/2013 12.7839 12.647 12.644414285714
48 08/03/2013 12.6684 12.615 12.60165
49 11/03/2013 12.5308 12.585 12.55775
50 12/03/2013 12.4641 12.558 12.519792857143
51 13/03/2013 12.3967 12.529 12.493171428571
52 14/03/2013 12.4545 12.500 12.469292857143
53 15/03/2013 12.4390 12.475 12.437157142857
54 19/03/2013 12.4339 12.449 12.411778571429
55 20/03/2013 12.3909 12.415 12.394864285714
56 21/03/2013 12.3841 12.392 12.379878571429
57 22/03/2013 12.3724 12.378 12.373
58 25/03/2013 12.3579 12.363 12.3621
59 26/03/2013 12.3546 12.347 12.348
60 27/03/2013 12.3612 12.326 12.327578571429
61 01/04/2013 12.3438 12.304 12.302657142857
62 02/04/2013 12.2728 12.280 12.282135714286
63 03/04/2013 12.3266 12.259 12.263821428571
64 04/04/2013 12.3197 12.245 12.237835714286
65 05/04/2013 12.2383 12.231 12.213364285714
66 08/04/2013 12.1588 12.223 12.191771428571
67 09/04/2013 12.1304 12.216 12.180942857143
68 10/04/2013 12.1140 12.207 12.174785714286
69 11/04/2013 12.0691 12.206 12.1653
70 12/04/2013 12.0824 12.204 12.172928571429
71 15/04/2013 12.1729 12.201 12.179735714286
72 16/04/2013 12.1668 12.188 12.192742857143
73 17/04/2013 12.2370 12.182 12.198014285714
74 18/04/2013 12.2479 12.180 12.200114285714
75 19/04/2013 12.2254 12.181 12.209992857143
76 22/04/2013 12.3227 12.185 12.216207142857
77 23/04/2013 12.2492 12.187 12.213121428571
78 24/04/2013 12.2768 12.188 12.198278571429
79 25/04/2013 12.1231 12.182 12.180321428571
 80 26/04/2013 12.1550 12.173 12.168528571429
81 29/04/2013 12.1326 12.156 12.154564285714
82 30/04/2013 12.1456 12.147 12.133207142857
83 02/05/2013 12.1756 12.141 12.1189
84 03/05/2013 12.0851 12.130 12.1046
85 06/05/2013 12.1074 12.129 12.105571428571
86 07/05/2013 12.0733 12.126 12.106157142857
87 08/05/2013 12.0393 12.139 12.107057142857
88 09/05/2013 11.9807 12.150 12.124357142857
89 10/05/2013 12.1094 12.164 12.146807142857
90 13/05/2013 12.1448 12.175 12.167907142857
91 14/05/2013 12.1485 12.195 12.18865
92 15/05/2013 12.2313 12.224 12.223821428571
93 16/05/2013 12.2378 12.250 12.264464285714
94 17/05/2013 12.3177 12.280 12.306635714286
95 20/05/2013 12.3258 12.319 12.338192857143
96 21/05/2013 12.3414 12.373 12.372014285714
97 22/05/2013 12.3113 12.419 12.426628571429
98 23/05/2013 12.4764 12.462 12.482542857143
99 24/05/2013 12.5219 12.501 12.522335714286
100 27/05/2013 12.4831 12.540 12.552307142857
101 28/05/2013 12.5275 12.584 12.598064285714
102 29/05/2013 12.6328 12.611 12.656428571429
103 30/05/2013 12.7781 12.646 12.697621428571
104 31/05/2013 12.8035 12.683 12.725542857143
105 03/06/2013 12.7882 12.718 12.746321428571
106 04/06/2013 12.7317 12.738 12.77415
107 05/06/2013 12.8167 12.750 12.804857142857
108 06/06/2013 12.9079 12.767 12.801957142857
109 07/06/2013 12.7173 12.790 12.7954
110 10/06/2013 12.8572 12.806 12.812814285714
111 11/06/2013 12.8846 12.847 12.817692857143
112 12/06/2013 12.8442 12.888 12.85815
113 13/06/2013 12.7812 12.928 12.889207142857
114 14/06/2013 12.6916 12.962 12.920957142857
115 17/06/2013 12.7370 12.987 12.971921428571
116 18/06/2013 12.8800 12.995 13.005042857143
117 19/06/2013 12.8695 13.015 13.052214285714
118 20/06/2013 13.4015 13.019 13.103521428571
119 21/06/2013 13.4041 13.026 13.112592857143
120 24/06/2013 13.3966 13.039 13.122
121 25/06/2013 13.2424 13.046 13.128607142857
122 26/06/2013 13.1884 13.070 13.1137
123 27/06/2013 13.0235 13.083 13.115607142857
124 28/06/2013 13.0279 13.082 13.073807142857
125 01/07/2013 12.9131 13.087 13.032264285714
126 02/07/2013 12.9850 13.051 13.009221428571
127 03/07/2013 13.0377 13.012 12.975128571429
128 04/07/2013 12.8902 12.969 12.950414285714
129 05/07/2013 13.0567 12.928 12.932678571429
130 08/07/2013 12.9267 12.885 12.890585714286
131 09/07/2013 12.8654 12.850 12.86595
132 10/07/2013 12.9494 12.818 12.830742857143
133 11/07/2013 12.8599 12.791 12.7869
134 12/07/2013 12.8234 12.759 12.750757142857
135 15/07/2013 12.7387 12.732 12.697835714286
136 16/07/2013 12.6299 12.716 12.663057142857
137 17/07/2013 12.5455 12.693 12.637992857143
138 18/07/2013 12.4976 12.680 12.621142857143
139 19/07/2013 12.5499 12.673 12.612571428571
140 22/07/2013 12.5054 12.666 12.605392857143
141 23/07/2013 12.5093 12.662 12.6222
142 24/07/2013 12.6330 12.654 12.644657142857
143 25/07/2013 12.6468 12.649 12.660442857143
144 26/07/2013 12.7091 12.650 12.679271428571
145 29/07/2013 12.7321 12.661 12.689914285714
146 30/07/2013 12.7635 12.671 12.7119
147 31/07/2013 12.8464 12.673 12.724757142857
148 01/08/2013 12.8068 12.677 12.710464285714
149 02/08/2013 12.6904 12.694 12.695385714286
150 05/08/2013 12.6759 12.700 12.69535
151 06/08/2013 12.6445 12.714 12.696521428571
152 07/08/2013 12.6989 12.725 12.7037
153 08/08/2013 12.6460 12.744 12.697685714286
154 09/08/2013 12.5889 12.760 12.7067
155 12/08/2013 12.5666 12.780 12.7411
156 13/08/2013 12.7545 12.802 12.785771428571
157 14/08/2013 12.7255 12.823 12.829492857143
158 15/08/2013 12.8625 12.852 12.861328571429
159 16/08/2013 12.8722 12.898 12.905107142857
160 19/08/2013 13.0124 12.935 12.9681
161 20/08/2013 13.0064 12.979 13.026478571429
162 21/08/2013 13.1424 13.029 13.076342857143
163 22/08/2013 13.1486 13.079 13.110021428571
164 23/08/2013 12.9979 13.124 13.138942857143
165 26/08/2013 13.1090 13.163 13.20365
166 27/08/2013 13.3366 13.199 13.235007142857
167 28/08/2013 13.2539 13.224 13.261814285714
168 29/08/2013 13.3104 13.233 13.275135714286
169 30/08/2013 13.3415 13.240 13.274785714286
170 02/09/2013 13.3070 13.237 13.289921428571
171 03/09/2013 13.4394 13.233 13.2888
172 04/09/2013 13.3065 13.236 13.268607142857
173 05/09/2013 13.4079 13.224 13.249671428571
174 06/09/2013 13.2413 13.200 13.20345
175 09/09/2013 13.1471 13.164 13.167578571429
176 10/09/2013 13.1119 13.128 13.121692857143
177 11/09/2013 13.0938 13.091 13.071878571429
178 12/09/2013 13.0854 13.062 13.031757142857
179 13/09/2013 13.0540 13.029 12.9822
180 17/09/2013 12.9241 13.010 12.955514285714
181 18/09/2013 12.9687 12.992 12.931128571429
182 19/09/2013 12.7179 12.988 12.919192857143
183 20/09/2013 12.7685 12.987 12.929735714286
184 23/09/2013 12.7846 12.990 12.940514285714
185 24/09/2013 12.8754 13.001 12.960064285714
186 25/09/2013 12.9530 13.002 12.994257142857
187 26/09/2013 13.0119 13.005 13.017178571429
188 27/09/2013 13.1450 13.019 13.055807142857
189 30/09/2013 13.1747 13.036 13.08135
190 01/10/2013 13.1294 13.060 13.110821428571
191 02/10/2013 13.1593 13.079 13.136021428571
192 03/10/2013 13.2663 13.097 13.138642857143
193 04/10/2013 13.0976 13.103 13.129135714286
194 07/10/2013 13.0959 13.099 13.119964285714
195 08/10/2013 13.1417 13.083 13.107364285714
196 09/10/2013 13.2126 13.060 13.078214285714
197 10/10/2013 13.0913 13.043 13.04095
198 11/10/2013 13.0514 13.026 13.014021428571
199 14/10/2013 13.0492 13.012 12.992221428571
200 15/10/2013 12.9725 12.993 12.96935
201 16/10/2013 12.8816 12.978 12.944285714286
202 17/10/2013 12.7717 12.965 12.91385
203 18/10/2013 12.7988 12.948 12.911221428571
204 21/10/2013 12.9314 12.925 12.904892857143
205 22/10/2013 12.8713 12.919 12.892514285714
206 23/10/2013 12.9433 12.921 12.90355
207 24/10/2013 12.9916 12.917 12.912357142857
208 25/10/2013 12.8693 12.928 12.920814285714
209 28/10/2013 12.8948 12.945 12.946264285714
210 29/10/2013 12.8903 12.973 12.958878571429
211 30/10/2013 12.8640 13.002 12.990042857143
212 31/10/2013 13.0067 13.022 13.026671428571
213 01/11/2013 13.0789 13.043 13.042385714286
214 04/11/2013 12.9869 13.054 13.069085714286
215 05/11/2013 13.1341 13.056 13.094807142857
216 06/11/2013 13.1388 13.061 13.107957142857
217 07/11/2013 13.1912 13.061 13.121585714286
218 08/11/2013 13.2412 13.066 13.1159
219 11/11/2013 13.2314 13.079 13.104292857143
220 12/11/2013 13.1879 13.080 13.100464285714
221 13/11/2013 13.1030 13.077 13.080292857143
222 14/11/2013 13.0173 13.083 13.061528571429
223 15/11/2013 12.9524 13.080 13.043878571429
224 19/11/2013 12.8869 13.076 13.034492857143
225 20/11/2013 12.9697 13.071 13.036421428571
226 21/11/2013 13.0617 13.068 13.034621428571
227 22/11/2013 13.0223 13.069 13.039342857143
228 25/11/2013 13.0267 13.062 13.058778571429
229 26/11/2013 13.0745 13.055 13.072778571429
230 27/11/2013 13.0925 13.049 13.081914285714
231 28/11/2013 13.0836 13.043 13.080328571429
232 29/11/2013 13.1101 13.041 13.074614285714
233 02/12/2013 13.2041 13.039 13.071914285714
234 03/12/2013 13.2372 13.032 13.056628571429
235 04/12/2013 13.0826 13.026 13.031307142857
236 05/12/2013 13.0057 13.022 13.009785714286
237 06/12/2013 12.9299 13.016 12.990457142857
238 09/12/2013 12.8612 13.008 12.976964285714
239 10/12/2013 12.8574 13.000 12.965671428571
240 11/12/2013 12.9342 12.990 12.952407142857
241 13/12/2013 12.9515 12.978 12.944414285714
242 16/12/2013 12.9439 12.966 12.945864285714
243 17/12/2013 12.9575 12.965 12.958335714286
244 18/12/2013 12.9937 12.969 12.974821428571
245 19/12/2013 12.9730 12.979 12.987071428571
246 20/12/2013 12.9574 12.995 12.996935714286
247 23/12/2013 12.9610 13.011 13.012092857143
248 24/12/2013 13.0200 13.021 13.0293
249 26/12/2013 13.0547 13.027 13.042835714286
250 27/12/2013 13.0765 13.036 13.046442857143
251 30/12/2013 13.0652 13.048 13.054971428571
252 31/12/2013 13.0843 13.049 13.0706
253 02/01/2014 13.1011 13.050 13.074335714286
254 03/01/2014 13.0911 13.060 13.071357142857
255 06/01/2014 13.0905 13.073 13.070178571429
256 07/01/2014 13.0337 13.092 13.076357142857
257 08/01/2014 13.0846 13.106 13.100078571429
258 09/01/2014 13.1403 13.117 13.108028571429
259 10/01/2014 13.0065 13.133 13.107278571429
260 13/01/2014 12.9889 13.148 13.12845
261 14/01/2014 13.0956 13.166 13.157657142857
262 15/01/2014 13.1689 13.193 13.195771428571
263 16/01/2014 13.2907 13.217 13.232428571429
264 17/01/2014 13.2737 13.235 13.250414285714
265 20/01/2014 13.2420 13.254 13.273885714286
266 21/01/2014 13.2984 13.266 13.306428571429
267 22/01/2014 13.3194 13.291 13.327778571429
268 23/01/2014 13.3722 13.318 13.355035714286
269 24/01/2014 13.4930 13.336 13.367228571429
270 27/01/2014 13.4408 13.339 13.3611
271 28/01/2014 13.3104 13.342 13.354342857143
272 29/01/2014 13.3671 13.344 13.357228571429
273 30/01/2014 13.3207 13.348 13.3575
274 31/01/2014 13.3769 13.348 13.356892857143
275 04/02/2014 13.3928 13.349 13.34305
276 05/02/2014 13.3705 13.341 13.323014285714
277 06/02/2014 13.2211 13.321 13.315535714286
278 07/02/2014 13.3285 13.307 13.309828571429
279 10/02/2014 13.3134 13.304 13.300435714286
280 11/02/2014 13.2916 13.299 13.292342857143
281 12/02/2014 13.3056 13.296 13.287978571429
282 13/02/2014 13.3320 13.284 13.276692857143
283 14/02/2014 13.2477 13.273 13.266035714286
284 17/02/2014 13.1949 13.268 13.257085714286
285 18/02/2014 13.2261 13.274 13.261535714286
286 19/02/2014 13.2714 13.268 13.267264285714
287 20/02/2014 13.2913 13.269 13.262357142857
288 21/02/2014 13.2704 13.267 13.255628571429
289 24/02/2014 13.2090 13.264 13.254335714286
290 25/02/2014 13.2248 13.252 13.26485
291 26/02/2014 13.2992 13.247 13.265085714286
292 27/02/2014 13.3066 13.249 13.254142857143
293 28/02/2014 13.2379 13.250 13.250357142857
294 03/03/2014 13.3201 13.250 13.251064285714
295 04/03/2014 13.2752 13.247 13.250257142857
296 05/03/2014 13.2519 13.244 13.242628571429
297 06/03/2014 13.1476 13.242 13.2328
298 07/03/2014 13.1795 13.238 13.228378571429
299 10/03/2014 13.2248 13.236 13.228028571429
300 11/03/2014 13.2430 13.230 13.227407142857
301 12/03/2014 13.2659 13.228 13.22365
302 13/03/2014 13.2456 13.215 13.2178
303 14/03/2014 13.2340 13.206 13.211314285714
304 18/03/2014 13.1675 13.194 13.202978571429
305 19/03/2014 13.1695 13.190 13.200242857143
306 20/03/2014 13.2703 13.182 13.1925
307 21/03/2014 13.2200 13.169 13.172542857143
308 24/03/2014 13.2019 13.159 13.151157142857
309 25/03/2014 13.1349 13.150 13.136192857143
310 26/03/2014 13.1273 13.136 13.130028571429
311 27/03/2014 13.0837 13.122 13.1173
312 28/03/2014 13.0841 13.119 13.097214285714
313 31/03/2014 13.0549 13.115 13.08213452381
314 01/04/2014 13.0313 13.102 13.07547
315 02/04/2014 13.0991 13.091 13.079258928571
316 03/04/2014 13.1324 13.080 13.067942857143
317 04/04/2014 13.0345 13.074 13.045542857143
318 07/04/2014 13.0179 13.067 13.039791666667
319
320
321
322
323
324
 Fix Banxico: media móvil simple y centrada
13.5000

13.2000

12.9000

12.6000

Fix Banxico
12.3000 media móvil (15 días)
media móvil centrada (7
días)
12.0000

11.7000
31/12/2012 28/02/2013 02/05/2013 28/06/2013 26/08/2013 23/10/2013 23/12/2013 21/02/2014

Fix Banxico: media móvil exponencial (EMA)

13.5000
13.5000

Fix Banxico
13.2000
series_media_
series_media_

12.9000
14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14
/20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20
1 1 1 2 2 2 2 2 2 3 3 3 3 3 3 3 4 4
/0 /0 /0 /0 /0 /0 /0 /0 /0 /0 /0 /0 /0 /0 /0 /0 /0 /0
22 27 30 05 10 13 18 21 26 03 06 11 14 20 25 28 02 07
Banxico
dia móvil (15 días)
dia móvil centrada (7
)

2/2013 21/02/2014

MA)
Fix Banxico
series_media_movil!#ref!
series_media_movil!#ref!
 Escoger una media móvil
media móvil
t FECHA serie de centrada (7
(15 periodos)
tiempo periodos)
1 31/12/2012
2 02/01/2013
3 03/01/2013
4 04/01/2013
5 07/01/2013
6 08/01/2013
7 09/01/2013
8 10/01/2013
9 11/01/2013
10 14/01/2013
11 15/01/2013
12 16/01/2013
13 17/01/2013
14 18/01/2013
15 21/01/2013
16 22/01/2013
17 23/01/2013
18 24/01/2013
19 25/01/2013
20 28/01/2013
21 29/01/2013
22 30/01/2013
23 31/01/2013
24 01/02/2013
25 05/02/2013
26 06/02/2013
27 07/02/2013
28 08/02/2013
29 11/02/2013
30 12/02/2013
31 13/02/2013
32 14/02/2013
33 15/02/2013
34 18/02/2013
35 19/02/2013
36 20/02/2013
37 21/02/2013
38 22/02/2013
39 25/02/2013
40 26/02/2013
41 27/02/2013
42 28/02/2013
43 01/03/2013
44 04/03/2013
45 05/03/2013
46 06/03/2013
47 07/03/2013
48 08/03/2013
49 11/03/2013
50 12/03/2013
51 13/03/2013
52 14/03/2013
53 15/03/2013
54 19/03/2013
55 20/03/2013
56 21/03/2013
57 22/03/2013
58 25/03/2013
59 26/03/2013
60 27/03/2013
61 01/04/2013
62 02/04/2013
63 03/04/2013
64 04/04/2013
65 05/04/2013
66 08/04/2013
67 09/04/2013
68 10/04/2013
69 11/04/2013
70 12/04/2013
71 15/04/2013
72 16/04/2013
73 17/04/2013
74 18/04/2013
75 19/04/2013
76 22/04/2013
77 23/04/2013
78 24/04/2013
79 25/04/2013
 80 26/04/2013
81 29/04/2013
82 30/04/2013
83 02/05/2013
84 03/05/2013
85 06/05/2013
86 07/05/2013
87 08/05/2013
88 09/05/2013
89 10/05/2013
90 13/05/2013
91 14/05/2013
92 15/05/2013
93 16/05/2013
94 17/05/2013
95 20/05/2013
96 21/05/2013
97 22/05/2013
98 23/05/2013
99 24/05/2013
100 27/05/2013
101 28/05/2013
102 29/05/2013
103 30/05/2013
104 31/05/2013
105 03/06/2013
106 04/06/2013
107 05/06/2013
108 06/06/2013
109 07/06/2013
110 10/06/2013
111 11/06/2013
112 12/06/2013
113 13/06/2013
114 14/06/2013
115 17/06/2013
116 18/06/2013
117 19/06/2013
118 20/06/2013
119 21/06/2013
120 24/06/2013
121 25/06/2013
122 26/06/2013
123 27/06/2013
124 28/06/2013
125 01/07/2013
126 02/07/2013
127 03/07/2013
128 04/07/2013
129 05/07/2013
130 08/07/2013
131 09/07/2013
132 10/07/2013
133 11/07/2013
134 12/07/2013
135 15/07/2013
136 16/07/2013
137 17/07/2013
138 18/07/2013
139 19/07/2013
140 22/07/2013
141 23/07/2013
142 24/07/2013
143 25/07/2013
144 26/07/2013
145 29/07/2013
146 30/07/2013
147 31/07/2013
148 01/08/2013
149 02/08/2013
150 05/08/2013
151 06/08/2013
152 07/08/2013
153 08/08/2013
154 09/08/2013
155 12/08/2013
156 13/08/2013
157 14/08/2013
158 15/08/2013
159 16/08/2013
160 19/08/2013
161 20/08/2013
162 21/08/2013
163 22/08/2013
164 23/08/2013
165 26/08/2013
166 27/08/2013
167 28/08/2013
168 29/08/2013
169 30/08/2013
170 02/09/2013
171 03/09/2013
172 04/09/2013
173 05/09/2013
174 06/09/2013
175 09/09/2013
176 10/09/2013
177 11/09/2013
178 12/09/2013
179 13/09/2013
180 17/09/2013
181 18/09/2013
182 19/09/2013
183 20/09/2013
184 23/09/2013
185 24/09/2013
186 25/09/2013
187 26/09/2013
188 27/09/2013
189 30/09/2013
190 01/10/2013
191 02/10/2013
192 03/10/2013
193 04/10/2013
194 07/10/2013
195 08/10/2013
196 09/10/2013
197 10/10/2013
198 11/10/2013
199 14/10/2013
200 15/10/2013
201 16/10/2013
202 17/10/2013
203 18/10/2013
204 21/10/2013
205 22/10/2013
206 23/10/2013
207 24/10/2013
208 25/10/2013
209 28/10/2013
210 29/10/2013
211 30/10/2013
212 31/10/2013
213 01/11/2013
214 04/11/2013
215 05/11/2013
216 06/11/2013
217 07/11/2013
218 08/11/2013
219 11/11/2013
220 12/11/2013
221 13/11/2013
222 14/11/2013
223 15/11/2013
224 19/11/2013
225 20/11/2013
226 21/11/2013
227 22/11/2013
228 25/11/2013
229 26/11/2013
230 27/11/2013
231 28/11/2013
232 29/11/2013
233 02/12/2013
234 03/12/2013
235 04/12/2013
236 05/12/2013
237 06/12/2013
238 09/12/2013
239 10/12/2013
240 11/12/2013
241 13/12/2013
242 16/12/2013
243 17/12/2013
244 18/12/2013
245 19/12/2013
246 20/12/2013
247 23/12/2013
248 24/12/2013
249 26/12/2013
250 27/12/2013
251 30/12/2013
252 31/12/2013
253 02/01/2014
254 03/01/2014
255 06/01/2014
256 07/01/2014
257 08/01/2014
258 09/01/2014
259 10/01/2014
260 13/01/2014
261 14/01/2014
262 15/01/2014
263 16/01/2014
264 17/01/2014
265 20/01/2014
266 21/01/2014
267 22/01/2014
268 23/01/2014
269 24/01/2014
270 27/01/2014
271 28/01/2014
272 29/01/2014
273 30/01/2014
274 31/01/2014
275 04/02/2014
276 05/02/2014
277 06/02/2014
278 07/02/2014
279 10/02/2014
280 11/02/2014
281 12/02/2014
282 13/02/2014
283 14/02/2014
284 17/02/2014
285 18/02/2014
286 19/02/2014
287 20/02/2014
288 21/02/2014
289 24/02/2014
290 25/02/2014
291 26/02/2014
292 27/02/2014
293 28/02/2014
294 03/03/2014
295 04/03/2014
296 05/03/2014
297 06/03/2014
298 07/03/2014
299 10/03/2014
300 11/03/2014
301 12/03/2014
302 13/03/2014
303 14/03/2014
304 18/03/2014
305 19/03/2014
306 20/03/2014
307 21/03/2014
308 24/03/2014
309 25/03/2014
310 26/03/2014
311 27/03/2014
312 28/03/2014
313 31/03/2014
314 01/04/2014
315 02/04/2014
316 03/04/2014
317 04/04/2014
318 07/04/2014
319
320
321
322
323
324
 media media
media móvil media móvil
Fix móvil móvil
t FECHA exponencial exponencial
Banxico exponencia exponencia
50 200
l 15 l 30 13.5000
1 31/12/2012 12.9658 12.97 12.97 12.97 12.97
2 02/01/2013 12.7488 12.94 12.95 12.96 12.96
3 03/01/2013 12.7430 12.91 12.94 12.95 12.96
4 04/01/2013 12.7597 12.89 12.93 12.94 12.96 13.2000
5 07/01/2013 12.7679 12.88 12.92 12.93 12.96
6 08/01/2013 12.8015 12.87 12.91 12.93 12.96
7 09/01/2013 12.7503 12.85 12.90 12.92 12.95
8 10/01/2013 12.6555 12.83 12.88 12.91 12.95 12.9000
9 11/01/2013 12.6478 12.81 12.87 12.90 12.95
10 14/01/2013 12.6533 12.79 12.85 12.89 12.95
11 15/01/2013 12.6526 12.77 12.84 12.88 12.94
12 16/01/2013 12.6305 12.75 12.83 12.87 12.94 12.6000
13 17/01/2013 12.5868 12.73 12.81 12.86 12.94
14 18/01/2013 12.6555 12.72 12.80 12.85 12.93
15 21/01/2013 12.7098 12.72 12.80 12.85 12.93
12.3000
16 22/01/2013 12.6817 12.72 12.79 12.84 12.93
17 23/01/2013 12.6616 12.71 12.78 12.83 12.93
18 24/01/2013 12.6286 12.70 12.77 12.83 12.92
19 25/01/2013 12.6993 12.70 12.77 12.82 12.92 12.0000
20 28/01/2013 12.7802 12.71 12.77 12.82 12.92
21 29/01/2013 12.7134 12.71 12.76 12.82 12.92
22 30/01/2013 12.7408 12.71 12.76 12.81 12.92
23 31/01/2013 12.7094 12.71 12.76 12.81 12.91 11.7000
24 01/02/2013 12.6377 12.70 12.75 12.80 12.91 22/05/201301
25 05/02/2013 12.6294 12.69 12.74 12.79 12.91
26 06/02/2013 12.6664 12.69 12.74 12.79 12.91
27 07/02/2013 12.7105 12.69 12.74 12.79 12.90
28 08/02/2013 12.7307 12.70 12.74 12.78 12.90 13.5000
29 11/02/2013 12.7706 12.71 12.74 12.78 12.90
30 12/02/2013 12.7364 12.71 12.74 12.78 12.90
31 13/02/2013 12.7116 12.71 12.74 12.78 12.90 13.2000
32 14/02/2013 12.6982 12.71 12.73 12.78 12.89
33 15/02/2013 12.6866 12.71 12.73 12.77 12.89
34 18/02/2013 12.6959 12.71 12.73 12.77 12.89
35 19/02/2013 12.6873 12.70 12.73 12.77 12.89 12.9000
36 20/02/2013 12.6694 12.70 12.72 12.76 12.89

12.6000
 12.9000

37 21/02/2013 12.7699 12.71 12.73 12.76 12.89

38 22/02/2013 12.7517 12.71 12.73 12.76 12.88
12.6000
39 25/02/2013 12.7028 12.71 12.73 12.76 12.88
40 26/02/2013 12.8680 12.73 12.73 12.76 12.88
41 27/02/2013 12.8322 12.74 12.74 12.77 12.88
42 28/02/2013 12.7795 12.75 12.74 12.77 12.88 12.3000
43 01/03/2013 12.8012 12.76 12.75 12.77 12.88
44 04/03/2013 12.7814 12.76 12.75 12.77 12.88
45 05/03/2013 12.7355 12.76 12.75 12.77 12.88
12.0000
46 06/03/2013 12.7345 12.75 12.75 12.77 12.88
47 07/03/2013 12.7839 12.76 12.75 12.77 12.87
48 08/03/2013 12.6684 12.75 12.74 12.76 12.87
49 11/03/2013 12.5308 12.72 12.73 12.75 12.87 11.7000
50 12/03/2013 12.4641 12.69 12.71 12.74 12.87 31/12/201201
51 13/03/2013 12.3967 12.65 12.69 12.73 12.86
52 14/03/2013 12.4545 12.63 12.68 12.72 12.86
53 15/03/2013 12.4390 12.60 12.66 12.71 12.85
54 19/03/2013 12.4339 12.58 12.65 12.70 12.85
55 20/03/2013 12.3909 12.56 12.63 12.68 12.84
56 21/03/2013 12.3841 12.54 12.62 12.67 12.84
57 22/03/2013 12.3724 12.52 12.60 12.66 12.83
58 25/03/2013 12.3579 12.50 12.58 12.65 12.83
59 26/03/2013 12.3546 12.48 12.57 12.64 12.83
60 27/03/2013 12.3612 12.46 12.56 12.63 12.82
61 01/04/2013 12.3438 12.45 12.54 12.62 12.82
62 02/04/2013 12.2728 12.43 12.52 12.60 12.81
63 03/04/2013 12.3266 12.41 12.51 12.59 12.81
64 04/04/2013 12.3197 12.40 12.50 12.58 12.80
65 05/04/2013 12.2383 12.38 12.48 12.57 12.80
66 08/04/2013 12.1588 12.35 12.46 12.55 12.79
67 09/04/2013 12.1304 12.33 12.44 12.53 12.78
68 10/04/2013 12.1140 12.30 12.42 12.52 12.78
69 11/04/2013 12.0691 12.27 12.40 12.50 12.77
70 12/04/2013 12.0824 12.25 12.38 12.48 12.76
71 15/04/2013 12.1729 12.24 12.36 12.47 12.76
72 16/04/2013 12.1668 12.23 12.35 12.46 12.75
73 17/04/2013 12.2370 12.23 12.34 12.45 12.74
74 18/04/2013 12.2479 12.23 12.34 12.44 12.74
75 19/04/2013 12.2254 12.23 12.33 12.43 12.73
76 22/04/2013 12.3227 12.24 12.33 12.43 12.73
77 23/04/2013 12.2492 12.24 12.32 12.42 12.73
78 24/04/2013 12.2768 12.25 12.32 12.42 12.72
79 25/04/2013 12.1231 12.23 12.31 12.41 12.72
 80 26/04/2013 12.1550 12.22 12.30 12.40 12.71
81 29/04/2013 12.1326 12.21 12.29 12.39 12.70
82 30/04/2013 12.1456 12.20 12.28 12.38 12.70
83 02/05/2013 12.1756 12.20 12.27 12.37 12.69
84 03/05/2013 12.0851 12.19 12.26 12.36 12.69
85 06/05/2013 12.1074 12.18 12.25 12.35 12.68
86 07/05/2013 12.0733 12.16 12.24 12.34 12.68
87 08/05/2013 12.0393 12.15 12.23 12.33 12.67
88 09/05/2013 11.9807 12.13 12.21 12.31 12.66
89 10/05/2013 12.1094 12.12 12.20 12.30 12.66
90 13/05/2013 12.1448 12.13 12.20 12.30 12.65
91 14/05/2013 12.1485 12.13 12.20 12.29 12.65
92 15/05/2013 12.2313 12.14 12.20 12.29 12.64
93 16/05/2013 12.2378 12.15 12.20 12.29 12.64
94 17/05/2013 12.3177 12.17 12.21 12.29 12.64
95 20/05/2013 12.3258 12.19 12.22 12.29 12.63
96 21/05/2013 12.3414 12.21 12.22 12.29 12.63
97 22/05/2013 12.3113 12.22 12.23 12.29 12.63
98 23/05/2013 12.4764 12.26 12.25 12.30 12.62
99 24/05/2013 12.5219 12.29 12.26 12.31 12.62
100 27/05/2013 12.4831 12.31 12.28 12.32 12.62
101 28/05/2013 12.5275 12.34 12.29 12.32 12.62
102 29/05/2013 12.6328 12.38 12.32 12.34 12.62
103 30/05/2013 12.7781 12.43 12.35 12.35 12.62
104 31/05/2013 12.8035 12.47 12.38 12.37 12.62
105 03/06/2013 12.7882 12.51 12.40 12.39 12.63
106 04/06/2013 12.7317 12.54 12.42 12.40 12.63
107 05/06/2013 12.8167 12.58 12.45 12.42 12.63
108 06/06/2013 12.9079 12.62 12.48 12.44 12.63
109 07/06/2013 12.7173 12.63 12.49 12.45 12.63
110 10/06/2013 12.8572 12.66 12.52 12.46 12.64
111 11/06/2013 12.8846 12.69 12.54 12.48 12.64
112 12/06/2013 12.8442 12.71 12.56 12.49 12.64
113 13/06/2013 12.7812 12.72 12.57 12.51 12.64
114 14/06/2013 12.6916 12.71 12.58 12.51 12.64
115 17/06/2013 12.7370 12.72 12.59 12.52 12.64
116 18/06/2013 12.8800 12.74 12.61 12.54 12.65
117 19/06/2013 12.8695 12.75 12.63 12.55 12.65
118 20/06/2013 13.4015 12.83 12.68 12.58 12.65
119 21/06/2013 13.4041 12.91 12.72 12.61 12.66
120 24/06/2013 13.3966 12.97 12.77 12.65 12.67
121 25/06/2013 13.2424 13.00 12.80 12.67 12.68
122 26/06/2013 13.1884 13.02 12.82 12.69 12.68
123 27/06/2013 13.0235 13.02 12.84 12.70 12.68
124 28/06/2013 13.0279 13.02 12.85 12.71 12.69
125 01/07/2013 12.9131 13.01 12.85 12.72 12.69
126 02/07/2013 12.9850 13.01 12.86 12.73 12.69
127 03/07/2013 13.0377 13.01 12.87 12.74 12.70
128 04/07/2013 12.8902 13.00 12.87 12.75 12.70
129 05/07/2013 13.0567 13.00 12.89 12.76 12.70
130 08/07/2013 12.9267 12.99 12.89 12.77 12.70
131 09/07/2013 12.8654 12.98 12.89 12.77 12.71
132 10/07/2013 12.9494 12.97 12.89 12.78 12.71
133 11/07/2013 12.8599 12.96 12.89 12.78 12.71
134 12/07/2013 12.8234 12.94 12.88 12.78 12.71
135 15/07/2013 12.7387 12.92 12.88 12.78 12.71
136 16/07/2013 12.6299 12.88 12.86 12.78 12.71
137 17/07/2013 12.5455 12.84 12.84 12.77 12.71
138 18/07/2013 12.4976 12.80 12.82 12.76 12.71
139 19/07/2013 12.5499 12.77 12.80 12.75 12.70
140 22/07/2013 12.5054 12.73 12.78 12.74 12.70
141 23/07/2013 12.5093 12.71 12.76 12.73 12.70
142 24/07/2013 12.6330 12.70 12.75 12.73 12.70
143 25/07/2013 12.6468 12.69 12.75 12.72 12.70
144 26/07/2013 12.7091 12.69 12.75 12.72 12.70
145 29/07/2013 12.7321 12.70 12.74 12.72 12.70
146 30/07/2013 12.7635 12.71 12.75 12.72 12.70
147 31/07/2013 12.8464 12.72 12.75 12.73 12.70
148 01/08/2013 12.8068 12.73 12.76 12.73 12.70
149 02/08/2013 12.6904 12.73 12.75 12.73 12.70
150 05/08/2013 12.6759 12.72 12.75 12.73 12.70
151 06/08/2013 12.6445 12.71 12.74 12.73 12.70
152 07/08/2013 12.6989 12.71 12.74 12.72 12.70
153 08/08/2013 12.6460 12.70 12.73 12.72 12.70
154 09/08/2013 12.5889 12.69 12.72 12.72 12.70
155 12/08/2013 12.5666 12.67 12.71 12.71 12.70
156 13/08/2013 12.7545 12.68 12.72 12.71 12.70
157 14/08/2013 12.7255 12.69 12.72 12.71 12.70
158 15/08/2013 12.8625 12.71 12.73 12.72 12.70
159 16/08/2013 12.8722 12.73 12.73 12.72 12.70
160 19/08/2013 13.0124 12.77 12.75 12.74 12.71
161 20/08/2013 13.0064 12.80 12.77 12.75 12.71
162 21/08/2013 13.1424 12.84 12.79 12.76 12.71
163 22/08/2013 13.1486 12.88 12.82 12.78 12.72
164 23/08/2013 12.9979 12.89 12.83 12.79 12.72
165 26/08/2013 13.1090 12.92 12.85 12.80 12.72
166 27/08/2013 13.3366 12.97 12.88 12.82 12.73
167 28/08/2013 13.2539 13.01 12.90 12.84 12.74
168 29/08/2013 13.3104 13.05 12.93 12.86 12.74
169 30/08/2013 13.3415 13.08 12.95 12.87 12.75
170 02/09/2013 13.3070 13.11 12.98 12.89 12.75
171 03/09/2013 13.4394 13.15 13.01 12.91 12.76
172 04/09/2013 13.3065 13.17 13.03 12.93 12.77
173 05/09/2013 13.4079 13.20 13.05 12.95 12.77
174 06/09/2013 13.2413 13.21 13.06 12.96 12.78
175 09/09/2013 13.1471 13.20 13.07 12.97 12.78
176 10/09/2013 13.1119 13.19 13.07 12.97 12.78
177 11/09/2013 13.0938 13.18 13.07 12.98 12.79
178 12/09/2013 13.0854 13.16 13.07 12.98 12.79
179 13/09/2013 13.0540 13.15 13.07 12.98 12.79
180 17/09/2013 12.9241 13.12 13.06 12.98 12.79
181 18/09/2013 12.9687 13.10 13.06 12.98 12.80
182 19/09/2013 12.7179 13.05 13.04 12.97 12.79
183 20/09/2013 12.7685 13.02 13.02 12.96 12.79
184 23/09/2013 12.7846 12.99 13.00 12.96 12.79
185 24/09/2013 12.8754 12.98 12.99 12.95 12.79
186 25/09/2013 12.9530 12.97 12.99 12.95 12.80
187 26/09/2013 13.0119 12.98 12.99 12.95 12.80
188 27/09/2013 13.1450 13.00 13.00 12.96 12.80
189 30/09/2013 13.1747 13.02 13.01 12.97 12.81
190 01/10/2013 13.1294 13.03 13.02 12.98 12.81
191 02/10/2013 13.1593 13.05 13.03 12.98 12.81
192 03/10/2013 13.2663 13.08 13.05 12.99 12.82
193 04/10/2013 13.0976 13.08 13.05 13.00 12.82
194 07/10/2013 13.0959 13.08 13.05 13.00 12.82
195 08/10/2013 13.1417 13.09 13.06 13.01 12.83
196 09/10/2013 13.2126 13.10 13.07 13.02 12.83
197 10/10/2013 13.0913 13.10 13.07 13.02 12.83
198 11/10/2013 13.0514 13.10 13.07 13.02 12.83
199 14/10/2013 13.0492 13.09 13.07 13.02 12.84
200 15/10/2013 12.9725 13.08 13.06 13.02 12.84
201 16/10/2013 12.8816 13.05 13.05 13.01 12.84
202 17/10/2013 12.7717 13.02 13.03 13.00 12.84
203 18/10/2013 12.7988 12.99 13.02 13.00 12.84
204 21/10/2013 12.9314 12.98 13.01 12.99 12.84
205 22/10/2013 12.8713 12.97 13.00 12.99 12.84
206 23/10/2013 12.9433 12.97 13.00 12.99 12.84
207 24/10/2013 12.9916 12.97 13.00 12.99 12.84
208 25/10/2013 12.8693 12.96 12.99 12.98 12.84
209 28/10/2013 12.8948 12.95 12.98 12.98 12.84
210 29/10/2013 12.8903 12.94 12.98 12.98 12.84
211 30/10/2013 12.8640 12.93 12.97 12.97 12.84
212 31/10/2013 13.0067 12.94 12.97 12.97 12.84
213 01/11/2013 13.0789 12.96 12.98 12.98 12.85
214 04/11/2013 12.9869 12.96 12.98 12.98 12.85
215 05/11/2013 13.1341 12.98 12.99 12.98 12.85
216 06/11/2013 13.1388 13.00 13.00 12.99 12.85
217 07/11/2013 13.1912 13.03 13.01 13.00 12.86
218 08/11/2013 13.2412 13.05 13.03 13.01 12.86
219 11/11/2013 13.2314 13.08 13.04 13.02 12.86
220 12/11/2013 13.1879 13.09 13.05 13.02 12.87
221 13/11/2013 13.1030 13.09 13.05 13.03 12.87
222 14/11/2013 13.0173 13.08 13.05 13.03 12.87
223 15/11/2013 12.9524 13.07 13.04 13.02 12.87
224 19/11/2013 12.8869 13.04 13.03 13.02 12.87
225 20/11/2013 12.9697 13.03 13.03 13.02 12.87
226 21/11/2013 13.0617 13.04 13.03 13.02 12.88
227 22/11/2013 13.0223 13.04 13.03 13.02 12.88
228 25/11/2013 13.0267 13.03 13.03 13.02 12.88
229 26/11/2013 13.0745 13.04 13.03 13.02 12.88
230 27/11/2013 13.0925 13.05 13.04 13.02 12.88
231 28/11/2013 13.0836 13.05 13.04 13.03 12.88
232 29/11/2013 13.1101 13.06 13.05 13.03 12.89
233 02/12/2013 13.2041 13.08 13.06 13.04 12.89
234 03/12/2013 13.2372 13.10 13.07 13.04 12.89
235 04/12/2013 13.0826 13.09 13.07 13.04 12.89
236 05/12/2013 13.0057 13.08 13.06 13.04 12.90
237 06/12/2013 12.9299 13.06 13.06 13.04 12.90
238 09/12/2013 12.8612 13.04 13.04 13.03 12.90
239 10/12/2013 12.8574 13.02 13.03 13.03 12.90
240 11/12/2013 12.9342 13.01 13.02 13.02 12.90
241 13/12/2013 12.9515 13.00 13.02 13.02 12.90
242 16/12/2013 12.9439 12.99 13.02 13.02 12.90
243 17/12/2013 12.9575 12.99 13.01 13.01 12.90
244 18/12/2013 12.9937 12.99 13.01 13.01 12.90
245 19/12/2013 12.9730 12.99 13.01 13.01 12.90
246 20/12/2013 12.9574 12.98 13.00 13.01 12.90
247 23/12/2013 12.9610 12.98 13.00 13.01 12.90
248 24/12/2013 13.0200 12.99 13.00 13.01 12.90
249 26/12/2013 13.0547 12.99 13.01 13.01 12.90
250 27/12/2013 13.0765 13.00 13.01 13.01 12.91
251 30/12/2013 13.0652 13.01 13.01 13.01 12.91
252 31/12/2013 13.0843 13.02 13.02 13.02 12.91
253 02/01/2014 13.1011 13.03 13.02 13.02 12.91
254 03/01/2014 13.0911 13.04 13.03 13.02 12.91
255 06/01/2014 13.0905 13.04 13.03 13.03 12.91
256 07/01/2014 13.0337 13.04 13.03 13.03 12.92
257 08/01/2014 13.0846 13.05 13.04 13.03 12.92
258 09/01/2014 13.1403 13.06 13.04 13.03 12.92
259 10/01/2014 13.0065 13.05 13.04 13.03 12.92
260 13/01/2014 12.9889 13.05 13.04 13.03 12.92
261 14/01/2014 13.0956 13.05 13.04 13.03 12.92
262 15/01/2014 13.1689 13.07 13.05 13.04 12.92
263 16/01/2014 13.2907 13.09 13.06 13.05 12.93
264 17/01/2014 13.2737 13.12 13.08 13.06 12.93
265 20/01/2014 13.2420 13.13 13.09 13.06 12.93
266 21/01/2014 13.2984 13.15 13.10 13.07 12.94
267 22/01/2014 13.3194 13.17 13.12 13.08 12.94
268 23/01/2014 13.3722 13.20 13.13 13.09 12.95
269 24/01/2014 13.4930 13.24 13.16 13.11 12.95
270 27/01/2014 13.4408 13.26 13.17 13.12 12.96
271 28/01/2014 13.3104 13.27 13.18 13.13 12.96
272 29/01/2014 13.3671 13.28 13.19 13.14 12.96
273 30/01/2014 13.3207 13.28 13.20 13.15 12.97
274 31/01/2014 13.3769 13.30 13.21 13.16 12.97
275 04/02/2014 13.3928 13.31 13.23 13.16 12.98
276 05/02/2014 13.3705 13.32 13.24 13.17 12.98
277 06/02/2014 13.2211 13.30 13.23 13.17 12.98
278 07/02/2014 13.3285 13.31 13.24 13.18 12.99
279 10/02/2014 13.3134 13.31 13.25 13.19 12.99
280 11/02/2014 13.2916 13.31 13.25 13.19 12.99
281 12/02/2014 13.3056 13.31 13.25 13.19 13.00
282 13/02/2014 13.3320 13.31 13.26 13.20 13.00
283 14/02/2014 13.2477 13.30 13.26 13.20 13.00
284 17/02/2014 13.1949 13.29 13.25 13.20 13.00
285 18/02/2014 13.2261 13.28 13.25 13.20 13.01
286 19/02/2014 13.2714 13.28 13.25 13.21 13.01
287 20/02/2014 13.2913 13.28 13.25 13.21 13.01
288 21/02/2014 13.2704 13.28 13.26 13.21 13.01
289 24/02/2014 13.2090 13.27 13.25 13.21 13.02
290 25/02/2014 13.2248 13.26 13.25 13.21 13.02
291 26/02/2014 13.2992 13.27 13.25 13.22 13.02
292 27/02/2014 13.3066 13.27 13.26 13.22 13.02
293 28/02/2014 13.2379 13.27 13.26 13.22 13.03
294 03/03/2014 13.3201 13.28 13.26 13.22 13.03
295 04/03/2014 13.2752 13.28 13.26 13.23 13.03
296 05/03/2014 13.2519 13.27 13.26 13.23 13.03
297 06/03/2014 13.1476 13.26 13.25 13.22 13.03
298 07/03/2014 13.1795 13.25 13.25 13.22 13.04
299 10/03/2014 13.2248 13.24 13.25 13.22 13.04
300 11/03/2014 13.2430 13.24 13.25 13.22 13.04
301 12/03/2014 13.2659 13.25 13.25 13.22 13.04
302 13/03/2014 13.2456 13.25 13.25 13.23 13.04
303 14/03/2014 13.2340 13.25 13.25 13.23 13.05
304 18/03/2014 13.1675 13.24 13.24 13.22 13.05
305 19/03/2014 13.1695 13.23 13.24 13.22 13.05
306 20/03/2014 13.2703 13.23 13.24 13.22 13.05
307 21/03/2014 13.2200 13.23 13.24 13.22 13.05
308 24/03/2014 13.2019 13.23 13.24 13.22 13.05
309 25/03/2014 13.1349 13.22 13.23 13.22 13.05
310 26/03/2014 13.1273 13.20 13.22 13.22 13.05
311 27/03/2014 13.0837 13.19 13.21 13.21 13.06
312 28/03/2014 13.0841 13.18 13.21 13.20 13.06
313 31/03/2014 13.0549 13.16 13.20 13.20 13.06
314 01/04/2014 13.0313 13.15 13.18 13.19 13.06
315 02/04/2014 13.0991 13.14 13.18 13.19 13.06
316 03/04/2014 13.1324 13.14 13.18 13.19 13.06
317 04/04/2014 13.0345 13.13 13.17 13.18 13.06
318 07/04/2014 13.0179 13.11 13.16 13.17 13.06
319 12.658 12.926
320 12.161 12.797
321 11.684 12.670
322 11.226 12.544
323 10.786 12.419
324 10.363 12.296
 Fix Banxico: media móvil exponencial (15 y 30 días)
13.5000

13.2000

12.9000

12.6000

Fix Banxico
media móvil expo-
12.3000 nencial 15
media móvil expo-
nencial 30

12.0000

11.7000
22/05/201301/07/201308/08/201318/09/201328/10/201306/12/201320/01/201428/02/2014

Fix Banxico: media móvil exponencial (50 y 200 días)

13.5000

13.2000

12.9000

12.6000
12.9000

12.6000

12.3000
Fix Banxico
media móvil expo-
nencial 50
12.0000 media móvil expo-
nencial 200

11.7000
31/12/201201/03/201306/05/201303/07/201330/08/201330/10/201302/01/201404/03/2014
o-

o-

2/2014
xpo-

xpo-

3/2014
 media media
Escoger media móvil media móvil
móvil móvil
t FECHA una serie exponencial exponencial
exponencia exponencia
de tiempo 50 200
l 15 l 30
1 31/12/2012
2 02/01/2013
3 03/01/2013
4 04/01/2013
5 07/01/2013
6 08/01/2013
7 09/01/2013
8 10/01/2013
9 11/01/2013
10 14/01/2013
11 15/01/2013
12 16/01/2013
13 17/01/2013
14 18/01/2013
15 21/01/2013
16 22/01/2013
17 23/01/2013
18 24/01/2013
19 25/01/2013
20 28/01/2013
21 29/01/2013
22 30/01/2013
23 31/01/2013
24 01/02/2013
25 05/02/2013
26 06/02/2013
27 07/02/2013
28 08/02/2013
29 11/02/2013
30 12/02/2013
31 13/02/2013
32 14/02/2013
33 15/02/2013
34 18/02/2013
35 19/02/2013
36 20/02/2013
37 21/02/2013
38 22/02/2013
39 25/02/2013
40 26/02/2013
41 27/02/2013
42 28/02/2013
43 01/03/2013
44 04/03/2013
45 05/03/2013
46 06/03/2013
47 07/03/2013
48 08/03/2013
49 11/03/2013
50 12/03/2013
51 13/03/2013
52 14/03/2013
53 15/03/2013
54 19/03/2013
55 20/03/2013
56 21/03/2013
57 22/03/2013
58 25/03/2013
59 26/03/2013
60 27/03/2013
61 01/04/2013
62 02/04/2013
63 03/04/2013
64 04/04/2013
65 05/04/2013
66 08/04/2013
67 09/04/2013
68 10/04/2013
69 11/04/2013
70 12/04/2013
71 15/04/2013
72 16/04/2013
73 17/04/2013
74 18/04/2013
75 19/04/2013
76 22/04/2013
77 23/04/2013
78 24/04/2013
79 25/04/2013
 80 26/04/2013
81 29/04/2013
82 30/04/2013
83 02/05/2013
84 03/05/2013
85 06/05/2013
86 07/05/2013
87 08/05/2013
88 09/05/2013
89 10/05/2013
90 13/05/2013
91 14/05/2013
92 15/05/2013
93 16/05/2013
94 17/05/2013
95 20/05/2013
96 21/05/2013
97 22/05/2013
98 23/05/2013
99 24/05/2013
100 27/05/2013
101 28/05/2013
102 29/05/2013
103 30/05/2013
104 31/05/2013
105 03/06/2013
106 04/06/2013
107 05/06/2013
108 06/06/2013
109 07/06/2013
110 10/06/2013
111 11/06/2013
112 12/06/2013
113 13/06/2013
114 14/06/2013
115 17/06/2013
116 18/06/2013
117 19/06/2013
118 20/06/2013
119 21/06/2013
120 24/06/2013
121 25/06/2013
122 26/06/2013
123 27/06/2013
124 28/06/2013
125 01/07/2013
126 02/07/2013
127 03/07/2013
128 04/07/2013
129 05/07/2013
130 08/07/2013
131 09/07/2013
132 10/07/2013
133 11/07/2013
134 12/07/2013
135 15/07/2013
136 16/07/2013
137 17/07/2013
138 18/07/2013
139 19/07/2013
140 22/07/2013
141 23/07/2013
142 24/07/2013
143 25/07/2013
144 26/07/2013
145 29/07/2013
146 30/07/2013
147 31/07/2013
148 01/08/2013
149 02/08/2013
150 05/08/2013
151 06/08/2013
152 07/08/2013
153 08/08/2013
154 09/08/2013
155 12/08/2013
156 13/08/2013
157 14/08/2013
158 15/08/2013
159 16/08/2013
160 19/08/2013
161 20/08/2013
162 21/08/2013
163 22/08/2013
164 23/08/2013
165 26/08/2013
166 27/08/2013
167 28/08/2013
168 29/08/2013
169 30/08/2013
170 02/09/2013
171 03/09/2013
172 04/09/2013
173 05/09/2013
174 06/09/2013
175 09/09/2013
176 10/09/2013
177 11/09/2013
178 12/09/2013
179 13/09/2013
180 17/09/2013
181 18/09/2013
182 19/09/2013
183 20/09/2013
184 23/09/2013
185 24/09/2013
186 25/09/2013
187 26/09/2013
188 27/09/2013
189 30/09/2013
190 01/10/2013
191 02/10/2013
192 03/10/2013
193 04/10/2013
194 07/10/2013
195 08/10/2013
196 09/10/2013
197 10/10/2013
198 11/10/2013
199 14/10/2013
200 15/10/2013
201 16/10/2013
202 17/10/2013
203 18/10/2013
204 21/10/2013
205 22/10/2013
206 23/10/2013
207 24/10/2013
208 25/10/2013
209 28/10/2013
210 29/10/2013
211 30/10/2013
212 31/10/2013
213 01/11/2013
214 04/11/2013
215 05/11/2013
216 06/11/2013
217 07/11/2013
218 08/11/2013
219 11/11/2013
220 12/11/2013
221 13/11/2013
222 14/11/2013
223 15/11/2013
224 19/11/2013
225 20/11/2013
226 21/11/2013
227 22/11/2013
228 25/11/2013
229 26/11/2013
230 27/11/2013
231 28/11/2013
232 29/11/2013
233 02/12/2013
234 03/12/2013
235 04/12/2013
236 05/12/2013
237 06/12/2013
238 09/12/2013
239 10/12/2013
240 11/12/2013
241 13/12/2013
242 16/12/2013
243 17/12/2013
244 18/12/2013
245 19/12/2013
246 20/12/2013
247 23/12/2013
248 24/12/2013
249 26/12/2013
250 27/12/2013
251 30/12/2013
252 31/12/2013
253 02/01/2014
254 03/01/2014
255 06/01/2014
256 07/01/2014
257 08/01/2014
258 09/01/2014
259 10/01/2014
260 13/01/2014
261 14/01/2014
262 15/01/2014
263 16/01/2014
264 17/01/2014
265 20/01/2014
266 21/01/2014
267 22/01/2014
268 23/01/2014
269 24/01/2014
270 27/01/2014
271 28/01/2014
272 29/01/2014
273 30/01/2014
274 31/01/2014
275 04/02/2014
276 05/02/2014
277 06/02/2014
278 07/02/2014
279 10/02/2014
280 11/02/2014
281 12/02/2014
282 13/02/2014
283 14/02/2014
284 17/02/2014
285 18/02/2014
286 19/02/2014
287 20/02/2014
288 21/02/2014
289 24/02/2014
290 25/02/2014
291 26/02/2014
292 27/02/2014
293 28/02/2014
294 03/03/2014
295 04/03/2014
296 05/03/2014
297 06/03/2014
298 07/03/2014
299 10/03/2014
300 11/03/2014
301 12/03/2014
302 13/03/2014
303 14/03/2014
304 18/03/2014
305 19/03/2014
306 20/03/2014
307 21/03/2014
308 24/03/2014
309 25/03/2014
310 26/03/2014
311 27/03/2014
312 28/03/2014
313 31/03/2014
314 01/04/2014
315 02/04/2014
316 03/04/2014
317 04/04/2014
318 07/04/2014
319 0.000 0.000
320 0.000 0.000
321 0.000 0.000
322 0.000 0.000
323 0.000 0.000
324 0.000 0.000
 yt y't

Estimació Estimación
Fix
x FECHA n linea lineal α β r2
Banxico
(directa) (modelo)
Fri lineal
1 31/12/2012 12.9658 12.4364 12.436353177 12.43 0.0027 0.5081752
2 02/01/2013 12.7488 12.4390 12.439047963
3 03/01/2013 12.7430 12.4417 12.441742749
4 04/01/2013 12.7597 12.4444 12.444437535
5 07/01/2013 12.7679 12.4471 12.44713232
6 08/01/2013 12.8015 12.4498 12.449827106
7 09/01/2013 12.7503 12.4525 12.452521892
8 10/01/2013 12.6555 12.4552 12.455216678
9 11/01/2013 12.6478 12.4579 12.457911464
10 14/01/2013 12.6533 12.4606 12.46060625
11 15/01/2013 12.6526 12.4633 12.463301035
12 16/01/2013 12.6305 12.4660 12.465995821
13 17/01/2013 12.5868 12.4687 12.468690607
14 18/01/2013 12.6555 12.4714 12.471385393
15 21/01/2013 12.7098 12.4741 12.474080179
16 22/01/2013 12.6817 12.4768 12.476774964
17 23/01/2013 12.6616 12.4795 12.47946975
18 24/01/2013 12.6286 12.4822 12.482164536
19 25/01/2013 12.6993 12.4849 12.484859322
20 28/01/2013 12.7802 12.4876 12.487554108
21 29/01/2013 12.7134 12.4902 12.490248894
22 30/01/2013 12.7408 12.4929 12.492943679
23 31/01/2013 12.7094 12.4956 12.495638465
24 01/02/2013 12.6377 12.4983 12.498333251
25 05/02/2013 12.6294 12.5010 12.501028037
26 06/02/2013 12.6664 12.5037 12.503722823
27 07/02/2013 12.7105 12.5064 12.506417608
28 08/02/2013 12.7307 12.5091 12.509112394
29 11/02/2013 12.7706 12.5118 12.51180718
30 12/02/2013 12.7364 12.5145 12.514501966
31 13/02/2013 12.7116 12.5172 12.517196752
32 14/02/2013 12.6982 12.5199 12.519891538
33 15/02/2013 12.6866 12.5226 12.522586323
34 18/02/2013 12.6959 12.5253 12.525281109
35 19/02/2013 12.6873 12.5280 12.527975895
36 20/02/2013 12.6694 12.5307 12.530670681
37 21/02/2013 12.7699 12.5334 12.533365467
38 22/02/2013 12.7517 12.5361 12.536060253
39 25/02/2013 12.7028 12.5388 12.538755038
40 26/02/2013 12.8680 12.5414 12.541449824
41 27/02/2013 12.8322 12.5441 12.54414461
42 28/02/2013 12.7795 12.5468 12.546839396
43 01/03/2013 12.8012 12.5495 12.549534182
44 04/03/2013 12.7814 12.5522 12.552228967
45 05/03/2013 12.7355 12.5549 12.554923753
46 06/03/2013 12.7345 12.5576 12.557618539
47 07/03/2013 12.7839 12.5603 12.560313325
48 08/03/2013 12.6684 12.5630 12.563008111
49 11/03/2013 12.5308 12.5657 12.565702897
50 12/03/2013 12.4641 12.5684 12.568397682
51 13/03/2013 12.3967 12.5711 12.571092468
52 14/03/2013 12.4545 12.5738 12.573787254
53 15/03/2013 12.4390 12.5765 12.57648204
54 19/03/2013 12.4339 12.5792 12.579176826
55 20/03/2013 12.3909 12.5819 12.581871611
56 21/03/2013 12.3841 12.5846 12.584566397
57 22/03/2013 12.3724 12.5873 12.587261183
58 25/03/2013 12.3579 12.5900 12.589955969
59 26/03/2013 12.3546 12.5927 12.592650755
60 27/03/2013 12.3612 12.5953 12.595345541
61 01/04/2013 12.3438 12.5980 12.598040326
62 02/04/2013 12.2728 12.6007 12.600735112
63 03/04/2013 12.3266 12.6034 12.603429898
64 04/04/2013 12.3197 12.6061 12.606124684
65 05/04/2013 12.2383 12.6088 12.60881947
66 08/04/2013 12.1588 12.6115 12.611514255
67 09/04/2013 12.1304 12.6142 12.614209041
68 10/04/2013 12.1140 12.6169 12.616903827
69 11/04/2013 12.0691 12.6196 12.619598613
70 12/04/2013 12.0824 12.6223 12.622293399
71 15/04/2013 12.1729 12.6250 12.624988185
72 16/04/2013 12.1668 12.6277 12.62768297
73 17/04/2013 12.2370 12.6304 12.630377756
74 18/04/2013 12.2479 12.6331 12.633072542
75 19/04/2013 12.2254 12.6358 12.635767328
 76 22/04/2013 12.3227 12.6385 12.638462114
77 23/04/2013 12.2492 12.6412 12.641156899
78 24/04/2013 12.2768 12.6439 12.643851685
79 25/04/2013 12.1231 12.6465 12.646546471
80 26/04/2013 12.1550 12.6492 12.649241257
81 29/04/2013 12.1326 12.6519 12.651936043
82 30/04/2013 12.1456 12.6546 12.654630829
83 02/05/2013 12.1756 12.6573 12.657325614
84 03/05/2013 12.0851 12.6600 12.6600204
85 06/05/2013 12.1074 12.6627 12.662715186
86 07/05/2013 12.0733 12.6654 12.665409972
87 08/05/2013 12.0393 12.6681 12.668104758
88 09/05/2013 11.9807 12.6708 12.670799543
89 10/05/2013 12.1094 12.6735 12.673494329
90 13/05/2013 12.1448 12.6762 12.676189115
91 14/05/2013 12.1485 12.6789 12.678883901
92 15/05/2013 12.2313 12.6816 12.681578687
93 16/05/2013 12.2378 12.6843 12.684273473
94 17/05/2013 12.3177 12.6870 12.686968258
95 20/05/2013 12.3258 12.6897 12.689663044
96 21/05/2013 12.3414 12.6924 12.69235783
97 22/05/2013 12.3113 12.6951 12.695052616
98 23/05/2013 12.4764 12.6977 12.697747402
99 24/05/2013 12.5219 12.7004 12.700442187
100 27/05/2013 12.4831 12.7031 12.703136973
101 28/05/2013 12.5275 12.7058 12.705831759
102 29/05/2013 12.6328 12.7085 12.708526545
103 30/05/2013 12.7781 12.7112 12.711221331
104 31/05/2013 12.8035 12.7139 12.713916117
105 03/06/2013 12.7882 12.7166 12.716610902
106 04/06/2013 12.7317 12.7193 12.719305688
107 05/06/2013 12.8167 12.7220 12.722000474
108 06/06/2013 12.9079 12.7247 12.72469526
109 07/06/2013 12.7173 12.7274 12.727390046
110 10/06/2013 12.8572 12.7301 12.730084831
111 11/06/2013 12.8846 12.7328 12.732779617
112 12/06/2013 12.8442 12.7355 12.735474403
113 13/06/2013 12.7812 12.7382 12.738169189
114 14/06/2013 12.6916 12.7409 12.740863975
115 17/06/2013 12.7370 12.7436 12.743558761
116 18/06/2013 12.8800 12.7463 12.746253546
117 19/06/2013 12.8695 12.7489 12.748948332
118 20/06/2013 13.4015 12.7516 12.751643118
119 21/06/2013 13.4041 12.7543 12.754337904
120 24/06/2013 13.3966 12.7570 12.75703269
121 25/06/2013 13.2424 12.7597 12.759727476
122 26/06/2013 13.1884 12.7624 12.762422261
123 27/06/2013 13.0235 12.7651 12.765117047
124 28/06/2013 13.0279 12.7678 12.767811833
125 01/07/2013 12.9131 12.7705 12.770506619
126 02/07/2013 12.9850 12.7732 12.773201405
127 03/07/2013 13.0377 12.7759 12.77589619
128 04/07/2013 12.8902 12.7786 12.778590976
129 05/07/2013 13.0567 12.7813 12.781285762
130 08/07/2013 12.9267 12.7840 12.783980548
131 09/07/2013 12.8654 12.7867 12.786675334
132 10/07/2013 12.9494 12.7894 12.78937012
133 11/07/2013 12.8599 12.7921 12.792064905
134 12/07/2013 12.8234 12.7948 12.794759691
135 15/07/2013 12.7387 12.7975 12.797454477
136 16/07/2013 12.6299 12.8001 12.800149263
137 17/07/2013 12.5455 12.8028 12.802844049
138 18/07/2013 12.4976 12.8055 12.805538834
139 19/07/2013 12.5499 12.8082 12.80823362
140 22/07/2013 12.5054 12.8109 12.810928406
141 23/07/2013 12.5093 12.8136 12.813623192
142 24/07/2013 12.6330 12.8163 12.816317978
143 25/07/2013 12.6468 12.8190 12.819012764
144 26/07/2013 12.7091 12.8217 12.821707549
145 29/07/2013 12.7321 12.8244 12.824402335
146 30/07/2013 12.7635 12.8271 12.827097121
147 31/07/2013 12.8464 12.8298 12.829791907
148 01/08/2013 12.8068 12.8325 12.832486693
149 02/08/2013 12.6904 12.8352 12.835181478
150 05/08/2013 12.6759 12.8379 12.837876264
151 06/08/2013 12.6445 12.8406 12.84057105
152 07/08/2013 12.6989 12.8433 12.843265836
153 08/08/2013 12.6460 12.8460 12.845960622
154 09/08/2013 12.5889 12.8487 12.848655408
155 12/08/2013 12.5666 12.8514 12.851350193
156 13/08/2013 12.7545 12.8540 12.854044979
157 14/08/2013 12.7255 12.8567 12.856739765
158 15/08/2013 12.8625 12.8594 12.859434551
159 16/08/2013 12.8722 12.8621 12.862129337
160 19/08/2013 13.0124 12.8648 12.864824122
161 20/08/2013 13.0064 12.8675 12.867518908
162 21/08/2013 13.1424 12.8702 12.870213694
163 22/08/2013 13.1486 12.8729 12.87290848
164 23/08/2013 12.9979 12.8756 12.875603266
165 26/08/2013 13.1090 12.8783 12.878298052
166 27/08/2013 13.3366 12.8810 12.880992837
167 28/08/2013 13.2539 12.8837 12.883687623
168 29/08/2013 13.3104 12.8864 12.886382409
169 30/08/2013 13.3415 12.8891 12.889077195
170 02/09/2013 13.3070 12.8918 12.891771981
171 03/09/2013 13.4394 12.8945 12.894466766
172 04/09/2013 13.3065 12.8972 12.897161552
173 05/09/2013 13.4079 12.8999 12.899856338
174 06/09/2013 13.2413 12.9026 12.902551124
175 09/09/2013 13.1471 12.9052 12.90524591
176 10/09/2013 13.1119 12.9079 12.907940696
177 11/09/2013 13.0938 12.9106 12.910635481
178 12/09/2013 13.0854 12.9133 12.913330267
179 13/09/2013 13.0540 12.9160 12.916025053
180 17/09/2013 12.9241 12.9187 12.918719839
181 18/09/2013 12.9687 12.9214 12.921414625
182 19/09/2013 12.7179 12.9241 12.92410941
183 20/09/2013 12.7685 12.9268 12.926804196
184 23/09/2013 12.7846 12.9295 12.929498982
185 24/09/2013 12.8754 12.9322 12.932193768
186 25/09/2013 12.9530 12.9349 12.934888554
187 26/09/2013 13.0119 12.9376 12.93758334
188 27/09/2013 13.1450 12.9403 12.940278125
189 30/09/2013 13.1747 12.9430 12.942972911
190 01/10/2013 13.1294 12.9457 12.945667697
191 02/10/2013 13.1593 12.9484 12.948362483
192 03/10/2013 13.2663 12.9511 12.951057269
193 04/10/2013 13.0976 12.9538 12.953752055
194 07/10/2013 13.0959 12.9564 12.95644684
195 08/10/2013 13.1417 12.9591 12.959141626
196 09/10/2013 13.2126 12.9618 12.961836412
197 10/10/2013 13.0913 12.9645 12.964531198
198 11/10/2013 13.0514 12.9672 12.967225984
199 14/10/2013 13.0492 12.9699 12.969920769
200 15/10/2013 12.9725 12.9726 12.972615555
201 16/10/2013 12.8816 12.9753 12.975310341
202 17/10/2013 12.7717 12.9780 12.978005127
203 18/10/2013 12.7988 12.9807 12.980699913
204 21/10/2013 12.9314 12.9834 12.983394699
205 22/10/2013 12.8713 12.9861 12.986089484
206 23/10/2013 12.9433 12.9888 12.98878427
207 24/10/2013 12.9916 12.9915 12.991479056
208 25/10/2013 12.8693 12.9942 12.994173842
209 28/10/2013 12.8948 12.9969 12.996868628
210 29/10/2013 12.8903 12.9996 12.999563413
211 30/10/2013 12.8640 13.0023 13.002258199
212 31/10/2013 13.0067 13.0050 13.004952985
213 01/11/2013 13.0789 13.0076 13.007647771
214 04/11/2013 12.9869 13.0103 13.010342557
215 05/11/2013 13.1341 13.0130 13.013037343
216 06/11/2013 13.1388 13.0157 13.015732128
217 07/11/2013 13.1912 13.0184 13.018426914
218 08/11/2013 13.2412 13.0211 13.0211217
219 11/11/2013 13.2314 13.0238 13.023816486
220 12/11/2013 13.1879 13.0265 13.026511272
221 13/11/2013 13.1030 13.0292 13.029206057
222 14/11/2013 13.0173 13.0319 13.031900843
223 15/11/2013 12.9524 13.0346 13.034595629
224 19/11/2013 12.8869 13.0373 13.037290415
225 20/11/2013 12.9697 13.0400 13.039985201
226 21/11/2013 13.0617 13.0427 13.042679987
227 22/11/2013 13.0223 13.0454 13.045374772
228 25/11/2013 13.0267 13.0481 13.048069558
229 26/11/2013 13.0745 13.0508 13.050764344
230 27/11/2013 13.0925 13.0535 13.05345913
231 28/11/2013 13.0836 13.0562 13.056153916
232 29/11/2013 13.1101 13.0588 13.058848701
233 02/12/2013 13.2041 13.0615 13.061543487
234 03/12/2013 13.2372 13.0642 13.064238273
235 04/12/2013 13.0826 13.0669 13.066933059
236 05/12/2013 13.0057 13.0696 13.069627845
237 06/12/2013 12.9299 13.0723 13.072322631
238 09/12/2013 12.8612 13.0750 13.075017416
239 10/12/2013 12.8574 13.0777 13.077712202
240 11/12/2013 12.9342 13.0804 13.080406988
241 13/12/2013 12.9515 13.0831 13.083101774
242 16/12/2013 12.9439 13.0858 13.08579656
243 17/12/2013 12.9575 13.0885 13.088491345
244 18/12/2013 12.9937 13.0912 13.091186131
245 19/12/2013 12.9730 13.0939 13.093880917
246 20/12/2013 12.9574 13.0966 13.096575703
247 23/12/2013 12.9610 13.0993 13.099270489
248 24/12/2013 13.0200 13.1020 13.101965275
249 26/12/2013 13.0547 13.1047 13.10466006
250 27/12/2013 13.0765 13.1074 13.107354846
251 30/12/2013 13.0652 13.1100 13.110049632
252 31/12/2013 13.0843 13.1127 13.112744418
253 02/01/2014 13.1011 13.1154 13.115439204
254 03/01/2014 13.0911 13.1181 13.118133989
255 06/01/2014 13.0905 13.1208 13.120828775
256 07/01/2014 13.0337 13.1235 13.123523561
257 08/01/2014 13.0846 13.1262 13.126218347
258 09/01/2014 13.1403 13.1289 13.128913133
259 10/01/2014 13.0065 13.1316 13.131607919
260 13/01/2014 12.9889 13.1343 13.134302704
261 14/01/2014 13.0956 13.1370 13.13699749
262 15/01/2014 13.1689 13.1397 13.139692276
263 16/01/2014 13.2907 13.1424 13.142387062
264 17/01/2014 13.2737 13.1451 13.145081848
265 20/01/2014 13.2420 13.1478 13.147776634
266 21/01/2014 13.2984 13.1505 13.150471419
267 22/01/2014 13.3194 13.1532 13.153166205
268 23/01/2014 13.3722 13.1559 13.155860991
269 24/01/2014 13.4930 13.1586 13.158555777
270 27/01/2014 13.4408 13.1613 13.161250563
271 28/01/2014 13.3104 13.1639 13.163945348
272 29/01/2014 13.3671 13.1666 13.166640134
273 30/01/2014 13.3207 13.1693 13.16933492
274 31/01/2014 13.3769 13.1720 13.172029706
275 04/02/2014 13.3928 13.1747 13.174724492
276 05/02/2014 13.3705 13.1774 13.177419278
277 06/02/2014 13.2211 13.1801 13.180114063
278 07/02/2014 13.3285 13.1828 13.182808849
279 10/02/2014 13.3134 13.1855 13.185503635
280 11/02/2014 13.2916 13.1882 13.188198421
281 12/02/2014 13.3056 13.1909 13.190893207
282 13/02/2014 13.3320 13.1936 13.193587992
283 14/02/2014 13.2477 13.1963 13.196282778
284 17/02/2014 13.1949 13.1990 13.198977564
285 18/02/2014 13.2261 13.2017 13.20167235
286 19/02/2014 13.2714 13.2044 13.204367136
287 20/02/2014 13.2913 13.2071 13.207061922
288 21/02/2014 13.2704 13.2098 13.209756707
289 24/02/2014 13.2090 13.2125 13.212451493
290 25/02/2014 13.2248 13.2151 13.215146279
291 26/02/2014 13.2992 13.2178 13.217841065
292 27/02/2014 13.3066 13.2205 13.220535851
293 28/02/2014 13.2379 13.2232 13.223230636
294 03/03/2014 13.3201 13.2259 13.225925422
295 04/03/2014 13.2752 13.2286 13.228620208
296 05/03/2014 13.2519 13.2313 13.231314994
297 06/03/2014 13.1476 13.2340 13.23400978
298 07/03/2014 13.1795 13.2367 13.236704566
299 10/03/2014 13.2248 13.2394 13.239399351
300 11/03/2014 13.2430 13.2421 13.242094137
301 12/03/2014 13.2659 13.2448 13.244788923
302 13/03/2014 13.2456 13.2475 13.247483709
303 14/03/2014 13.2340 13.2502 13.250178495
304 18/03/2014 13.1675 13.2529 13.25287328
305 19/03/2014 13.1695 13.2556 13.255568066
306 20/03/2014 13.2703 13.2583 13.258262852
307 21/03/2014 13.2200 13.2610 13.260957638
308 24/03/2014 13.2019 13.2637 13.263652424
309 25/03/2014 13.1349 13.2663 13.26634721
310 26/03/2014 13.1273 13.2690 13.269041995
311 27/03/2014 13.0837 13.2717 13.271736781
312 28/03/2014 13.0841 13.2744 13.274431567
313 31/03/2014 13.0549 13.2771 13.277126353
314 01/04/2014 13.0313 13.2798 13.279821139
315 02/04/2014 13.0991 13.2825 13.282515924
316 03/04/2014 13.1324 13.2852 13.28521071
317 04/04/2014 13.0345 13.2879 13.287905496
318 07/04/2014 13.0179 13.2906 13.290600282
319 13.2933 13.293295068
320 13.2960 13.295989854
321 13.2987 13.298684639
322 13.3014 13.301379425
323 13.3041 13.304074211
324 13.3068 13.306768997
 Fix Banxico: media móvil exponencial (EMA)
13.5000

13.2000 f(x) = − 1.76620710180417E-07 x³ + 8.78350004689363E-05 x² − 0.0091657271764954

+ 12.7795490712118

12.9000

Fix Banxico
Polynomial (Fix
12.6000 Estimación line

12.3000

12.0000

11.7000
31/12/201208/04/201309/07/201309/10/201314/01/2014
ncial (EMA)

-05 x² − 0.00916572717649545 x

Fix Banxico
Polynomial (Fix Banxico)
Estimación lineal (modelo)
 yt y't

Escoger Estimació Estimación

x FECHA una serie n linea lineal α β r2
de tiempo (directa) (modelo)

1 31/12/2012
2 02/01/2013
3 03/01/2013
4 04/01/2013
5 07/01/2013
6 08/01/2013
7 09/01/2013
8 10/01/2013
9 11/01/2013
10 14/01/2013
11 15/01/2013
12 16/01/2013
13 17/01/2013
14 18/01/2013
15 21/01/2013
16 22/01/2013
17 23/01/2013
18 24/01/2013
19 25/01/2013
20 28/01/2013
21 29/01/2013
22 30/01/2013
23 31/01/2013
24 01/02/2013
25 05/02/2013
26 06/02/2013
27 07/02/2013
28 08/02/2013
29 11/02/2013
30 12/02/2013
31 13/02/2013
32 14/02/2013
33 15/02/2013
34 18/02/2013
35 19/02/2013
36 20/02/2013
37 21/02/2013
38 22/02/2013
39 25/02/2013
40 26/02/2013
41 27/02/2013
42 28/02/2013
43 01/03/2013
44 04/03/2013
45 05/03/2013
46 06/03/2013
47 07/03/2013
48 08/03/2013
49 11/03/2013
50 12/03/2013
51 13/03/2013
52 14/03/2013
53 15/03/2013
54 19/03/2013
55 20/03/2013
56 21/03/2013
57 22/03/2013
58 25/03/2013
59 26/03/2013
60 27/03/2013
61 01/04/2013
62 02/04/2013
63 03/04/2013
64 04/04/2013
65 05/04/2013
66 08/04/2013
67 09/04/2013
68 10/04/2013
69 11/04/2013
70 12/04/2013
71 15/04/2013
72 16/04/2013
73 17/04/2013
74 18/04/2013
75 19/04/2013
 76 22/04/2013
77 23/04/2013
78 24/04/2013
79 25/04/2013
80 26/04/2013
81 29/04/2013
82 30/04/2013
83 02/05/2013
84 03/05/2013
85 06/05/2013
86 07/05/2013
87 08/05/2013
88 09/05/2013
89 10/05/2013
90 13/05/2013
91 14/05/2013
92 15/05/2013
93 16/05/2013
94 17/05/2013
95 20/05/2013
96 21/05/2013
97 22/05/2013
98 23/05/2013
99 24/05/2013
100 27/05/2013
101 28/05/2013
102 29/05/2013
103 30/05/2013
104 31/05/2013
105 03/06/2013
106 04/06/2013
107 05/06/2013
108 06/06/2013
109 07/06/2013
110 10/06/2013
111 11/06/2013
112 12/06/2013
113 13/06/2013
114 14/06/2013
115 17/06/2013
116 18/06/2013
117 19/06/2013
118 20/06/2013
119 21/06/2013
120 24/06/2013
121 25/06/2013
122 26/06/2013
123 27/06/2013
124 28/06/2013
125 01/07/2013
126 02/07/2013
127 03/07/2013
128 04/07/2013
129 05/07/2013
130 08/07/2013
131 09/07/2013
132 10/07/2013
133 11/07/2013
134 12/07/2013
135 15/07/2013
136 16/07/2013
137 17/07/2013
138 18/07/2013
139 19/07/2013
140 22/07/2013
141 23/07/2013
142 24/07/2013
143 25/07/2013
144 26/07/2013
145 29/07/2013
146 30/07/2013
147 31/07/2013
148 01/08/2013
149 02/08/2013
150 05/08/2013
151 06/08/2013
152 07/08/2013
153 08/08/2013
154 09/08/2013
155 12/08/2013
156 13/08/2013
157 14/08/2013
158 15/08/2013
159 16/08/2013
160 19/08/2013
161 20/08/2013
162 21/08/2013
163 22/08/2013
164 23/08/2013
165 26/08/2013
166 27/08/2013
167 28/08/2013
168 29/08/2013
169 30/08/2013
170 02/09/2013
171 03/09/2013
172 04/09/2013
173 05/09/2013
174 06/09/2013
175 09/09/2013
176 10/09/2013
177 11/09/2013
178 12/09/2013
179 13/09/2013
180 17/09/2013
181 18/09/2013
182 19/09/2013
183 20/09/2013
184 23/09/2013
185 24/09/2013
186 25/09/2013
187 26/09/2013
188 27/09/2013
189 30/09/2013
190 01/10/2013
191 02/10/2013
192 03/10/2013
193 04/10/2013
194 07/10/2013
195 08/10/2013
196 09/10/2013
197 10/10/2013
198 11/10/2013
199 14/10/2013
200 15/10/2013
201 16/10/2013
202 17/10/2013
203 18/10/2013
204 21/10/2013
205 22/10/2013
206 23/10/2013
207 24/10/2013
208 25/10/2013
209 28/10/2013
210 29/10/2013
211 30/10/2013
212 31/10/2013
213 01/11/2013
214 04/11/2013
215 05/11/2013
216 06/11/2013
217 07/11/2013
218 08/11/2013
219 11/11/2013
220 12/11/2013
221 13/11/2013
222 14/11/2013
223 15/11/2013
224 19/11/2013
225 20/11/2013
226 21/11/2013
227 22/11/2013
228 25/11/2013
229 26/11/2013
230 27/11/2013
231 28/11/2013
232 29/11/2013
233 02/12/2013
234 03/12/2013
235 04/12/2013
236 05/12/2013
237 06/12/2013
238 09/12/2013
239 10/12/2013
240 11/12/2013
241 13/12/2013
242 16/12/2013
243 17/12/2013
244 18/12/2013
245 19/12/2013
246 20/12/2013
247 23/12/2013
248 24/12/2013
249 26/12/2013
250 27/12/2013
251 30/12/2013
252 31/12/2013
253 02/01/2014
254 03/01/2014
255 06/01/2014
256 07/01/2014
257 08/01/2014
258 09/01/2014
259 10/01/2014
260 13/01/2014
261 14/01/2014
262 15/01/2014
263 16/01/2014
264 17/01/2014
265 20/01/2014
266 21/01/2014
267 22/01/2014
268 23/01/2014
269 24/01/2014
270 27/01/2014
271 28/01/2014
272 29/01/2014
273 30/01/2014
274 31/01/2014
275 04/02/2014
276 05/02/2014
277 06/02/2014
278 07/02/2014
279 10/02/2014
280 11/02/2014
281 12/02/2014
282 13/02/2014
283 14/02/2014
284 17/02/2014
285 18/02/2014
286 19/02/2014
287 20/02/2014
288 21/02/2014
289 24/02/2014
290 25/02/2014
291 26/02/2014
292 27/02/2014
293 28/02/2014
294 03/03/2014
295 04/03/2014
296 05/03/2014
297 06/03/2014
298 07/03/2014
299 10/03/2014
300 11/03/2014
301 12/03/2014
302 13/03/2014
303 14/03/2014
304 18/03/2014
305 19/03/2014
306 20/03/2014
307 21/03/2014
308 24/03/2014
309 25/03/2014
310 26/03/2014
311 27/03/2014
312 28/03/2014
313 31/03/2014
314 01/04/2014
315 02/04/2014
316 03/04/2014
317 04/04/2014
318 07/04/2014
319 #VALUE! 0
320 #VALUE! 0
321 #VALUE! 0
322 #VALUE! 0
323 #VALUE! 0
324 #VALUE! 0