Ing 2

Solo disponible en BuenasTareas
  • Páginas : 10 (2369 palabras )
  • Descarga(s) : 0
  • Publicado : 22 de agosto de 2012
Leer documento completo
Vista previa del texto
Taller Bases De datos
Análisis datos de Hospitales

Profesor

Fredy Rios

Robert Valencia Conto
Guillermo Hernandez Romero
Alexander

CORPORACION.UNIFICADA.NACIONAL DE EDUCACION SUPERIOR
C.U.N
Estadística y Probabilidad
SEMESTRE
5
03/04/2012

Análisis datos de Hospitales
HOSP | | |   |
527 | | HOSPITALES |   |
419 | |   |   |
441 | | Media | 320.8877463 |466 | | Error típico | 8.212604105 |
430 | | Mediana | 310.2 |
452 | | Moda | 458.6 |
502 | | Desviación estándar | 108.3316884 |
455 | | Varianza de la muestra | 11735.75471 |
390 | | Curtosis | -1.186749019 |
470 | | Coeficiente de asimetría | 0.030492749 |
500 | | Rango | 401.575 |
387 | | Mínimo | 118.8 |
443 | | Máximo | 520.375 |
237 | | Suma | 55834.46786 |454 | | Cuenta | 174 |
487 | | INGRESOS POR HOSPITALES | 8.438623504 | 9 | =1+3.32*LOG10(D6) |
499 | | AMPLITUD | 47.58773748 | =D12/D17 |

| LI | LS |
1 | 118.8 | 166.387737 |
2 | 166.387737 | 213.975475 |
3 | 213.975475 | 261.563212 |
4 | 261.563212 | 309.15095 |
5 | 309.15095 | 356.738687 |
6 | 356.738687 | 404.326425 |
7 | 404.326425 | 451.914162 |
8 | 451.914162 |499.5019 |
9 | 499.5019 | 547.089637 |

Clase | Frecuencia | % acumulado | Clase | Frecuencia | % acumulado |
118.8 | 1 | 0.57% | 309.15095 | 26 | 14.94% |
166.387737 | 13 | 8.05% | 261.563212 | 24 | 28.74% |
166.387737 | 0 | 8.05% | 451.914162 | 23 | 41.95% |
213.975475 | 22 | 20.69% | 213.975475 | 22 | 54.60% |
213.975475 | 0 | 20.69% | 499.5019 | 21 | 66.67% |
261.563212 | 24 |34.48% | 404.326425 | 20 | 78.16% |
261.563212 | 0 | 34.48% | 356.738687 | 19 | 89.08% |
309.15095 | 26 | 49.43% | 166.387737 | 13 | 96.55% |
309.15095 | 0 | 49.43% | 547.089637 | 5 | 99.43% |
356.738687 | 19 | 60.34% | 118.8 | 1 | 100.00% |
356.738687 | 0 | 60.34% | 166.387737 | 0 | 100.00% |
404.326425 | 20 | 71.84% | 213.975475 | 0 | 100.00% |
404.326425 | 0 | 71.84% | 261.563212 |0 | 100.00% |
451.914162 | 23 | 85.06% | 309.15095 | 0 | 100.00% |
451.914162 | 0 | 85.06% | 356.738687 | 0 | 100.00% |
499.5019 | 21 | 97.13% | 404.326425 | 0 | 100.00% |
499.5019 | 0 | 97.13% | 451.914162 | 0 | 100.00% |
547.089637 | 5 | 100.00% | 499.5019 | 0 | 100.00% |
y mayor... | 0 | 100.00% | y mayor... | 0 | 100.00% |

Análisis datos Servicios

SERVICIOS | | servicios|   |
1183 | | Media | 773.4942816 |
1177 | | Error típico | 15.83105669 |
1172 | | Mediana | 752.4621 |
1162 | | Moda | 914.8 |
1159 | | Desviación estándar | 208.8259801 |
1149 | | Varianza de la muestra | 43608.28995 |
1146 | | Curtosis | -1.25245847 |
1136 | | Coeficiente de asimetría | 0.284454958 |
1130 | | Rango | 688.2024 |
1128 | | Mínimo | 488.877 |1115 | | Máximo | 1177.0794 |
1111 | | Suma | 134588.005 |
1101 | | Cuenta | 174 |
=1097 | | Numero de clases | 8.438623504 | 9 |
1095 | | A | 76.46693333 |

Formula = Numero de clases = 1+3.32*LOG10(D14)
Formula A= D11/D16

| Clases |   |
| LI | LS |
1 | 488.877 | 565.343933 |
2 | 565.343933 | 641.810867 |
3 | 641.810867 | 718.2778 |
4 | 718.2778 |794.744733 |
5 | 794.744733 | 871.211667 |
6 | 871.211667 | 947.6786 |
7 | 947.6786 | 1024.14553 |
8 | 1024.14553 | 1100.61247 |
9 | 1100.61247 | 1177.0794 |

Clase | Frecuencia | % acumulado | Clase | Frecuencia | % acumulado |
488.877 | 1 | 0.57% | 565.343933 | 38 | 21.84% |
565.343933 | 38 | 22.41% | 641.810867 | 26 | 36.78% |
565.343933 | 0 | 22.41% | 1024.14553 | 19 | 47.70% |641.810867 | 26 | 37.36% | 794.744733 | 18 | 58.05% |
641.810867 | 0 | 37.36% | 718.2778 | 16 | 67.24% |
718.2778 | 16 | 46.55% | 947.6786 | 16 | 76.44% |
718.2778 | 0 | 46.55% | 1100.61247 | 16 | 85.63% |
794.744733 | 18 | 56.90% | 871.211667 | 13 | 93.10% |
794.744733 | 0 | 56.90% | 1177.0794 | 11 | 99.43% |
871.211667 | 13 | 64.37% | 488.877 | 1 | 100.00% |
871.211667 | 0 |...
tracking img