7/23/2019 Simulacion Unidad 3
1/3
9.80326 10.08961 14.47546 10.91758 8.22404
14.41886 8.67213 13.26118 8.47558 10.11251
8.22803 13.66977 12.66724 10.06239 11.77816
14.1583 8.78493 12.16357 13.13076 12.86161
8.97695 11.52561 11.52561 9.06306 14.36234
c1 c2
datos i Yi Yn+1-i
media 9.80326 1 8.22404 14.47546
11.2563416 14.41886 2 8.22803 14.41886
desvestd 8.22803 3 8.47558 14.36234
2.16804266 14.1583 4 8.67213 14.1583
8.97695 5 8.78493 13.66977
10.08961 6 8.97695 13.26118
8.67213 7 9.06306 13.13076
13.66977 8 9.80326 12.86161
8.78493 9 10.06239 12.66724
11.52561 10 10.06239 12.16357
14.47546 11 10.08961 11.77816
13.26118 12 10.11251 11.52561
12.66724 13 11.52561 11.52561
12.16357 14 11.52561 10.11251
10.06239 15 11.77816 10.08961
11.52561 16 12.16357 10.06239
8.47558 17 12.66724 10.06239
10.06239 18 12.86161 9.80326
13.13076 19 13.13076 9.06306
9.06306 20 13.26118 8.97695
8.22404 21 13.66977 8.78493
10.11251 22 14.1583 8.67213
11.77816 23 14.36234 8.47558
12.86161 24 14.41886 8.22803
14.36234 25 14.47546 8.22404
7/23/2019 Simulacion Unidad 3
2/3
11.2563416 2.16804266
c3 c4 c5 c6 c7 c8
2i-1 PEA(Yn) 1-PEA(Yn+1-i) Ln(c4) Ln(c5) c3)*(c6+c7
1 0.08096115 0.0687978773 -2.51378592 -2.67658239 -5.1903683
3 #NAME? #NAME? #NAME? #NAME? #NAME?
5 #NAME? #NAME? #NAME? #NAME? #NAME?
7 #NAME? #NAME? #NAME? #NAME? #NAME?
9 #NAME? #NAME? #NAME? #NAME? #NAME?
11 #NAME? #NAME? #NAME? #NAME? #NAME?
13 #NAME? #NAME? #NAME? #NAME? #NAME?
15 #NAME? #NAME? #NAME? #NAME? #NAME?
17 #NAME? #NAME? #NAME? #NAME? #NAME?
19 #NAME? #NAME? #NAME? #NAME? #NAME?
21 #NAME? #NAME? #NAME? #NAME? #NAME?
23 #NAME? #NAME? #NAME? #NAME? #NAME?
25 #NAME? #NAME? #NAME? #NAME? #NAME?
27 #NAME? #NAME? #NAME? #NAME? #NAME?
29 #NAME? #NAME? #NAME? #NAME? #NAME?
31 #NAME? #NAME? #NAME? #NAME? #NAME?
33 #NAME? #NAME? #NAME? #NAME? #NAME?
35 #NAME? #NAME? #NAME? #NAME? #NAME?
37 #NAME? #NAME? #NAME? #NAME? #NAME?
39 #NAME? #NAME? #NAME? #NAME? #NAME?
41 #NAME? #NAME? #NAME? #NAME? #NAME?
43 #NAME? #NAME? #NAME? #NAME? #NAME?
45 #NAME? #NAME? #NAME? #NAME? #NAME?
47 #NAME? #NAME? #NAME? #NAME? #NAME?
49 #NAME? #NAME? #NAME? #NAME? #NAME?
-642.9047
