Mr GURUU
gochoobasasak
Sample.xlsxPopulation
| Population | |||||
| Hospital | Geog. Region | Control | Service | Census | Births |
| 1 | 1 | 2 | 1 | 107 | 312 |
| 2 | 1 | 1 | 1 | 198 | 1077 |
| 3 | 1 | 2 | 1 | 356 | 1027 |
| 4 | 1 | 1 | 1 | 100 | 355 |
| 5 | 7 | 1 | 1 | 9 | 168 |
| 6 | 4 | 2 | 1 | 159 | 3810 |
| 7 | 4 | 4 | 1 | 65 | 735 |
| 8 | 4 | 2 | 1 | 48 | 1 |
| 9 | 1 | 2 | 1 | 253 | 1733 |
| 10 | 1 | 1 | 1 | 21 | 257 |
| 11 | 1 | 1 | 1 | 27 | 169 |
| 12 | 6 | 3 | 1 | 30 | 430 |
| 13 | 6 | 3 | 1 | 43 | 0 |
| 14 | 6 | 2 | 1 | 233 | 2049 |
| 15 | 6 | 4 | 1 | 2 | 211 |
| 16 | 6 | 1 | 1 | 11 | 16 |
| 17 | 6 | 3 | 1 | 84 | 2648 |
| 18 | 6 | 2 | 1 | 219 | 2450 |
| 19 | 6 | 3 | 1 | 112 | 1465 |
| 20 | 6 | 3 | 1 | 124 | 0 |
| 21 | 6 | 3 | 1 | 50 | 1993 |
| 22 | 6 | 2 | 1 | 142 | 2275 |
| 23 | 6 | 2 | 1 | 111 | 1494 |
| 24 | 6 | 1 | 1 | 140 | 1313 |
| 25 | 6 | 3 | 1 | 28 | 451 |
| 26 | 6 | 2 | 1 | 154 | 1689 |
| 27 | 6 | 2 | 1 | 150 | 1583 |
| 28 | 6 | 3 | 1 | 144 | 2017 |
| 29 | 6 | 3 | 1 | 42 | 995 |
| 30 | 6 | 2 | 1 | 77 | 2045 |
| 31 | 5 | 2 | 1 | 119 | 1686 |
| 32 | 5 | 2 | 1 | 27 | 503 |
| 33 | 5 | 2 | 1 | 15 | 126 |
| 34 | 2 | 2 | 1 | 179 | 2026 |
| 35 | 2 | 2 | 1 | 175 | 1412 |
| 36 | 2 | 2 | 1 | 461 | 1517 |
| 37 | 1 | 3 | 2 | 32 | 0 |
| 38 | 1 | 2 | 1 | 74 | 0 |
| 39 | 1 | 1 | 1 | 414 | 2719 |
| 40 | 1 | 2 | 1 | 253 | 1074 |
| 41 | 1 | 3 | 1 | 180 | 1421 |
| 42 | 1 | 1 | 1 | 184 | 762 |
| 43 | 1 | 2 | 1 | 243 | 3194 |
| 44 | 1 | 2 | 1 | 115 | 496 |
| 45 | 1 | 1 | 1 | 215 | 1442 |
| 46 | 1 | 3 | 2 | 48 | 0 |
| 47 | 1 | 3 | 1 | 124 | 1107 |
| 48 | 1 | 2 | 1 | 189 | 2989 |
| 49 | 1 | 1 | 1 | 181 | 113 |
| 50 | 1 | 1 | 1 | 9 | 0 |
| 51 | 1 | 3 | 1 | 28 | 0 |
| 52 | 1 | 2 | 1 | 288 | 173 |
| 53 | 1 | 1 | 1 | 108 | 1064 |
| 54 | 1 | 2 | 1 | 154 | 759 |
| 55 | 7 | 2 | 1 | 76 | 1317 |
| 56 | 7 | 3 | 1 | 165 | 1751 |
| 57 | 3 | 1 | 2 | 295 | 0 |
| 58 | 3 | 3 | 1 | 101 | 0 |
| 59 | 3 | 2 | 1 | 69 | 714 |
| 60 | 3 | 2 | 1 | 12 | 99 |
| 61 | 3 | 2 | 1 | 185 | 2243 |
| 62 | 3 | 2 | 1 | 378 | 3966 |
| 63 | 3 | 2 | 1 | 114 | 1308 |
| 64 | 3 | 3 | 2 | 49 | 0 |
| 65 | 3 | 2 | 1 | 106 | 2514 |
| 66 | 3 | 2 | 1 | 460 | 3714 |
| 67 | 3 | 2 | 1 | 43 | 126 |
| 68 | 3 | 4 | 1 | 29 | 556 |
| 69 | 3 | 2 | 1 | 125 | 1327 |
| 70 | 3 | 2 | 1 | 17 | 415 |
| 71 | 3 | 1 | 1 | 10 | 216 |
| 72 | 3 | 3 | 1 | 14 | 339 |
| 73 | 3 | 1 | 1 | 173 | 1217 |
| 74 | 3 | 2 | 1 | 207 | 2641 |
| 75 | 3 | 2 | 1 | 223 | 790 |
| 76 | 3 | 2 | 1 | 82 | 520 |
| 77 | 3 | 1 | 1 | 64 | 35 |
| 78 | 3 | 2 | 1 | 139 | 1168 |
| 79 | 3 | 2 | 1 | 109 | 793 |
| 80 | 3 | 1 | 2 | 298 | 0 |
| 81 | 3 | 3 | 1 | 52 | 0 |
| 82 | 3 | 1 | 1 | 34 | 14 |
| 83 | 3 | 1 | 2 | 168 | 0 |
| 84 | 3 | 3 | 2 | 21 | 0 |
| 85 | 1 | 4 | 1 | 390 | 0 |
| 86 | 1 | 1 | 1 | 47 | 0 |
| 87 | 1 | 2 | 1 | 80 | 776 |
| 88 | 1 | 3 | 1 | 50 | 451 |
| 89 | 1 | 3 | 2 | 113 | 0 |
| 90 | 1 | 2 | 1 | 45 | 145 |
| 91 | 1 | 1 | 1 | 76 | 1284 |
| 92 | 1 | 3 | 1 | 129 | 1 |
| 93 | 2 | 2 | 1 | 60 | 319 |
| 94 | 2 | 2 | 1 | 418 | 2154 |
| 95 | 2 | 2 | 1 | 17 | 295 |
| 96 | 2 | 2 | 1 | 138 | 496 |
| 97 | 2 | 2 | 1 | 64 | 589 |
| 98 | 2 | 2 | 1 | 62 | 806 |
| 99 | 2 | 1 | 1 | 131 | 701 |
| 100 | 2 | 2 | 1 | 265 | 3968 |
| 101 | 3 | 4 | 2 | 456 | 0 |
| 102 | 3 | 2 | 2 | 40 | 0 |
| 103 | 3 | 1 | 1 | 310 | 3655 |
| 104 | 3 | 3 | 1 | 72 | 0 |
| 105 | 3 | 3 | 2 | 19 | 0 |
| 106 | 3 | 4 | 1 | 112 | 0 |
| 107 | 3 | 1 | 2 | 375 | 0 |
| 108 | 3 | 3 | 2 | 15 | 0 |
| 109 | 3 | 2 | 1 | 78 | 3063 |
| 110 | 3 | 1 | 1 | 123 | 169 |
| 111 | 3 | 2 | 1 | 54 | 66 |
| 112 | 3 | 2 | 1 | 96 | 827 |
| 113 | 1 | 3 | 1 | 82 | 570 |
| 114 | 1 | 1 | 2 | 1106 | 0 |
| 115 | 1 | 1 | 1 | 30 | 0 |
| 116 | 3 | 1 | 2 | 56 | 0 |
| 117 | 3 | 4 | 1 | 36 | 342 |
| 118 | 3 | 3 | 1 | 127 | 494 |
| 119 | 3 | 1 | 2 | 180 | 0 |
| 120 | 3 | 4 | 1 | 59 | 0 |
| 121 | 5 | 2 | 1 | 127 | 0 |
| 122 | 5 | 1 | 1 | 37 | 0 |
| 123 | 5 | 4 | 1 | 13 | 286 |
| 124 | 5 | 2 | 1 | 100 | 235 |
| 125 | 3 | 3 | 1 | 47 | 339 |
| 126 | 3 | 1 | 1 | 194 | 398 |
| 127 | 3 | 2 | 1 | 172 | 1275 |
| 128 | 5 | 3 | 1 | 516 | 5699 |
| 129 | 5 | 3 | 1 | 120 | 1364 |
| 130 | 5 | 1 | 1 | 179 | 714 |
| 131 | 2 | 4 | 1 | 140 | 0 |
| 132 | 2 | 3 | 2 | 78 | 0 |
| 133 | 2 | 3 | 2 | 68 | 0 |
| 134 | 2 | 2 | 1 | 186 | 779 |
| 135 | 2 | 2 | 1 | 91 | 0 |
| 136 | 2 | 1 | 1 | 340 | 2202 |
| 137 | 5 | 1 | 1 | 254 | 3346 |
| 138 | 5 | 2 | 1 | 108 | 1071 |
| 139 | 5 | 2 | 1 | 61 | 352 |
| 140 | 2 | 2 | 1 | 174 | 254 |
| 141 | 2 | 1 | 2 | 306 | 0 |
| 142 | 2 | 3 | 2 | 28 | 0 |
| 143 | 2 | 2 | 1 | 395 | 699 |
| 144 | 2 | 2 | 1 | 923 | 2462 |
| 145 | 2 | 1 | 1 | 335 | 3311 |
| 146 | 1 | 2 | 1 | 46 | 0 |
| 147 | 1 | 1 | 1 | 316 | 4207 |
| 148 | 1 | 4 | 2 | 416 | 0 |
| 149 | 1 | 1 | 1 | 74 | 339 |
| 150 | 1 | 2 | 1 | 86 | 130 |
| 151 | 3 | 2 | 1 | 38 | 91 |
| 152 | 3 | 2 | 1 | 147 | 1143 |
| 153 | 3 | 4 | 2 | 232 | 0 |
| 154 | 3 | 1 | 2 | 138 | 0 |
| 155 | 3 | 2 | 1 | 38 | 509 |
| 156 | 3 | 2 | 1 | 245 | 1026 |
| 157 | 3 | 1 | 2 | 171 | 0 |
| 158 | 3 | 3 | 1 | 51 | 447 |
| 159 | 3 | 4 | 1 | 28 | 1161 |
| 160 | 3 | 1 | 2 | 797 | 0 |
| 161 | 7 | 2 | 1 | 56 | 922 |
| 162 | 7 | 1 | 1 | 69 | 562 |
| 163 | 7 | 1 | 1 | 40 | 78 |
| 164 | 7 | 4 | 1 | 163 | 0 |
| 165 | 7 | 2 | 1 | 231 | 2122 |
| 166 | 2 | 1 | 2 | 523 | 0 |
| 167 | 2 | 4 | 1 | 31 | 0 |
| 168 | 2 | 2 | 2 | 43 | 0 |
| 169 | 2 | 2 | 1 | 66 | 710 |
| 170 | 2 | 2 | 1 | 231 | 1165 |
| 171 | 1 | 4 | 1 | 11 | 466 |
| 172 | 1 | 3 | 1 | 144 | 1106 |
| 173 | 1 | 3 | 1 | 43 | 376 |
| 174 | 3 | 4 | 1 | 185 | 0 |
| 175 | 3 | 2 | 1 | 82 | 637 |
| 176 | 1 | 2 | 2 | 49 | 0 |
| 177 | 1 | 3 | 1 | 24 | 352 |
| 178 | 1 | 3 | 1 | 63 | 447 |
| 179 | 1 | 2 | 1 | 274 | 1227 |
| 180 | 1 | 3 | 1 | 93 | 963 |
| 181 | 1 | 4 | 1 | 86 | 3038 |
| 182 | 1 | 3 | 2 | 28 | 0 |
| 183 | 1 | 3 | 2 | 25 | 0 |
| 184 | 1 | 3 | 1 | 181 | 868 |
| 185 | 5 | 3 | 1 | 39 | 1189 |
| 186 | 5 | 1 | 1 | 302 | 2849 |
| 187 | 5 | 2 | 1 | 80 | 1728 |
| 188 | 5 | 2 | 1 | 63 | 2171 |
| 189 | 2 | 2 | 1 | 31 | 364 |
| 190 | 2 | 2 | 2 | 170 | 0 |
| 191 | 1 | 1 | 1 | 203 | 2993 |
| 192 | 1 | 2 | 1 | 296 | 0 |
| 193 | 1 | 3 | 1 | 83 | 1964 |
| 194 | 7 | 2 | 1 | 84 | 601 |
| 195 | 7 | 1 | 1 | 29 | 387 |
| 196 | 7 | 2 | 1 | 187 | 1946 |
| 197 | 7 | 2 | 1 | 77 | 545 |
| 198 | 5 | 1 | 2 | 104 | 0 |
| 199 | 5 | 1 | 1 | 85 | 838 |
| 200 | 5 | 1 | 1 | 47 | 51 |
Sample
| Sample | ||||||||
| Hospital Sr.NO | Geog. Region | Control | Service | Census | Births | Geog. Region | ||
| 1 | 1 | 2 | 1 | 107 | 312 | 1 | South | |
| 2 | 1 | 1 | 1 | 198 | 1077 | 2 | Northeast | |
| 3 | 1 | 2 | 1 | 356 | 1027 | 3 | Midwest | |
| 4 | 1 | 1 | 1 | 100 | 355 | 4 | Southwest | |
| 9 | 1 | 2 | 1 | 253 | 1733 | 5 | Rocky mountain | |
| 34 | 2 | 2 | 1 | 179 | 2026 | 6 | California | |
| 35 | 2 | 2 | 1 | 175 | 1412 | 7 | Northwest | |
| 36 | 2 | 2 | 1 | 461 | 1517 | |||
| 93 | 2 | 2 | 1 | 60 | 319 | |||
| 94 | 2 | 2 | 1 | 418 | 2154 | |||
| 57 | 3 | 1 | 2 | 295 | 0 | 1 | Government [Nonfederal] | |
| 58 | 3 | 3 | 1 | 101 | 0 | 2 | No-Government [Non-Profit] | |
| 59 | 3 | 2 | 1 | 69 | 714 | 3 | For profit purpose | |
| 60 | 3 | 2 | 1 | 12 | 99 | 4 | Federal Government | |
| 61 | 3 | 2 | 1 | 185 | 2243 | |||
| 6 | 4 | 2 | 1 | 159 | 3810 | |||
| 7 | 4 | 4 | 1 | 65 | 735 | |||
| 8 | 4 | 2 | 1 | 48 | 1 | |||
| 31 | 4 | 2 | 1 | 119 | 1686 | |||
| 32 | 4 | 2 | 1 | 27 | 503 | |||
| 33 | 5 | 2 | 1 | 15 | 126 | |||
| 121 | 5 | 2 | 1 | 127 | 0 | Census | ||
| 122 | 5 | 1 | 1 | 37 | 0 | Mean | 124.94 | |
| 123 | 5 | 4 | 1 | 13 | 286 | Standard Error | 19.82 | |
| 124 | 5 | 2 | 1 | 100 | 235 | Median | 100 | |
| 12 | 6 | 3 | 1 | 30 | 430 | Mode | 100 | |
| 13 | 6 | 3 | 1 | 43 | 0 | Standard Deviation | 117.28 | |
| 14 | 6 | 2 | 1 | 233 | 2049 | Sample Variance | 13753.64 | |
| 15 | 6 | 4 | 1 | 2 | 211 | Kurtosis | 1.49 | |
| 16 | 6 | 1 | 1 | 11 | 16 | Skewness | 1.37 | |
| 5 | 7 | 1 | 1 | 9 | 168 | Range | 459 | |
| 55 | 7 | 2 | 1 | 76 | 1317 | Minimum | 2 | |
| 56 | 7 | 3 | 1 | 165 | 1751 | Maximum | 461 | |
| 161 | 7 | 2 | 1 | 56 | 922 | Sum | 4373 | |
| 162 | 7 | 1 | 1 | 69 | 562 | Count | 35 | |
| Five-Number Summary | Census | Births | ||||||
| Min | 2 | 0 | ||||||
| Q1 | 40 | 147 | ||||||
| Median | 100 | 503 | ||||||
| Q3 | 177 | 1464.5 | ||||||
| Max | 461 | 3810 | ||||||
| Census | Frequency | Births | Frequency | |||||
| 102 | 20 | 800 | 21 | |||||
| 202 | 9 | 1600 | 6 | |||||
| 302 | 3 | 2400 | 7 | |||||
| 402 | 1 | 3200 | 0 | |||||
| 502 | 2 | 4000 | 1 | |||||
Histogram:Census
102 202 302 402 502 20 9 3 1 2BiN
Frequency
Histogram: Births
800 1600 2400 3200 4000 21 6 7 0 1BiN
Frequency
1
2
3
4
5
6
7
8
9
A
B
Hospital Sr.NO
Geog. Region
1
1
2
1
3
1
4
1
9
1
34
2
35
2
Sample
