Nothing Special   »   [go: up one dir, main page]

Practica-1 Excel G-A

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

INTERVALOS f F

12.0 - 18.0 4 4
18.0 - 24.0 3 7
24.0 - 30.0 5 12
30.0 - 36.0 7 19
36.0 - 42.0 6 25
25 
h H h% H%
0.16 0.16 16% 16%
0.12 0.28 12% 28%
0.2 0.48 20% 48%
0.28 0.76 28% 76%
0.24 1 24% 100%
1  100%  
TOS CUANTITATIVOS DISCRETOS
13 11 11 11 12 12
11 11 11 12 12 13
13 13 15 14 14 14
15

NOTAS f F h H h%
A 20 0 0 0 0 0.0%
B 19 0 0 0 0 0.0%
C 18 0 0 0 0 0.0%
D 17 0 0 0 0 0.0%
E 16 0 0 0 0 0.0%
F 15 2 2 0.065 0.065 6.5% Chart T
G 14 8 10 0.258 0.323 25.8% Colum

H 13 9 19 0.29 0.613 29.0%


I 12 4 23 0.129 0.742 12.9%
J 11 8 31 0.258 1 25.8%
K 10 0 31 0 1 0.0% 6.5%

TOTAL = 31 ----- 1 ----- 0.0%


100.0%
0.0% 0.0% 0.0% 0.0%
A B C D E F
11 11 14 14
13 13 13 13
14 14 14 13

H%
0.0%
0.0%
0.0%
0.0%
0.0%
6.5%Chart Title
32.3% Column G

61.3% 25.8%
29.0%
25.8%
74.2%
100.0% 12.9%
100.0% 6.5%

0.0% 0.0% -----


0.0% 0.0% 0.0%
B C D E F G H I J K
59.1 45 69.8 85 84.2 87.9
52.3 42.3 41.6 48.2 51 40.9
58.6 57.8 85.5 63.3 61.3 55.2
87.6 42.7 75.3 80.8 88.6 63.3
43.7 49.9 43.2 57.9 64.4 65.6

Min= 40.7 R= 48.9 TI= R/K


Max= 89.6 k= 6 TI= 8.15

K Lim-Inf Lim-Sup LS-Real f Chart Title


F
Anorex 1 40.7 48.9 48.8 11 Column11J
Flaco 2 48.9 57.1 57 826.0% 19
Medio 3 57.1 65.3 65.2
22.0%
13 32
Elevado 4 65.3 73.5 73.4 16.0% 3 35
10.0%
Gordo 5 73.5 81.7 81.6 5 406.0%

Obeso 6 81.7 89.9 89.8 10 50


TOTAL=
Anorex Flaco 50
Medio ----
Elevado Gordo O
40.7 60.4 83.2 46.9
54.3 57.2 67.7 57.9
88.8 80.3 89.6 52.8
55 77.5 57.6 78.8
58.7 89.3 42 51.5

≈ 8.2

t Title h H h% H% Mc
umn J
0.22 0.22 22.0% 22.0% 44.8
0.16 0.38 16.0% 38.0% 53
0.26 20.0%0.64 26.0% 64.0% 61.2
0.06 0.7 6.0% 70.0% 69.4
10.0%
6.0% 0.1 0.8 10.0% 80.0% 77.6
0.2 1 20.0% 100.0% 85.8
Elevado 100.0%
Gordo Obeso374.0% 100.0% ----- -----

You might also like