simulador en excel para datos agrupados medidas de posicion y tendencia centralssssssssss

8/17/2019 Simulador en EXCEL Para Datos Agrupados Medidas de Posicion y Tendencia Centralssssssssss

1/81

GRADOS DE ALCOHOL n 120

0.0 Min 00.0 Max 3

0.0 Rango 3

0.0 K 7.907040099 80.0 A 0.380.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.00.0 0.0000000.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.30.5

0.6

0.6

0.6 0.00 0.38 240.6 0.38 0.75 180.6 0.75 1.13 40.6 1.13 1.50 210.6 1.50 1.88 7

0.6 1.88 2.25 130.6 2.25 2.63 90.6 2.63 3.00 240.6

0.6

0.6

0.6

0.6

0.6


2/81

0.8

0.8

0.8

0.8

1.1

1.1

1.11.1

1.1

1.1

1.1

1.1

1.1

1.2

1.2

1.2

1.21.3

1.3

1.4

1.4

1.4

1.4

1.4

1.4

1.6

1.6

1.6

1.6

1.6

1.6

1.6

1.8

1.9

1.9

1.9

1.9

1.9

2.1

2.1

2.1

2.1

2.1

2.1


3/81

2.1

2.2

2.4

2.4

2.4

2.4

2.42.4

2.4

2.4

2.5

2.6

2.6

2.7

2.7

2.7

2.72.7

2.7

2.7

2.7

2.9

2.9

3

3

3

3

3

3

3

3

3

3

3

3


4/81

TALA DE !REC"E#C$A

Número de clases ímite inferio Límite superior Marca de clase

1 0.00 0.38 0.2

2 0.38 0.75 0.6

3 0.75 1.13 0.94 1.13 1.50 1.3

5 1.50 1.88 1.7

6 1.88 2.25 2.1

7 2.25 2.63 2.4

8 2.63 3.00 2.8

0.38

1.4


5/81


6/81


7/81

RADOS DE ALCOHOL

24 24 20% 20%

17 41 14% 34%

13 54 11% 45%12 66 10% 55%

13 79 11% 66%

8 87 7% 73%

11 98 9% 82%

22 120 18% 100%

120

Frecuenciaabsoluta f

Frecuencia absolutaacumulada

Frecuenciarelativa

frecuenciarelativa

acumulada


8/81


9/81


10/81

!"# n 120

17 Min 1717 Max 60

17 Rango 4317 K 7.907040099 817 A 5.3818

18

18

18

18

19

19

1919

21

21

21

21

21

21

21

22

2222

22

22

22

22

23

23

24

29

2929

29

29

30

31

31

32


11/81

32

32

32

33

33

33

3333

33

33

34

34

35

35

35

35

3536

36

36

36

38

38

38

38

38

38

38

42

42

42

42

42

43

43

44

45

45

45

46

46

46

46

46


12/81

46

46

46

46

46

46

4646

46

46

48

50

52

52

52

52

5252

53

54

54

54

54

54

54

55

55

55

55

55

55

56

56

56

60

60


13/81

Límite inferior Límite superior

1 0.00 0.38 0.2 24

2 0.38 0.75 0.6 173 0.75 1.13 0.9 13

4 1.13 1.50 1.3 12

5 1.50 1.88 1.7 13

6 1.88 2.25 2.1 8

7 2.25 2.63 2.4 11

8 2.63 3.00 2.8 22

120

Número declases

Marca declase $%&

Frecuenciaabsoluta $f)


14/81


15/81


16/81

'#M!()# *'* (*+#" *,'-*(#"

24 4.5

41 9.654 12.2

66 15.8

79 21.9

87 16.5

98 26.8

120 61.9

1./1

MED$A 1.4

Frecuenciaabsoluta

acumulada f %


17/81


18/81


19/81


20/81


21/81


22/81

&ESO n 120

19 Min 19

19.9 Max 51

20.2 Rango 32

20.5 K 7.907040099 8

22.1 A 4.0022.6

22.9

23.1

23.2

23.5

23.5

23.9 MED$A#A

24.0

24.1

24.5

24.924.9

24.9

25.0

25.0

25.0

25.0

25.2

25.4

25.6

25.825.8

26.0

26.1

26.1

26.2

26.3

26.3

26.3

26.4

26.8

27.227.2

27.2

27.2

28.5

29.0

29.5

29.6

30.1


23/81

30.1

30.1

30.1

30.2

30.2

30.2

30.230.2

30.4

30.5

30.5

30.5

30.6

30.6

30.6

30.6

30.8

30.931.2

31.2

31.2

31.2

32.0

32.1

32.5

33.2

33.5

33.6

33.9

34.0

34.1

34.1

34.2

34.2

34.9

35.1

35.1

35.2

35.235.2

35.2

35.2

35.2

35.2

35.2

35.4

36.2


24/81

36.5

36.8

37.0

37.6

38.2

38.3

39.239.2

39.2

39.2

39.4

39.5

39.5

39.5

39.7

39.8

40.1

40.140.2

40.2

40.3

40.7

41.4

42.6

43.1

43.7

47.9

51.0


25/81

Número de clases Límite inferior Límite superior

1 0.00 0.38 0.2 24

2 0.38 0.75 0.6 17

3 0.75 1.13 0.9 13

4 1.13 1.50 1.3 125 1.50 1.88 1.7 13

6 1.88 2.25 2.1 8

7 2.25 2.63 2.4 11

8 2.63 3.00 2.8 22

120

n'2 60

n 120

!()1 54

*( 12

A( 4L( 1.13

MED$A#A 3.13

Marca declase

Frecuencia absoluta

f


26/81


27/81


28/81

MED$A#A &ARA DATOS AGR"&A

24

41

54

6679

87

98

120

Frecuencia absolutaacumulada

n +, +- a/ao + -a /+,a o -a ,/a +!()1 +, -a *++nia a,o-a a/-aa

*++nia a,o-a + -a -a,+ + -a /+iaA( +, -a a/-i + -a -a,+ + -a /+ianaL( +, +- -/i+ +a- in*+io + -a -a,+ + -a


29/81


30/81


31/81

OS

oa, -a, *++nia,. + -a -a,+ an+io + -a -a,+ + -a /+iana.

*( +, -aa.

./+iana.


32/81


33/81


34/81

!"# n 120

19 Min 19

19.9 Max 51

20.2 Rango 32

20.5 K 7.907040099 822.1 A 4.00

22.6

22.9

23.1

23.2

23.5

23.5

23.9

24.0

24.1

24.524.9

24.9

24.9

25.0

25.0

25.0

25.0

25.2

25.4

25.625.8

25.8

26.0

26.1

26.1

26.2

26.3

26.3

26.3

26.4

26.827.2

27.2

27.2

27.2

28.5

29.0

29.5

29.6


35/81

30.1

30.1

30.1

30.1

30.2

30.2

30.230.2

30.2

30.4

30.5

30.5

30.5

30.6

30.6

30.6

30.6

30.830.9

31.2

31.2

31.2

31.2

32.0

32.1

32.5

33.2

33.5

33.6

33.9

34.0

34.1

34.1

34.2

34.2

34.9

35.1

35.1

35.235.2

35.2

35.2

35.2

35.2

35.2

35.2

35.4


36/81

36.2

36.5

36.8

37.0

37.6

38.2

38.339.2

39.2

39.2

39.2

39.4

39.5

39.5

39.5

39.7

39.8

40.140.1

40.2

40.2

40.3

40.7

41.4

42.6

43.1

43.7

47.9

51.0


37/81

1 0.00 0.38 0.2 24 24

2 0.38 0.75 0.6 17 41

3 0.75 1.13 0.9 13 544 1.13 1.50 1.3 12 66

5 1.50 1.88 1.7 13 79

6 1.88 2.25 2.1 8 87

7 2.25 2.63 2.4 11 98

8 2.63 3.00 2.8 22 120

120

*()1 0

*(1 17

A( 4

L( 0 35.2MODA 0

Número declases

Límiteinferior

Límitesuperior

Marca declase


Frecuenciaabsoluta

acumulada


38/81


39/81


40/81

M#(* *'* (*+#" *,'-*(#"

Don+*()1 +, -a *++nia a,o-a + -a -a,+ an+io +n on+ ,+ +n+na +- ao/:, *++n+.*(1 +, -a *++nia a,o-a + -a -a,+ o,+io +n on+ ,+ +n+na +- ao/:, *++n+.A( +, -a a/-i + -a -a,+ +n on+ ,+ +n+na +- ao /:, *++n+.L( +, +- -/i+ +a- in*+io + -a -a,+ +n on+ ,+ +n+na +- ao /:, *++n+.


41/81


42/81


43/81


44/81


45/81


46/81

&ESO n 120

19 Min 19

19.9 Max 51

20.2 Rango 32

20.5 K 7.907040099 8

22.1 A 4.0022.6

22.9

23.1

23.2

23.5

23.5

23.9 &ERCE#T$L 30% ; 27

24.0

24.1

24.5

24.924.9

24.9

25.0

25.0

25.0

25.0

25.2

25.4

25.6

25.825.8

26.0

26.1

26.1

26.2

26.3

26.3

26.3

26.4

26.8

27.227.2

27.2

27.2

28.5

29.0

29.5

29.6

30.1


47/81

30.1

30.1

30.1

30.2

30.2

30.2

30.230.2

30.4

30.5

30.5

30.5

30.6

30.6

30.6

30.6

30.8

30.931.2

31.2

31.2

31.2

32.0

32.1

32.5

33.2

33.5

33.6

33.9

34.0

34.1

34.1

34.2

34.2

34.9

35.1

35.1

35.2

35.235.2

35.2

35.2

35.2

35.2

35.2

35.4

36.2


48/81

36.5

36.8

37.0

37.6

38.2

38.3

39.239.2

39.2

39.2

39.4

39.5

39.5

39.5

39.7

39.8

40.1

40.140.2

40.2

40.3

40.7

41.4

42.6

43.1

43.7

47.9

51.0


49/81

mero de clasímite inferioímite superi

1 0.00 0.38 0.2 24 24

2 0.38 0.75 0.6 17 41

3 0.75 1.13 0.9 13 54

4 1.13 1.50 1.3 12 665 1.50 1.88 1.7 13 79

6 1.88 2.25 2.1 8 87

7 2.25 2.63 2.4 11 98

8 2.63 3.00 2.8 22 120

120

K


50/81


51/81


52/81

L( ; L/i+ +a- in*+io + -a -a,+ +- ++ni- (n ; #>/+o + ao,!( ; !++nia a/-aa + -a -a,+ ?+ an+++ a -a -a,+*( ; !++nia + -a -a,+ +- ++ni- ( ; Longi +- in+@a-o + -a -a,+ +- ++ni- (


53/81


54/81


55/81

+- ++ni- (.


56/81


57/81


58/81

GRADOS DE ALCOHOL n 120

0.0 Min 00.0 Max 30.0 Rango 3

0.0 K 7.9070401 80.0 A 0.380.0

0.0

0.0

0.0

0.0

0.0

0.0 &R$MER C"ART$L ; 26.170.0

0.0 &i/+ Cai- 0.60.0 S+gno Cai- 1.350.0 T++ Cai- 2.40.0

0.0

0.0

0.0 1.350.0 M+iana 1.40.0

0.0

0.30.5

0.6

0.6

0.6

0.6

0.6

0.6

0.6

0.6

0.60.6

0.6

0.6

0.6

0.6

0.6

0.6


59/81

0.8

0.8

0.8

0.8

1.1

1.1

1.11.1

1.1

1.1

1.1

1.1

1.1

1.2

1.2

1.2

1.21.3

1.3

1.4

1.4

1.4

1.4

1.4

1.4

1.6

1.6

1.6

1.6

1.6

1.6

1.6

1.8

1.9

1.9

1.9

1.9

1.9

2.1

2.1

2.1

2.1

2.1

2.1


60/81

2.1

2.2

2.4

2.4

2.4

2.4

2.42.4

2.4

2.4

2.5

2.6

2.6

2.7

2.7

2.7

2.72.7

2.7

2.7

2.7

2.9

2.9

3

3

3

3

3

3

3

3

3

3

3

3


61/81

ero de clamite inferi ímite superi

1 0.00 0.38 0.2 24

2 0.38 0.75 0.6 17

3 0.75 1.13 0.9 134 1.13 1.50 1.3 12

5 1.50 1.88 1.7 13

6 1.88 2.25 2.1 8

7 2.25 2.63 2.4 11

8 2.63 3.00 2.8 22

120

A 0.38 A 0.38

n 120 n 120n'2 60 &o,iion D5 48

3n'4 90 &o,iion D7 84

n'4 30 ( 0/

1 0 (7 21

2 131

3 24

Marca declase



62/81


63/81


64/81

24

41

5466

79

87

98

120

A 0.38n 120

&o,iion &50 60

&o,iion &75 90

&50 1.31

&75 2.52

Frecuenciaabsoluta

acumulada

L( ; L/i+ +a- in*+io + -a -a,+ +- ++ni- (n ; #>/+o + ao,!( ; !++nia a/-aa + -a -a,+ ?+ an+++ a -a -*( ; !++nia + -a -a,+ +- ++ni- ( ; Longi +- in+@a-o + -a -a,+ +- ++ni- (


65/81


66/81


67/81

,+ +- ++ni- (.


68/81


69/81


70/81

n 120

&ESO Min 19

19 Max 47.9

19.9 Rango 28.9

20.2 K 7.907040099 8

20.5 A 3.6122.1

22.6

22.9

23.1

23.5

23.5

23.9 SE&T$MO DEC$L ; 35.89

24.0

24.1

24.5

24.924.9

24.9

25.0

25.0

25.0

25.0

25.2

25.4

25.6

25.825.8

26.0

26.1

26.1

26.2

26.3

26.3

26.3

26.4

26.8

27.227.2

27.2

27.2

28.5

29.0

29.5

29.6

30.1


71/81

30.1

30.1

30.1

30.2

30.2

30.2

30.230.2

30.4

30.5

30.5

30.5

30.6

30.6

30.6

30.6

30.8

30.931.2

31.2

31.2

31.2

32.0

32.1

32.5

33.2

33.5

33.6

33.9

34.0

34.1

34.1

34.2

34.2

34.9

35.1

35.1

35.2

35.235.2

35.2

35.2

35.2

35.2

35.2

35.4

36.2


72/81

36.5

36.8

37.0

37.6

38.2

38.3

39.239.2

39.2

39.2

39.4

39.5

39.5

39.5

39.7

39.8

40.1

40.140.2

40.2

40.3

40.7

41.4

42.6

43.1

43.7

47.9

51.0


73/81

mero de clasímite inferioímite superi

1 0.00 0.38 0.2 24 24

2 0.38 0.75 0.6 17 41

3 0.75 1.13 0.9 13 54

4 1.13 1.50 1.3 12 665 1.50 1.88 1.7 13 79

6 1.88 2.25 2.1 8 87

7 2.25 2.63 2.4 11 98

8 2.63 3.00 2.8 22 120

120

K


74/81


75/81


76/81

L( ; L /i+ +a- in*+io + -a -a,+ +- ++ni- (n ; #>/+o + ao,!( ; !++nia a/-aa + -a -a,+ ?+ an+++ a -a -a,+ +- +*( ; !++nia + -a -a,+ +- ++ni- ( ; Longi +- in+@a-o + -a -a,+ +- ++ni- (


77/81


78/81


79/81

ni- (.


80/81


81/81

simulador en excel para datos agrupados medidas de posicion y tendencia centralssssssssss

Documents