Ing 2

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 |...