Spreadsheet: 023f09f5-e8d3-41c2-b554-b8477da1d727
Sheet: Sheet1

MULTIPLE INDICATOR CLUSTER SURVEY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27
Country |  | SAMPLE |  |  |  | HOUSEHOLDS |  |  |  |  |  |  |  | WOMEN |  |  |  |  |  |  | CHILDREN
Cluster | Stratum | Probability of selection of a household within the cluster | Probability of selection of the cluster within the stratum | Design weight | Number of  clusters selected in the stratum | Number of clusters completed in the stratum | Number of households found in the stratum    (HH9= 1+2+3+6) | Number of households with a complete interview in the stratum (HH9=1) | Number of households with a complete interview in the cluster (HH9=1) | Raw household weight | Weighted number of households with a complete interview in the cluster | Normalized household weight | Weighted number of households with a complete interview in the stratum | Number of eligible women in the stratum (HH12) | Number of eligible women with a complete interview in the stratum (HH13) | Number of eligible women with a complete interview in the cluster (HH13) | Raw woman's weight | Weighted number of women with a complete interview in the cluster | Normalized woman's weight | Weighted number of women with a complete interview in the stratum | Number of eligible children  in the stratum (HH14) | Number of eligible children with a complete interview in the stratum (HH15) | Number of eligible children with a complete interview in the cluster (HH15) | Raw children's weight | Weighted number of children with a complete interview in the stratum | Normalized children's weight | Weighted number of children with a complete interview in the stratum
1 | 1 | 0.244361 | 0.001252 | 3268.615060211877 | 2 | 2 | 33 | 30 | 17 | 3595.476566233066 | 61123.10162596212 | 1.058036182194957 | 17.98661509731427 | 39 | 35 | 20 | 4006.388173802559 | 80127.76347605117 | 1.115116601923062 | 22.30233203846124 | 33 | 30 | 18 | 3955.024222856372 | 71190.4360114147 | 1.128414304014209 | 20.31145747225576
2 | 1 | 0.185344 | 0.001411 | 3823.793712386106 | 2 | 2 | 33 | 30 | 13 | 4206.173083624717 | 54680.25008712132 | 1.237745046885952 | 16.09068560951737 | 39 | 35 | 15 | 4686.878578896113 | 70303.1786834417 | 1.304520652466909 | 19.56780978700364 | 33 | 30 | 12 | 4626.790391987189 | 55521.48470384626 | 1.320076987094462 | 15.84092384513354
3 | 2 | 0.183673 | 0.001173 | 4641.481976180945 | 2 | 2 | 57 | 51 | 24 | 5187.538679261056 | 124500.9283022654 | 1.526530215977566 | 36.63672518346158 | 41 | 40 | 20 | 5317.227146242582 | 106344.5429248516 | 1.479968492754266 | 29.59936985508531 | 31 | 25 | 12 | 6432.54796228371 | 77190.57554740453 | 1.835280575514692 | 22.02336690617631
4 | 2 | 0.166667 | 0.001967 | 3050.32435181698 | 2 | 2 | 57 | 51 | 27 | 3409.186040266036 | 92048.02308718298 | 1.003216712997374 | 27.0868512509291 | 41 | 40 | 20 | 3494.415691272688 | 69888.31382545375 | 0.9726169263474522 | 19.45233852694905 | 31 | 25 | 13 | 4227.390689929885 | 54956.07896908851 | 1.206123617551005 | 15.67960702816306
5 | 3 | 0.177571 | 0.003345 | 1683.57255510394 | 3 | 3 | 96 | 89 | 30 | 1815.988374044699 | 54479.65122134098 | 0.5343885214631473 | 16.03165564389442 | 60 | 57 | 21 | 1911.566709520736 | 40142.90089993546 | 0.5320552280501669 | 11.17315978905351 | 86 | 81 | 30 | 1928.086421825236 | 57842.59265475709 | 0.5501054292385257 | 16.50316287715577
6 | 3 | 0.176724 | 0.001634 | 3462.999389099204 | 3 | 3 | 96 | 89 | 31 | 3735.370127567681 | 115796.4739545981 | 1.099202477349873 | 34.07527679784606 | 60 | 57 | 15 | 3931.968555334401 | 58979.52833001602 | 1.094403044358854 | 16.41604566538281 | 86 | 81 | 22 | 3965.948530503957 | 87250.86767108706 | 1.131531135749334 | 24.89368498648535
7 | 3 | 0.159183 | 0.002173 | 2890.970023043257 | 3 | 3 | 96 | 89 | 28 | 3118.349687776997 | 87313.7912577559 | 0.9176326802933588 | 25.69371504821405 | 60 | 57 | 21 | 3282.473355554734 | 68931.94046664941 | 0.9136260330648562 | 19.18614669436198 | 86 | 81 | 29 | 3310.840409244713 | 96014.37186809667 | 0.9446211870231739 | 27.39401442367204
8 | 4 | 0.109433 | 0.003993 | 2288.507735026843 | 4 | 4 | 102 | 100 | 25 | 2334.27788972738 | 58356.94724318451 | 0.6869048987341293 | 17.17262246835323 | 85 | 78 | 18 | 2543.764367010607 | 45787.75860619092 | 0.7080177341731612 | 12.7443192151169 | 107 | 103 | 25 | 2424.929458260482 | 60623.23645651205 | 0.6918605127910807 | 17.29651281977702
9 | 4 | 0.157718 | 0.002743 | 2311.494855419163 | 4 | 4 | 102 | 100 | 21 | 2357.724752527547 | 49512.21980307848 | 0.6938045763553152 | 14.56989610346162 | 85 | 78 | 22 | 2569.315435446686 | 56524.93957982709 | 0.7151294815560666 | 15.73284859423346 | 107 | 103 | 26 | 2449.286878839296 | 63681.4588498217 | 0.6988099675203803 | 18.16905915552989
10 | 4 | 0.105919 | 0.001746 | 5407.317725240495 | 4 | 4 | 102 | 100 | 30 | 5515.464079745305 | 165463.9223923591 | 1.623028394280702 | 48.69085182842106 | 85 | 78 | 18 | 6010.441625363474 | 108187.9492565425 | 1.672914093836017 | 30.1124536890483 | 107 | 103 | 27 | 5729.656859541239 | 154700.7352076134 | 1.634737587708135 | 44.13791486811964
11 | 4 | 0.15311 | 0.002947 | 2216.237543609183 | 4 | 4 | 102 | 100 | 24 | 2260.562294481367 | 54253.4950675528 | 0.6652127070244683 | 15.96510496858724 | 85 | 78 | 20 | 2463.43326962713 | 49268.66539254261 | 0.6856588072651896 | 13.71317614530379 | 107 | 103 | 25 | 2348.351121451517 | 58708.77803628793 | 0.6700118247012652 | 16.75029561753163
 | TOTAL |  |  |  | 11 | 11 | 288 | 270 | 270 |  | 917528.8040424017 |  | 270 | 225 | 210 | 210 |  | 754487.4814415023 |  | 210 | 257 | 239 | 239 |  | 837680.6159759299 |  | 239
 | Figures in red cells should be replaced by the figures from your survey.
 | Figures in green cells appear in the "Output" sheet. This sheet should be save in C:\MICS\WEIGHTS under the name "weights.csv".