deber distribución de frecuencias2
DESCRIPTION
Este es un archivo de Excel donde se pueden observar las diferentes medidas de tendencia central y análisis de parámetros estadísticos en los cuales el lector podrá conocer sus procesos de cálculo correspondientesTRANSCRIPT
237.4 240.5 243.6 246.7 249.8 252.9 256 259.10
5
10
15
20
25
30
Polígono de Frecuencias
Polígono
Marcas de Clase
Frec
uenc
ias
237.4 240.5 243.6 246.7 249.8 252.9 256 259.10
5
10
15
20
25
30
Histograma
Marcas de Clase
Frec
uenc
ias
237.4 240.5 243.6 246.7 249.8 252.9 256 259.10
20
40
60
80
100
120
Ojiva de Frecuencias Acumulada
Ojiva de Frecuencias Acumulada
Marcas de Clase
Frec
uenc
ias A
cum
ulad
as
9% 10%
10%
15%27%
10%
8% 11%
Diagrama de Pastel
12345678
237.4 240.5 243.6 246.7 249.8 252.9 256 259.10
5
10
15
20
25
30
Pictograma Longitudes de Cilindros
Pictograma Longitudes de Cilindros
Columna1
Media 248.63Error típico 0.630961267600573Mediana 249Moda 250Desviación estándar 6.30961267600573Varianza de la muestra 39.8112121212122Curtosis -0.637594289977776Coeficiente de asimetría -0.132251861878606Rango 24Mínimo 236Máximo 260Suma 24863Cuenta 100
230
235
240
245
250
255
260
265
270
275
7.758.753.254.25244.75Pesos
N.- Pesos No.- INTERVALOS1 236 N 100 Lim. Inferior Lim. Superior Marca Clase2 236 Mayor 260 1 235.9 238.9 237.43 237 Menor 236 2 239 242 240.54 237 Rango 24 3 242.1 245.1 243.65 238 K 8 4 245.2 248.2 246.76 238 Amplitud (L) 3 5 248.3 251.3 249.87 238 Lim inferior inic 235.9 6 251.4 254.4 252.98 238 Diferencia 0.1 7 254.5 257.5 2569 238 8 257.6 260.6 259.1
10 23911 23912 23913 24014 24115 24116 24117 24218 24219 24220 24321 24322 24323 24424 24425 24426 24527 24528 24529 24530 24631 24632 24633 24634 24735 24736 24737 24738 24739 24740 24841 24842 24843 24844 248
45 24946 24947 24948 24949 24950 24951 24952 24953 24954 25055 25056 25057 25058 25059 25060 25061 25062 25063 25064 25165 25166 25167 25168 25169 25170 25171 25172 25273 25274 25275 25276 25377 25378 25379 25380 25481 25482 25583 25584 25585 25686 25787 25788 25789 257
90 25891 25892 25893 25894 25995 25996 25997 25998 26099 260
100 260
ni Ni fi (ni/n) %fi Fi %Fi Media (Xp)248.63
9 9 0.09 9 0.09 9 Mediana (Med)10 19 0.1 10 0.19 19 24910 29 0.1 10 0.29 29 Moda (Mod)15 44 0.15 15 0.44 44 25027 71 0.27 27 0.71 7110 81 0.1 10 0.81 81
8 89 0.08 8 0.89 8911 100 0.11 11 1 100
100 1 100
SUMATORIAS
(X-Xp)^4 (X-Xp)^3 (X-Xp)^2 Varianza S^2= 39.811212 S^3=25445.641386 -2014.69845 159.5169 Desviación Estandar S= 6.30961267601 S^4=25445.641386 -2014.69845 159.5169 Coef. Variación CV= 2.5377519510918294.428998 -1573.03775 135.2569 Coef. Asimetría CA= -0.132251861918294.428998 -1573.03775 135.2569 Coef. Curtosis Ccu= -0.63759429
12768.29941 -1201.15705 112.9969 Percentil 25 244.7512768.29941 -1201.15705 112.9969 Percentil 75 252.2512768.29941 -1201.15705 112.9969 Valor Máx 26012768.29941 -1201.15705 112.9969 Valor Mín 23612768.29941 -1201.15705 112.9969 Datos Gráfico de Cajón
8600.1326216 -893.056347 92.7369 1Quartil 244.758600.1326216 -893.056347 92.7369 Mediana 4.258600.1326216 -893.056347 92.7369 3Quartil 3.255546.8086336 -642.735647 74.4769 Valor Min 8.753389.2074456 -444.194947 58.2169 Valor Máx 7.753389.2074456 -444.194947 58.21693389.2074456 -444.194947 58.21691932.2090576 -291.434247 43.95691932.2090576 -291.434247 43.95691932.2090576 -291.434247 43.95691004.6934696 -178.453547 31.69691004.6934696 -178.453547 31.69691004.6934696 -178.453547 31.6969459.54068161 -99.252847 21.4369459.54068161 -99.252847 21.4369459.54068161 -99.252847 21.4369173.63069361 -47.832147 13.1769173.63069361 -47.832147 13.1769173.63069361 -47.832147 13.1769173.63069361 -47.832147 13.1769
47.84350561 -18.191447 6.916947.84350561 -18.191447 6.916947.84350561 -18.191447 6.916947.84350561 -18.191447 6.9169
7.05911761 -4.330747 2.65697.05911761 -4.330747 2.65697.05911761 -4.330747 2.65697.05911761 -4.330747 2.65697.05911761 -4.330747 2.65697.05911761 -4.330747 2.65690.15752961 -0.250047 0.39690.15752961 -0.250047 0.39690.15752961 -0.250047 0.39690.15752961 -0.250047 0.39690.15752961 -0.250047 0.3969
0.01874161 0.050653 0.13690.01874161 0.050653 0.13690.01874161 0.050653 0.13690.01874161 0.050653 0.13690.01874161 0.050653 0.13690.01874161 0.050653 0.13690.01874161 0.050653 0.13690.01874161 0.050653 0.13690.01874161 0.050653 0.13693.52275361 2.571353 1.87693.52275361 2.571353 1.87693.52275361 2.571353 1.87693.52275361 2.571353 1.87693.52275361 2.571353 1.87693.52275361 2.571353 1.87693.52275361 2.571353 1.87693.52275361 2.571353 1.87693.52275361 2.571353 1.87693.52275361 2.571353 1.8769
31.54956561 13.312053 5.616931.54956561 13.312053 5.616931.54956561 13.312053 5.616931.54956561 13.312053 5.616931.54956561 13.312053 5.616931.54956561 13.312053 5.616931.54956561 13.312053 5.616931.54956561 13.312053 5.6169
128.97917761 38.272753 11.3569128.97917761 38.272753 11.3569128.97917761 38.272753 11.3569128.97917761 38.272753 11.3569364.69158961 83.453453 19.0969364.69158961 83.453453 19.0969364.69158961 83.453453 19.0969364.69158961 83.453453 19.0969831.56680161 154.854153 28.8369831.56680161 154.854153 28.83691646.4848136 258.474853 40.57691646.4848136 258.474853 40.57691646.4848136 258.474853 40.57692950.3256256 400.315553 54.31694907.9692376 586.376253 70.05694907.9692376 586.376253 70.05694907.9692376 586.376253 70.05694907.9692376 586.376253 70.0569
7708.2956496 822.656953 87.79697708.2956496 822.656953 87.79697708.2956496 822.656953 87.79697708.2956496 822.656953 87.796911564.184862 1115.15765 107.536911564.184862 1115.15765 107.536911564.184862 1115.15765 107.536911564.184862 1115.15765 107.536916712.516874 1469.87835 129.276916712.516874 1469.87835 129.276916712.516874 1469.87835 129.2769362629.57452 -3223.0806 3941.31
251.1933291584.93261