EJERCICIO DE BASE DE DATOS COMPUTACIONAL

Alumna: Araceli Trujillo RodríguezProfesor: Gerardo Edgar Mata

ESTADISTICA2° “D”

Ejercicio:

• 1.-Construya histogramas y distribuciones de frecuencias relativas para el tamaño promedio de pedidos por día para los últimos cuatro meses. En cada uno utilice anchos de intervalo de 20 y tome el primer intervalo de cero a 20.

No.CLASES CATEGORIAS O INTERVALOS

MARCAS DE CLASE FRECUENCIAS MEDIDAS DE TENDENCIA

LIMITE INFERIOR LIMITE SUPERIOR XI FI FAI FRI FRAI FIXI |XI-X|FI (XI-X)2FI

1 0 20 10 1 1 0.0054 1% 10 102.1505376 10434.73

2 20 40 30 4 5 0.0215 3% 120 328.6021505 107979.4

3 40 60 50 15 20 0.0806 11% 750 932.2580645 869105.1

4 60 80 70 42 62 0.2258 33% 2940 1770.322581 3134042

5 80 100 90 25 87 0.1344 47% 2250 553.7634409 306653.9

6 100 120 110 36 123 0.1935 66% 3960 77.41935484 5993.757

7 120 140 130 15 138 0.0806 74% 1950 267.7419355 71685.74

8 140 160 150 13 151 0.0699 81% 1950 492.0430108 242106.3

9 160 180 170 14 165 0.0753 89% 2380 809.8924731 655925.8

10 180 200 190 11 176 0.0591 95% 2090 856.344086 733325.2

11 200 220 210 3 179 0.0161 96% 630 293.5483871 86170.66

12 220 240 230 3 182 0.0161 98% 690 353.5483871 124996.5

13 240 260 250 0 182 0.0000 98% 0 0 0

14 260 280 270 2 184 0.0108 99% 540 315.6989247 99665.81

15 280 300 290 1 185 0.0054 99% 290 177.8494624 31630.43

16 300 320 310 1 186 0.0054 100% 310 197.8494624 39144.41

186 TOTALES 20860 7529.032258 6518860

x 112.15

Desv. Media 40.47866805

Varianza 35047.63

Desv. Est. 187.2101

TRIMESTRE 1:

0 50 100 150 200 250 300 3500

5

10

15

20

25

30

35

40

45

50

Series1

Histograma

TRIMESTRE 2:

No.CLASES CATEGORIAS O INTERVALOS MARCAS DE

CLASEFRECUENCIAS MEDIDAS DE TENDENCIA

LIMITE INFERIOR LIMITE SUPERIOR XI FI FAI FRI FRAI FIXI |XI-X|FI (XI-X)2FI

1 0 20 10 0 0 0.0000 0% 0 0 0

2 20 40 30 0 0 0.0000 0% 0 0 0

3 40 60 50 10 10 0.0538 5% 500 617.2043011 380941.1493

4 60 80 70 34 44 0.1828 24% 2380 1418.494624 2012126.997

5 80 100 90 40 84 0.2151 45% 3600 868.8172043 754843.3345

6 100 120 110 35 119 0.1882 64% 3850 60.21505376 3625.8527

7 120 140 130 30 149 0.1613 80% 3900 548.3870968 300728.4079

8 140 160 150 17 166 0.0914 89% 2550 650.7526882 423479.0612

9 160 180 170 10 176 0.0538 95% 1700 582.7956989 339650.8267

10 180 200 190 2 178 0.0108 96% 380 156.5591398 24510.76425

11 200 220 210 3 181 0.0161 97% 630 294.8387097 86929.86472

12 220 240 230 1 182 0.0054 98% 230 118.2795699 13990.05665

13 240 260 250 2 184 0.0108 99% 500 276.5591398 76484.9578

14 260 280 270 1 185 0.0054 99% 270 158.2795699 25052.42225

15 280 300 290 1 186 0.0054 100% 290 178.2795699 31783.60504

16 300 320 310 0 186 0.0000 100% 0 0 0

186 TOTALES 20780 5929.462366 4474147.3

x 111.72

Desv. Media 31.87882992

Varianza 24054.55538

Desv. Est. 155.0953106

0 50 100 150 200 250 300 3500

5

10

15

20

25

30

35

40

45

50

Series1

Histograma

TRIMESTRE 3:No.

CLASES CATEGORIAS O INTERVALOSMARCAS DE

CLASE FRECUENCIAS MEDIDAS DE TENDENCIA

LIMITE INFERIOR LIMITE SUPERIOR XI FI FAI FRI FRAI FIXI |XI-X|FI (XI-X)2FI

1 0 20 10 28 28 0.1505 15% 280 2685.591398 7212401.156

2 20 40 30 1 29 0.0054 16% 30 75.91397849 5762.932131

3 40 60 50 6 35 0.0323 19% 300 335.483871 112549.4277

4 60 80 70 26 61 0.1398 33% 1820 933.7634409 871914.1635

5 80 100 90 25 86 0.1344 46% 2250 397.8494624 158284.1947

6 100 120 110 26 112 0.1398 60% 2860 106.2365591 11286.2065

7 120 140 130 24 136 0.1290 73% 3120 578.0645161 334158.5848

8 140 160 150 17 153 0.0914 82% 2550 749.4623656 561693.8374

9 160 180 170 12 165 0.0645 89% 2040 769.0322581 591410.6139

10 180 200 190 9 174 0.0484 94% 1710 756.7741935 572707.18

11 200 220 210 4 178 0.0215 96% 840 416.344086 173342.398

12 220 240 230 5 183 0.0269 98% 1150 620.4301075 384933.5183

13 240 260 250 3 186 0.0161 100% 750 432.2580645 186847.0343

14 260 280 270 0 186 0.0000 100% 0 0 0

15 280 300 290 0 186 0.0000 100% 0 0 0

16 300 320 310 0 186 0.0000 100% 0 0 0

186 TOTALES 19700 8857.204301 11177291.25

x 105.91

Desv. Media 47.61937796

Varianza 60092.9637

Desv. Est. 245.1386622

0 50 100 150 200 250 300 3500

5

10

15

20

25

30

35

40

45

Series1

Histograma

TRIMESTRE 4:

No.CLASES CATEGORIAS O INTERVALOS MARCAS

DE CLASEFRECUENCIAS MEDIDAS DE TENDENCIA

LIMITE INFERIOR LIMITE SUPERIOR XI FI FAI FRI FRAI FIXI |XI-X|FI (XI-X)2FI

1 0 20 10 0 0 0.0000 0% 0 0 0

2 20 40 30 0 0 0.0000 0% 0 0 0

3 40 60 50 20 20 0.1075 11% 1000 1197.849462 1434843

4 60 80 70 39 59 0.2097 32% 2730 1555.806452 2420534

5 80 100 90 29 88 0.1559 47% 2610 576.8817204 332792.5

6 100 120 110 28 116 0.1505 62% 3080 3.010752688 9.064632

7 120 140 130 28 144 0.1505 77% 3640 563.0107527 316981.1

8 140 160 150 16 160 0.0860 86% 2400 641.7204301 411805.1

9 160 180 170 12 172 0.0645 92% 2040 721.2903226 520259.7

10 180 200 190 5 177 0.0269 95% 950 400.5376344 160430.4

11 200 220 210 7 184 0.0376 99% 1470 700.7526882 491054.3

12 220 240 230 1 185 0.0054 99% 230 120.1075269 14425.82

13 240 260 250 0 185 0.0000 99% 0 0 0

14 260 280 270 0 185 0.0000 99% 0 0 0

15 280 300 290 1 186 0.0054 100% 290 180.1075269 32438.72

16 300 320 310 0 186 0.0000 100% 0 0 0

186 TOTALES 20440 6661.075269 6135574

x 109.89    

Desv. Media 35.81223263

Varianza 32986.96

Desv. Est. 181.6231

0 50 100 150 200 250 300 3500

5

10

15

20

25

30

35

40

45

50

Series1

Histograma