practica 24 sep 2014

2
TABLA 13.13 VALORES DE IPC DE LA BMV Y PRECIOS DE CIERRE DE LAS ACCIONES D FECHA IPC C SORIANA B 5/9/2011 35467.01 512.8 37.25 5/10/2011 35678.92 510.01 36.9 5/11/2011 35380.53 501 37.5 5/12/2011 35161.26 493.57 38.26 5/13/2011 35045.14 487.1 37.14 5/16/2011 35130.6 483.91 37.09 5/17/2011 34819.57 486.15 37.9 5/18/2011 35364.33 482.99 38.25 5/19/2011 35276.47 481 37 5/20/2011 35298.67 478.1 37.6 5/23/2011 35215.02 470.89 37.05 5/24/2011 35382.56 474.57 36.5 5/25/2011 35498.42 471.54 36.02 5/26/2011 35742.21 469.42 36.11 5/27/2011 35819.29 475.65 36.5 5/30/2011 35639.38 470 36.6 5/31/2011 35832.79 475.2 36 6/1/2011 35410.51 464.57 36.36 6/2/2011 35416.25 466.26 35.6 6/3/2011 35123.89 464.32 35.4 6/6/2011 34673.48 447.4 34.66 6/7/2011 34895.83 442 35.41 6/8/2011 34879.07 436 34.9 6/9/2011 35233.4 444.91 35.2 6/10/2011 34963.78 451.64 34.88 6/13/2011 34997.97 465.01 34.29 6/14/2011 35445.65 457.34 35.1 6/15/2011 35318.39 452.16 34.5 6/16/2011 35220.99 449.87 34.2 6/17/2011 35025.74 456.41 33.71 6/20/2011 35109.97 452.8 33.5 6/21/2011 35276.6 463.05 34.45 6/22/2011 35399.44 466.4 34.12 6/23/2011 35326.66 466.8 33.55 6/24/2011 35347.85 471.7 33.76 6/27/2011 35601.73 476.5 34.68 6/28/2011 36188.91 474.5 35.15 6/29/2011 36579.59 487.79 35.5 6/30/2011 36558.07 487.49 35.11 7/1/2011 36800.72 498.99 35.31 7/4/2011 36847.1 500 35.25 7/5/2011 36640.93 493.9 35 7/6/2011 36468.01 487.57 34.85 7/7/2011 36583.29 492 34.44 12/3 0 5000 10000 15000 20000 25000 30000 35000 40000 Axis Title 430 31 32 33 34 35 36 37 38 39 Axis Title

Upload: paloma26

Post on 14-Dec-2015

218 views

Category:

Documents


2 download

DESCRIPTION

Cálculos de Excel

TRANSCRIPT

Page 1: Practica 24 Sep 2014

TABLA 13.13 VALORES DE IPC DE LA BMV Y PRECIOS DE CIERRE DE LAS ACCIONES DE C Y SORIANA

FECHA IPC C SORIANA B5/9/2011 35467.01 512.8 37.25

5/10/2011 35678.92 510.01 36.95/11/2011 35380.53 501 37.55/12/2011 35161.26 493.57 38.265/13/2011 35045.14 487.1 37.145/16/2011 35130.6 483.91 37.095/17/2011 34819.57 486.15 37.95/18/2011 35364.33 482.99 38.255/19/2011 35276.47 481 375/20/2011 35298.67 478.1 37.65/23/2011 35215.02 470.89 37.055/24/2011 35382.56 474.57 36.55/25/2011 35498.42 471.54 36.025/26/2011 35742.21 469.42 36.115/27/2011 35819.29 475.65 36.55/30/2011 35639.38 470 36.65/31/2011 35832.79 475.2 36

6/1/2011 35410.51 464.57 36.366/2/2011 35416.25 466.26 35.66/3/2011 35123.89 464.32 35.46/6/2011 34673.48 447.4 34.666/7/2011 34895.83 442 35.416/8/2011 34879.07 436 34.96/9/2011 35233.4 444.91 35.2

6/10/2011 34963.78 451.64 34.886/13/2011 34997.97 465.01 34.296/14/2011 35445.65 457.34 35.16/15/2011 35318.39 452.16 34.56/16/2011 35220.99 449.87 34.26/17/2011 35025.74 456.41 33.716/20/2011 35109.97 452.8 33.56/21/2011 35276.6 463.05 34.456/22/2011 35399.44 466.4 34.126/23/2011 35326.66 466.8 33.556/24/2011 35347.85 471.7 33.766/27/2011 35601.73 476.5 34.686/28/2011 36188.91 474.5 35.156/29/2011 36579.59 487.79 35.56/30/2011 36558.07 487.49 35.11

7/1/2011 36800.72 498.99 35.317/4/2011 36847.1 500 35.257/5/2011 36640.93 493.9 357/6/2011 36468.01 487.57 34.857/7/2011 36583.29 492 34.44

12/30/1899 11/21/20360

5000

10000

15000

20000

25000

30000

35000

40000

Column BLinear (Column B)Column CLinear (Column C)

Axis Title

Axis Title

430 440 450 460 470 480 490 500 510 52031

32

33

34

35

36

37

38

39

Column DLinear (Column D)

Axis Title

Axis Title

Page 2: Practica 24 Sep 2014

12/30/1899 11/21/20360

5000

10000

15000

20000

25000

30000

35000

40000

Column BLinear (Column B)Column CLinear (Column C)

Axis Title

Axis Title

430 440 450 460 470 480 490 500 510 52031

32

33

34

35

36

37

38

39

Column DLinear (Column D)

Axis Title

Axis Title