Estadistica 2

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

kilos 1 2 3 4

3533 60424 910989 118968


38121 74378 938788 1275758
4090 9475 96578667 1245445
43696 687878 994545 1278933
4648 715758 10245642 1301221
49272 743636 105030303 132909
52060 77151 10781890 135697
5484 79939 11067978 138485
57636 82727 1136394 1412737
8830343 8551152 1161823 144061
total 9088883 11082518 238847019 7184214

n (xi-X)^2 (xi-X) xi
3533 12387121481845.10 3519534.270588 1
4090 991836728100.00 995910 2
4648 397343643904.00 630352 3
5484 11029470513093800.00 105021286 4
9475 29458393851993400000000000000.00 1.71634477E+14 5
19981 171111337173654.00 13080953.22114 6
20818 23720335609122.40 4870352.71917 7
23768 547379292.17 23396.13840285 8
25836 667167291.87 25829.58172078 9
26500 699953304.60 26456.63063587 10
26672 12815824849.00 113207 11
29697 366391721809.00 605303 12
32000 3008410463529.00 1734477 13
32000 1024000000.00 32000 14
34000 1156000000.00 34000 15
38121 1453210641.00 38121 16
43696 1909340416.00 43696 17
46000 2116000000.00 46000
49272 2427729984.00 49272
50000 2500000000.00 50000
52060 2710243600.00 52060
54000 2916000000.00 54000
57000 3249000000.00 57000
57636 3321908496.00 57636
60424 3651059776.00 60424

61300
3757690000.00 61300
65000
4225000000.00 65000

72600
5270760000.00 72600

74378
5532086884.00 74378

77151
5952276801.00 77151
78000 6084000000.00 78000
78300 6130890000.00 78300
79939 6390243721.00 79939
82000 6724000000.00 82000
82727 6843756529.00 82727
98000 9604000000.00 98000
118968 14153385024.00 118968
127800 16332840000.00 127800
132909 17664802281.00 132909
134500 18090250000.00 134500
134600 18117160000.00 134600
135697 18413675809.00 135697
138485 19178095225.00 138485
144061 20753571721.00 144061
146848 21564335104.00 146848
155212 24090764944.00 155212
160588 25788505744.00 160588
163576 26757107776.00 163576
197033 38822003089.00 197033
202606 41049191236.00 202606
210969 44507918961.00 210969
213636 45640340496.00 213636
216545 46891737025.00 216545
224909 50584058281.00 224909
227879 51928838641.00 227879
230489 53125179121.00 230489
233272 54415825984.00 233272
236060 55724323600.00 236060
239000 57121000000.00 239000
255575 65318580625.00 255575
257450 66280502500.00 257450
261151 68199844801.00 261151
263939 69663795721.00 263939
269515 72638335225.00 269515
272303 74148923809.00 272303
275090 75674508100.00 275090
277878 77216182884.00 277878
280667 78773964889.00 280667
283455 80346737025.00 283455
309091 95537246281.00 309091
340000 115600000000.00 340000
345700 119508490000.00 345700
347800 120964840000.00 347800
354000 125316000000.00 354000
362000 131044000000.00 362000
400000 160000000000.00 400000
450000 202500000000.00 450000
487000 237169000000.00 487000
515150 265379522500.00 515150
560000 313600000000.00 560000
670000 448900000000.00 670000
687878 473176142884.00 687878
690000 476100000000.00 690000
715758 512309514564.00 715758
721000 519841000000.00 721000
743636 552994500496.00 743636
769000 591361000000.00 769000
789000 622521000000.00 789000
809000 654481000000.00 809000
834897 697053000609.00 834897
836364 699504740496.00 836364
874000 763876000000.00 874000
900000 810000000000.00 900000
910989 829900958121.00 910989
938788 881322908944.00 938788
980,000 960400000000.00 980000
994545 989119757025.00 994545
1004000 1008016000000.00 1004000
1021212 1042873948944.00 1021212
1027273 1055289816529.00 1027273
1136394 1291391323236.00 1136394
1161823 1349832683329.00 1161823
1245445 1551133248025.00 1245445
1275758 1627558474564.00 1275758
1278933 1635669618489.00 1278933
1301221 1693176090841.00 1301221
1,348,900 1819531210000.00 1348900
1412737 1995825831169.00 1412737
1424242 2028465274564.00 1424242
1450000 2102500000000.00 1450000
1484848 2204773583104.00 1484848
1496336 2239021424896.00 1496336
1524424 2323868531776.00 1524424
1587454 2520010202116.00 1587454
1636364 2677687140496.00 1636364
1639394 2687612687236.00 1639394
1691152 2859995087104.00 1691152
1719939 2958190163721.00 1719939
1747727 3054549666529.00 1747727
1772727 3142561016529.00 1772727
1775115 3151033263225.00 1775115
1803033 3250927999089.00 1803033
1830991 3352528042081.00 1830991
1866667 3484445688889.00 1866667
1887879 3564087118641.00 1887879
1914455 3665137947025.00 1914455
1942442 3773080923364.00 1942442
2053939 4218665415721.00 2053939
2060606 4246097087236.00 2060606
2137575 4569226880625.00 2137575
2193333 4810709648889.00 2193333
2200000 4840000000000.00 2200000
2221212 4933782748944.00 2221212
2276969 5184587826961.00 2276969
2388484 5704855818256.00 2388484
2444242 5974318954564.00 2444242
2472121 6111382238641.00 2472121
2498000 6240004000000.00 2498000
2527878 6390167182884.00 2527878
2540000 6451600000000.00 2540000
2862422 8193459706084.00 2862422
3245600 10533919360000.00 3245600
3400000 11560000000000.00 3400000
3760000 14137600000000.00 3760000
5909091 34917356446281.00 5909091
6000000 36000000000000.00 6000000
6034464 36414755767296.00 6034464
8551152 73122200527104.00 8551152
8767564 76870178494096.00 8767564
8830343 77974957497649.00 8830343
9212121 84863173318641.00 9212121
10245642 104973179992164.00 10245642
10781890 116249151972100.00 10781890
11067978 122500137008484.00 11067978
20004500 400180020250000.00 20004500
24163636 583881304740496.00 24163636
30045300 902720052090000.00 30045300
30848485 951629026795225.00 30848485
83333586 6944486555619396.00 83333586
96578667 9327438919496890.00 96578667
105030303 11031364548271800.00 105030303
Cuadro 5. Número de productores de

5 6 7 8
146848 1747727 202606 230489
1496336 1775115 2053939 233272
1524424 1803033 20818 236060
155212 1830991 210969 2388484
1587454 1887879 2137575 24163636
160588 1866667 216545 2444242
163576 1914455 2193333 2472121
1636364 1942442 2221212 257450
1691152 197033 224909 2527878
1719939 19981 2276969 255575
10281893 14985323 11758875 35209207

fi Fi hi hi%
9088883 9088883 0.01517542 1.5175417765478
11082518 20171401 0.01850413 1.85041264744446
238847019 259018420 0.39879524 39.8795241985628
7184214 266202634 0.01199525 1.19952527463051
10281893 276484527 0.01716735 1.71673484733981
14985323 291469850 0.02502052 2.50205153785813
11758875 303228725 0.01963342 1.96334181633799
35209207 338437932 0.05878769 5.87876888079858
2236506 340674438 0.00373422 0.373422266355482
104817744 445492182 0.17501084 17.5010840653898
54712108 500204290 0.09135106 9.13510599410237
5,946,591 506,150,881 0.00992883 0.992883313663864
23580100 529,730,981 0.03937094 3.93709401311193
38323768 568,054,749 0.06398797
12866500 580,921,249 0.02148278 2.14827842628762
9123300 590,044,549 0.01523288 1.52328827315508
8876887 598,921,436 0.01482145 1.48214548126476
598921436 1 93.6012028128511
1275758

3533 3533 media 3523067.27058824


38121 4090 moda 1000000
4090 4648 mediana 635000
43696 5484 rango 105026770
4648 9475 varianza 171634477466638.00
desviacion
49272 19981 13100934.22114
estandar
desviacion
52060 20818 4891170.71916957
media

coeficiente
5484 23768 371.861597151752
de variacion

coeficiente
57636 25836 6.41827922397412
de asimetria

coeficiente
8830343 26500 43.3693641329335
de curtocis
340000 26672 cuartil 1 139879.00
60424 29697 cuartil 2 635000
74378 32000 cuartil 3 1766477
9475 32000
687878 34000
715758 38121
743636 43696
77151 46000
79939 49272
82727 50000
8551152 52060
910989 54000
938788 57000
96578667 57636
994545 60424
10245642 61300
105030303 65000
10781890 72600
11067978 74378
1136394 77151
1161823 78000
118968 78300
1275758 79939
1245445 82000
1278933 82727
1301221 98000
132909 118968
135697 127800
138485 132909
1412737 134500
144061 134600
146848 135697
1496336 138485
1524424 144061
155212 146848
1587454 155212
160588 160588
163576 163576
1636364 197033
1691152 202606
1719939 210969
1747727 213636
1775115 216545
1803033 224909
1830991 227879
1887879 230489
1866667 233272
1914455 236060
1942442 239000
197033 255575
19981 257450
202606 261151
2053939 263939
20818 269515
210969 272303
2137575 275090
216545 277878
2193333 280667
2221212 283455
224909 309091
2276969 340000
230489 345700
233272 347800
236060 354000
2388484 362000
24163636 400000
2444242 450000
2472121 487000
257450 515150
2527878 560000
255575 670000
25836 687878
261151 690000
263939 715758
26672 721000
269515 743636
272303 769000
275090 789000
277878 809000
280667 834897
283455 836364
2862422 874000
6034464 900000
83333586 910989
1021212 938788
5909091 980,000
309091 994545
29697 1004000
1484848 1021212
1772727 1027273
2060606 1136394
30848485 1161823
836364 1245445
9212121 1275758
1424242 1278933
227879 1301221
213636 1,348,900
515150 1412737
1639394 1424242
1027273 1450000
8767564 1484848
1,348,900 1496336
980,000 1524424
874000 1587454
34000 1636364
32000 1639394
50000 1691152
72600 1719939
46000 1747727
834897 1772727
2200000 1775115
239000 1803033
134500 1830991
127800 1866667
20004500 1887879
1450000 1914455
134600 1942442
400000 2053939
345700 2060606
54000 2137575
690000 2193333
78300 2200000
30045300 2221212
450000 2276969
670000 2388484
23768 2444242
2498000 2472121
900000 2498000
3245600 2527878
65000 2540000
347800 2862422
57000 3245600
789000 3400000
82000 3760000
3400000 5909091
487000 6000000
721000 6034464
26500 8551152
2540000 8767564
1004000 8830343
3760000 9212121
78000 10245642
354000 10781890
61300 11067978
809000 20004500
98000 24163636
362000 30045300
560000 30848485
769000 83333586
32000 96578667
6000000 105030303
Cuadro 5. Número de productores de arroz mecanizado, por rango de edad y nivel de escolar
Total Nacional
Año 2016
Nivel escolaridad
9 10 11 12
25836 2862422 30848485 1,348,900
261151 6034464 836364 980,000
263939 83333586 9212121 874000
26672 1021212 1424242 34000
269515 5909091 227879 32000
272303 309091 213636 50000
275090 29697 515150 72600
277878 1484848 1639394 46000
280667 1772727 1027273 309091
283455 2060606 8767564 2200000
2236506 104817744 54712108 5,946,591

Hi Hi%
0.015175417765478 1.5175417765478 cuartil
0.0336795442399227 3.3679544239923 2
0.432474786225551 43.247478622555 0.5
0.444470038971856 44.447003897186 635000
0.461637387445254 46.163738744525
0.486657902823836 48.665790282384
0.506291320987215 50.629132098722
0.565079009795201 56.50790097952
0.568813232458756 56.881323245876
0.743824073112654 74.382407311265 xi
0.835175133053678 83.517513305368 1
0.845103966190317 84.510396619032 2
0.884474906321436 88.447490632144 3
0.948462878192925 94.846287819293 4
0.969945662455802 96.99456624558 5
0.985178545187352 98.517854518735 6
1 100 7
8
9
10
11
fisher -311120937.0816 12
pearson 1.916676237E-07 13
bowley 0.3912189735878 14
173284669717857000000000000.00 15
13163763508885.20 16
1009618816365.14 17

3736449.66100442
de edad y nivel de escolaridad

13 14
239000 78300
134500 30045300
127800 450000
20004500 670000
1450000 23768
134600 2498000
400000 900000
345700 3245600
54000 65000
690000 347800
23580100 38323768

decil decil
4 6
0.4 0.6
281782.2 997818

fi (xi-X)^3*fi
2236508.3804 -97798674232905600000000000.00
104817982.04 -104817353132005000000000000.00
54712108 -14008720439500800000000000.00
6581593.5 -7624845249807830000000000000000.00
23861886.6 -120647513020387000000000000000000000000000000000000.00
39321592.6 -88417310610118700000000000000.00
14925781.4 -1746520455884990000000000000.00
11577385.5 -557723775967156.00
19787612.55 340503207.43
598921436 -22254285249301.60
8767564 -23990209432827200000000.00
2200000 -563273390183500000000000.00
690000 -3803325226112170000000000.00
347800 954363200.00
3760000 12690000000.00
6000000 24576000000.00
490087 2407797431.00

0.00
15 16 17
57000 78000 1000000
789000 354000 1300000
82000 61300 600000
3400000 809000 540000
487000 98000 536000
721000 362000 690800
26500 560000 1000000
2540000 769000 2400000
1004000 32000 320000
3760000 6000000 490087
12866500 9123300 8876887

decil perceptil perceptil


8 85 95
0.8 0.85 0.95
2059272.6 2453999.65 10910629.6

N*DE^3
387783330019795000000000000000000000000000.00
corporación universitaria
iberoamericana
Estadística descriptiva
JESUS MIZGER
(28082023_C12_202334)
Actividad 4
Medidas de posición o tendencia central
Holman Agray Acosta - Marlon Andres rivas Riascos
Segundo semestre de Ingeniería industrial
19-10-2023

598921436
-6.8 -48.7 tabla de frecuencias- variable co
-10.2 -45.8 -6.8 -8.5 2.0 75.83
-30.4 -34.78 -10.2 -8.5 2.7 75.4
-18.3 -30.4 -30.4 -26.7 2.4 73.2
-11.3 -27.1 -18.3 -8.1 10.4 71.2
-27.1 -26.7 -11.3 -10.5 5.8 70.8
-24.0 -26.19 -27.1 -20.0 3.5 67.7
-6.5 -25.4 -24.0 -5.6 86.9 67.6
-8.7 -24.0 -6.5 -9.9 79.4 61.8
-14.1 -23.9 -8.7 5.3 78.5 6.13
-8.5 -23.2 -14.1 6.6 76.8 56.1
-8.5 -20.45 -20.45 4 6.9 -4.8
-26.7 -20.0 14.5 34.7 78.3 -6.7
-8.1 -18.3 -13.46 5.4 3 2.68
-10.5 -17.79 -48.7 72.1 -2.65 -25.4
-20.0 -14.1 35.4
-5.6 -13.46
-9.9 -13.45 tabla de frecuencias- variable continua ord
5.3 -11.3 -48.7 -45.8 -34.78 -30.4
6.6 -10.5 -25.4 -24.0 -23.9 -23.2
2.0 -10.2 -17.79 -14.1 -13.46 -13.45
2.7 -10.04 -10.04 -9.9 -9.6 -9.37
2.4 -9.9 -8.2 -8.1 -7.89 -6.8
10.4 -9.6 -5.6 -5.4 -4.8 -4.6
5.8 -9.37 2.0 2.2 2.4 2.68
3.5 -8.7 3.24 3.5 4 5.3
86.9 -8.5 6.5 6.6 6.7 6.9
79.4 -8.5 9 10.4 12.78 14.5
78.5 -8.2 32.9 34.1 34.3 34.7
76.8 -8.1 39.8 42.5 42.7 48.1
75.83 -7.89 61.8 67.6 67.7 70.8
75.4 -6.8 73.2 75.4 75.83 76.8
73.2 -6.7 86.9
71.2 -6.5
70.8 -5.7
67.7 -5.6 rango intervalos amplitud
67.6 -5.4 135.6 7.42594533 18.2603014
61.8 -4.8
6.13 -4.6 xinf xsup xi fi Fi
56.1 -3.4 -48.7 -30.4396985873043 -79.139699 4 4
54.1 -2.65 -30.4396985873043 -12.1793971746086 -42.619096 14 18
51.3 -0.7 -12.1793971746086 6.08090423808709 -6.0984929 37 55
48.1 2.0 6.08090423808709 24.3412056507828 30.4221099 14 69
42.7 2.2 24.3412056507828 42.6015070634785 66.9427127 10 79
42.5 2.4 42.6015070634785 60.8618084761742 103.463316 5 84
39.8 2.68 60.8618084761742 79.1221098888699 139.983918 14 98
37.3 2.7 79.1221098888699 86.9 166.02211 1 99
34.3 3 99
34.1 3.2
3.24 3.24

17.9 3.5 mediana media moda rango varianza

17.4 4 12.8385858585859 3.24 -8.5 135.6 1100.874653


-26.19 5.3
-17.79 5.4
-9.37 5.8
-9.6 6.13 cuartil decil decil decil percentil
7.45 6.5 2 4 6 8 85
8.9 6.6 0.5 0.4 0.6 0.8 0.85
6.7 6.7 3.24 -3.4 6.9 42.7 61.8
-23.2 6.9
-0.7 7.45
-45.8 7.8
3.2 8.9 Este gráfico no está disponible en su versión de Excel.
-5.4 9
72.6 10.4 Si edita esta forma o guarda el libro en un formato de archivo diferente, el
gráfico no se podrá utilizar.
-4.6 12.78
2.2 14.5
-23.9 17.4
-13.45 17.9
12.78 24.98
-20.45 32.9
14.5 34.1
-13.46 34.3
4 34.7
34.7 35.4
5.4 37.3
6.9 37.6
78.3 39.8
3 42.5
-4.8 42.7
-6.7 48.1 Este gráfico no está disponible en su versión de Excel.
2.68 51.3
24.98 54.1 Si edita esta forma o guarda el libro en un formato de archivo diferente, el
9 56.1 gráfico no se podrá utilizar.
32.9 61.8
6.5 67.6
Si edita esta forma o guarda el libro en un formato de archivo diferente, el
gráfico no se podrá utilizar.

-34.78 67.7
-5.7 70.8
-7.89 71.2
-8.2 72.1
-3.4 72.6
-48.7 73.2
72.1 75.4
-2.65 75.83
-25.4 76.8
-10.04 78.3
37.6 78.5
7.8 79.4
35.4 86.9
cias- variable continua
54.1 17.9 -0.7
51.3 17.4 -45.8
48.1 -26.19 3.2
42.7 -17.79 -5.4
42.5 -9.37 72.6
39.8 -9.6 -4.6
37.3 7.45 2.2
34.3 8.9 -23.9
34.1 6.7 -13.45
3.24 -23.2 12.78
24.98 6.5 -7.89
9 -34.78 -8.2
32.9 -5.7 -3.4
-10.04 37.6 7.8

- variable continua ordenada


-27.1 -26.7 -26.19
-20.45 -20.0 -18.3
-11.3 -10.5 -10.2
-8.7 -8.5 -8.5
-6.7 -6.5 -5.7
-3.4 -2.65 -0.7
2.7 3 3.2
5.4 5.8 6.13
7.45 7.8 8.9
17.4 17.9 24.98
35.4 37.3 37.6
51.3 54.1 56.1
71.2 72.1 72.6
78.3 78.5 79.4

hi hi% Hi Hi%
0.0404000000 4.040000000 0.0404000000 4.04
0.141414141 14.141414141 0.1818141414 18.1814141
0.3737373737 37.3737373737 0.5555515152 55.5551515
0.141414141 14.1414141414 0.6969656566 69.6965657
0.10101010 10.1010101010 0.7979757576 79.7975758
0.0505051 5.0505050505 0.8484808081 84.8480808
0.14141414 14.1414141414 0.9898949495 98.9894949
0.010101 1.01010101010 0.9999959596 99.999596
1.00 100 100

desviacion desviacion
estandar media coeficiente de coeficiente
variacion de asimetria
33.1794311748 27.07346801347 2.58435247778 0.711036857

fisher
percentil pearson
95 bowley
0.95 curtosis
76.8

cel.

de archivo diferente, el

el.

de archivo diferente, el
de archivo diferente, el
874000 -48.7
261151 -45.8
769000 -34.78
4648 -30.4
19981 -27.1
32000 -26.7
216545 -26.19
938788 -25.4
20818 -24.0
280667 -23.9
255575 -23.2
340000 -20.45
38121 -20.0
5484 -18.3
224909 -17.79
26500 -14.1
347800 -13.46
283455 -13.45
9475 -11.3
34000 -10.5
4090 -10.2
980,000 -10.04
46000 -9.9
230489 -9.6
227879 -9.37
25836 -8.7
26672 -8.5
29697 -8.5
834897 -8.2
32000 -8.1
809000 -7.89
3533 -6.8
670000 -6.7
23768 -6.5
789000 -5.7
43696 -5.6
269515 -5.4
560000 -4.8
275090 -4.6
836364 -3.4
910989 -2.65
257450 -0.7
52060 2.0
277878 2.2
57000 2.4
687878 2.68
54000 2.7
515150 3
263939 3.2
202606 3.24
61300 3.5
354000 4
49272 5.3
400000 5.4
60424 5.8
132909 6.13
743636 6.5
50000 6.6
239000 6.7
450000 6.9
233272 7.45
1004000 7.8
236060 8.9
715758 9
57636 10.4
309091 12.78
345700 14.5
213636 17.4
210969 17.9
690000 24.98
721000 32.9
197033 34.1
163576 34.3
362000 34.7
1021212 35.4
160588 37.3
994545 37.6
155212 39.8
146848 42.5
144061 42.7
138485 48.1
135697 51.3
134600 54.1
134500 56.1
127800 61.8
118968 67.6
98000 67.7
82727 70.8
82000 71.2
900000 72.1
272303 72.6
79939 73.2
78300 75.4
78000 75.83
77151 76.8
487000 78.3
74378 78.5
72600 79.4
65000 86.9
1027273
1136394
1161823
1245445
1275758
1278933
1301221
1,348,900
1412737
1424242
1450000
1484848
1496336
1524424
1587454
1636364
1639394
1691152
1719939
1747727
1772727
1775115
1803033
1830991
1866667
1887879
1914455
1942442
2053939
2060606
2137575
2193333
2200000
2221212
2276969
2388484
2444242
2472121
2498000
2527878
2540000
2862422
3245600
3400000
3760000
5909091
6000000
6034464
8551152
8767564
8830343
9212121
10245642
10781890
11067978
20004500
24163636
30045300
30848485
83333586
96578667
105030303
2
2

2
2
2.2
2.2 2.70
2.2 2.65
2.4
2.4
2.5 0.26
2.5
2.5
2.5
2.5
2.6
2.7
2.8
2.8
2.9
2.9
2.9
2.9
3.1
3.1
3.1
3.3
3.6
3.9
3.9

You might also like