profesor correcto.xlsx
TRANSCRIPT
-
7/24/2019 PROFESOR correcto.xlsx
1/20
SUBGRUPO MEDIA L.C.S L.C L.C.I
1 214.18 215.52 213.966 212.41
2 213.48 215.52 213.966 212.41
3 213.98 215.52 213.966 212.41
4 214.12 215.52 213.966 212.41
5 214.46 215.52 213.966 212.41
6 213.38 215.52 213.966 212.41
7 213.56 215.52 213.966 212.41
8 214.08 215.52 213.966 212.41
9 213.72 215.52 213.966 212.41
10 214.64 215.52 213.966 212.41
11 213.92 215.52 213.966 212.41
12 213.96 215.52 213.966 212.41
13 214.20 215.52 213.966 212.41
14 213.74 215.52 213.966 212.41
15 214.26 215.52 213.966 212.41
16 214.18 215.52 213.966 212.41
17 214.00 215.52 213.966 212.41
18 213.60 215.52 213.966 212.41
19 214.20 215.52 213.966 212.41
20 214.38 215.52 213.966 212.41
21 213.78 215.52 213.966 212.41
22 213.74 215.52 213.966 212.41
23 213.32 215.52 213.966 212.41
24 214.02 215.52 213.966 212.41
25 214.24 215.52 213.966 212.41
213.966
-
7/24/2019 PROFESOR correcto.xlsx
2/20
RANGO
2.5
2.7
2.2
1.8
2.5
2.7
2.3
1.8
2.9
2.2
2.4
3.6
0.4
3.2
1.2
2.2
1.0
2.0
2.7
0.8
2.0
1.6
2.4
3.2
1.1
2.136
1 2 3 4 5 6 7 8 9 10 11 12210.00
211.00
212.00
213.00
214.00
215.00
216.00
C
MEDIA
MEDIAS
L.C.
L.C
213
L
-
7/24/2019 PROFESOR correcto.xlsx
3/20
13 14 15 16 17 18 19 20 21 22 23 24 25
RTA
L.C.S L.C L.C.I SUBGRUPO
=215.52
=
.966
.C= 212.41
-
7/24/2019 PROFESOR correcto.xlsx
4/20
SUBGRUPO RANGO L.C.S L.C L.C.I
1 2.5 4.87 2.136 0.00
2 2.7 4.87 2.136 0.00
3 2.2 4.87 2.136 0.00
4 1.8 4.87 2.136 0.00
5 2.5 4.87 2.136 0.006 2.7 4.87 2.136 0.00
7 2.3 4.87 2.136 0.00
8 1.8 4.87 2.136 0.00
9 2.9 4.87 2.136 0.00
10 2.2 4.87 2.136 0.00
11 2.4 4.87 2.136 0.00
12 3.6 4.87 2.136 0.00
13 0.4 4.87 2.136 0.00
14 3.2 4.87 2.136 0.00
15 1.2 4.87 2.136 0.0016 2.2 4.87 2.136 0.00
17 1.0 4.87 2.136 0.00
18 2.0 4.87 2.136 0.00
19 2.7 4.87 2.136 0.00
20 0.8 4.87 2.136 0.00
21 2.0 4.87 2.136 0.00
22 1.6 4.87 2.136 0.00
23 2.4 4.87 2.136 0.00
24 3.2 4.87 2.136 0.00
25 1.1 4.87 2.136 0.00
2.136
-
7/24/2019 PROFESOR correcto.xlsx
5/20
MEDIA
214.18
213.48
213.98
214.12
214.46213.38
213.56
214.08
213.72
214.64
213.92
213.96
214.20
213.74
214.26214.18
214.00
213.60
214.20
214.38
213.78
213.74
213.32
214.02
214.24
213.966
1 2 3 4 5 6 7 8 9 10 11-
1.0
2.0
3.0
4.0
5.0
6.0
R
RANGO
-
7/24/2019 PROFESOR correcto.xlsx
6/20
}
12 13 14 15 16 17 18 19 20 21 22 23 24 25
CARTA
NGO L.C.S L.C L.C.I
L.C.S =4.87
L.C.I =0.00
L.C = 2.136
-
7/24/2019 PROFESOR correcto.xlsx
7/20
-
7/24/2019 PROFESOR correcto.xlsx
8/20
SUBGRUPO MEDIA L.C.S L.C L.C.I
1 301.12 302.28 300.775 299.27
2 300.96 302.28 300.775 299.27
3 301.16 302.28 300.775 299.27
4 300.50 302.28 300.775 299.27
5 301.28 302.28 300.775 299.27
6 299.92 302.28 300.775 299.27
7 300.00 302.28 300.775 299.27
8 301.86 302.28 300.775 299.27
9 301.52 302.28 300.775 299.27
10 302.80 302.28 300.775 299.27
11 299.01 302.28 300.775 299.27
12 300.02 302.28 300.775 299.27
13 300.10 302.28 300.775 299.27
14 301.28 302.28 300.775 299.27
15 301.02 302.28 300.775 299.27
16 300.70 302.28 300.775 299.27
17 301.20 302.28 300.775 299.27
18 300.96 302.28 300.775 299.27
19 300.24 302.28 300.775 299.27
20 301.86 302.28 300.775 299.27
21 302.00 302.28 300.775 299.27
22 299.02 302.28 300.775 299.27
23 299.50 302.28 300.775 299.27
24 300.30 302.28 300.775 299.27
25 301.64 302.28 300.775 299.27
26 300.88 302.28 300.775 299.27
27 301.28 302.28 300.775 299.27
28 300.75 302.28 300.775 299.27
29 301.60 302.28 300.775 299.27
30 300.53 302.28 300.775 299.27
31 300.41 302.28 300.775 299.27
32 300.19 302.28 300.775 299.27
33 301.12 302.28 300.775 299.27
34 300.80 302.28 300.775 299.27
35 300.27 302.28 300.775 299.27
36 300.91 302.28 300.775 299.27
37 300.48 302.28 300.775 299.27
38 302.00 302.28 300.775 299.27
39 299.22 302.28 300.775 299.27
40 300.59 302.28 300.775 299.27
300.775
-
7/24/2019 PROFESOR correcto.xlsx
9/20
RANGO
1.9
1.0
3.6
1.0
2.5
2.3
2.3
1.5
2.3
0.4
3.0
2.5
2.3
3.4
1.1
3.9
3.1
3.1
3.7
2.7
4.6
3.5
3.1
2.3
3.4
2.9
1.8
1.5
3.1
2.8
1.4
2.1
3.4
3.2
3.4
2.7
3.2
1.8
3.5
3.0
2.61
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1297.00
298.00
299.00
300.00
301.00
302.00
303.00
304.00
MED
-
7/24/2019 PROFESOR correcto.xlsx
10/20
17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
Chart Title
IA L.C.S L.C L.C.I
-
7/24/2019 PROFESOR correcto.xlsx
11/20
SUBGRUPO RANGO L.C.S L.C L.C.I
1 1.9 5.51 2.61 0.00
2 1.0 5.51 2.61 0.00
3 3.6 5.51 2.61 0.00
4 1.0 5.51 2.61 0.00
5 2.5 5.51 2.61 0.00
6 2.3 5.51 2.61 0.00
7 2.3 5.51 2.61 0.00
8 1.5 5.51 2.61 0.00
9 2.3 5.51 2.61 0.00
10 0.4 5.51 2.61 0.00
11 3.0 5.51 2.61 0.00
12 2.5 5.51 2.61 0.00
13 2.3 5.51 2.61 0.00
14 3.4 5.51 2.61 0.00
15 1.1 5.51 2.61 0.00
16 3.9 5.51 2.61 0.00
17 3.1 5.51 2.61 0.00
18 3.1 5.51 2.61 0.00
19 3.7 5.51 2.61 0.00
20 2.7 5.51 2.61 0.00
21 4.6 5.51 2.61 0.00
22 3.5 5.51 2.61 0.00
23 3.1 5.51 2.61 0.00
24 2.3 5.51 2.61 0.00
25 3.4 5.51 2.61 0.00
26 2.9 5.51 2.61 0.00
27 1.8 5.51 2.61 0.00
28 1.5 5.51 2.61 0.00
29 3.1 5.51 2.61 0.00
30 2.8 5.51 2.61 0.00
31 1.4 5.51 2.61 0.00
32 2.1 5.51 2.61 0.00
33 3.4 5.51 2.61 0.00
34 3.2 5.51 2.61 0.00
35 3.4 5.51 2.61 0.00
36 2.7 5.51 2.61 0.00
37 3.2 5.51 2.61 0.00
38 1.8 5.51 2.61 0.00
39 3.5 5.51 2.61 0.00
40 3.0 5.51 2.61 0.00
2.61
-
7/24/2019 PROFESOR correcto.xlsx
12/20
MEDIA
301.12
300.96
301.16
300.50
301.28
299.92
300.00
301.86
301.52
302.80
299.01
300.02
300.10
301.28
301.02
300.70
301.20
300.96
300.24
301.86
302.00
299.02
299.50
300.30
301.64
300.88
301.28
300.75
301.60
300.53
300.41
300.19
301.12
300.80
300.27
300.91
300.48
302.00
299.22
300.59
300.775
1 2 3 4 5 6 7 8 9 10-
1.0
2.0
3.0
4.0
5.0
6.0
-
7/24/2019 PROFESOR correcto.xlsx
13/20
1 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
Chart Title
RANGO L.C.S L.C L.C.I
-
7/24/2019 PROFESOR correcto.xlsx
14/20
39 40
-
7/24/2019 PROFESOR correcto.xlsx
15/20
SUBGRUPO MEDIA L.C.S L.C L.C.I
1 -2.8 15.77 0.59 -14.58
2 3.6 15.77 0.59 -14.58
3 -3.4 15.77 0.59 -14.58
4 10.2 15.77 0.59 -14.58
5 1.0 15.77 0.59 -14.58
6 1.4 15.77 0.59 -14.58
7 0.8 15.77 0.59 -14.58
8 -2.2 15.77 0.59 -14.58
9 5.4 15.77 0.59 -14.58
10 -1.0 15.77 0.59 -14.58
11 5.8 15.77 0.59 -14.58
12 - 15.77 0.59 -14.58
13 -2.2 15.77 0.59 -14.58
14 -0.6 15.77 0.59 -14.58
15 0.8 15.77 0.59 -14.58
16 6.0 15.77 0.59 -14.58
17 4.2 15.77 0.59 -14.58
18 -5.6 15.77 0.59 -14.58
19 -3.8 15.77 0.59 -14.58
20 -1.0 15.77 0.59 -14.58
21 2.2 15.77 0.59 -14.58
22 -7.6 15.77 0.59 -14.58
23 4.4 15.77 0.59 -14.58
24 -1.4 15.77 0.59 -14.58
25 5.8 15.77 0.59 -14.58
26 -1.6 15.77 0.59 -14.58
27 0.2 15.77 0.59 -14.58
28 3.4 15.77 0.59 -14.58
29 -3.0 15.77 0.59 -14.58
30 -1.2 15.77 0.59 -14.58
0.59
-
7/24/2019 PROFESOR correcto.xlsx
16/20
RANGO
42
40
20
30
33
19
16
22
11
40
20
26
26
24
20
20
13
24
20
27
8
43
42
31
18
41
36
21
25
31
26.3
1 2 3 4 5 6 7 8 9 10
-20.0
-15.0
-10.0
-5.0
-
5.0
10.0
15.0
20.0
MEDI
-
7/24/2019 PROFESOR correcto.xlsx
17/20
1112131415161718192021222324252627282930
Ch!" T#"$%
A L.C.S L.C L.C.I
-
7/24/2019 PROFESOR correcto.xlsx
18/20
SUBGRUPO RANGO L.C.S L.C L.C.I
1 42 55.61 26.30 -
2 40 55.61 26.30 0.00
3 20 55.61 26.30 0.00
4 30 55.61 26.30 0.00
5 33 55.61 26.30 0.00
6 19 55.61 26.30 0.00
7 16 55.61 26.30 0.00
8 22 55.61 26.30 0.00
9 11 55.61 26.30 0.00
10 40 55.61 26.30 0.00
11 20 55.61 26.30 0.00
12 26 55.61 26.30 0.00
13 26 55.61 26.30 0.00
14 24 55.61 26.30 0.00
15 20 55.61 26.30 0.00
16 20 55.61 26.30 0.00
17 13 55.61 26.30 0.00
18 24 55.61 26.30 0.00
19 20 55.61 26.30 0.00
20 27 55.61 26.30 0.00
21 8 55.61 26.30 0.00
22 43 55.61 26.30 0.00
23 42 55.61 26.30 0.00
24 31 55.61 26.30 0.00
25 18 55.61 26.30 0.00
26 41 55.61 26.30 0.00
27 36 55.61 26.30 0.00
28 21 55.61 26.30 0.00
29 25 55.61 26.30 0.00
30 31 55.61 26.30 0.00
26.3
-
7/24/2019 PROFESOR correcto.xlsx
19/20
MEDIA
-2.8
3.6
-3.4
10.2
1.0
1.4
0.8
-2.2
5.4
-1.0
5.8
-
-2.2
-0.6
0.8
6.0
4.2
-5.6
-3.8
-1.0
2.2
-7.6
4.4
-1.4
5.8
-1.6
0.2
3.4
-3.0
-1.2
0.59
1 2 3 4 5 6 7 8 9 10 11 1-
10
20
30
40
50
60
RAN
-
7/24/2019 PROFESOR correcto.xlsx
20/20
2 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Ch!" T#"$%
O L.C.S L.C L.C.I