> 23
!"#$%&'()*+,./01Root Entry FZ/`f/WorkbookB[Ole
SummaryInformation(
Oh+'0p08P
\hIvana Bjelic@"a@5f/՜.+,0HPX`hp
x
CalculationsOutput Excel_BuiltIn__FilterDatabase_1 \pIvana Bjelic Ba==x<8X@"1zArial1zArial1zArial1zArial1zArial1zArial1.zTimes New Roman1
zArial1zArial1zArial"#,##0\ "Din.";\#,##0\ "Din."'"#,##0\ "Din.";[Red]\#,##0\ "Din."(##,##0.00\ "Din.";\#,##0.00\ "Din."(#,##0.00\ "Din.";[Red]\#,##0.00\ "Din."D*?_* #,##0\ "Din."_;\* #,##0\ "Din."_;_* ""\ "Din."_;_@_J)E_* #,##0\ _D_i_n_._;\* #,##0\ _D_i_n_._;_* ""\ _D_i_n_._;_@_L,G_* #,##0.00\ "Din."_;\* #,##0.00\ "Din."_;_* ""??\ "Din."_;_@_R+M_* #,##0.00\ _D_i_n_._;\* #,##0.00\ _D_i_n_._;_* ""??\ _D_i_n_._;_@_#,##0\ "kn";\#,##0\ "kn"##,##0\ "kn";[Red]\#,##0\ "kn"$#,##0.00\ "kn";\#,##0.00\ "kn")$#,##0.00\ "kn";[Red]\#,##0.00\ "kn">9_* #,##0\ "kn"_;\* #,##0\ "kn"_;_* ""\ "kn"_;_@_>9_* #,##0\ _k_n_;\* #,##0\ _k_n_;_* ""\ _k_n_;_@_FA_* #,##0.00\ "kn"_;\* #,##0.00\ "kn"_;_* ""??\ "kn"_;_@_FA_* #,##0.00\ _k_n_;\* #,##0.00\ _k_n_;_* ""??\ _k_n_;_@_
yyyy/mm/dd
0.0000000.000000.0000
0.0000.0 8 8 8 8 8 ( ( $
, $ "8 `CalculationsWOutput}9Excel_BuiltIn__FilterDatabase_1;"bZ 3 @@
LH!MULTIPLE INDICATOR CLUSTER SURVEYCountrySAMPLE
HOUSEHOLDSWOMENCHILDRENStratumSampling fraction
Design weight+Number of clusters selected in the stratum+Number of clusters completed in the stratumENumber of households with a complete interview in the stratum (HH9=1)5Number of households found in the stratum (HH9<>4)Raw household weightFWeighted number of households with a complete interview in the stratumNormalized household weight.Number of eligible women in the stratum (HH12)HNumber of eligible women with a complete interview in the stratum (HH13)Raw woman's weightAWeighted number of women with a complete interview in the stratumNormalized woman's weight2Number of eligible children in the stratum (HH14)KNumber of eligible children with a complete interview in the stratum (HH15)Raw children's weightDWeighted number of children with a complete interview in the stratumNormalized children's weightTOTALHFigures 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".hhweightwmweightchweight AreaRegionTotal1 Urban2 Rural2 Posavski3 Tuzlanski9 SarajevoSampled householdsOccupied householdsInterviewed householdsHousehold response rateEligible womenInterviewed womenWomen response rateWomen's overall response rateEligible children under 5Mother/Caretaker InterviewedChild response rate Children's overall response rate1.00 HHs with u52.00 All other HHsTable HH.1: Results of household and individual interviews
Numbers of households, women and children under 5 by results of the household, women's and underfive's interviews, and household, women's and underfive's response rates, BiH, 2006stratum
1.00 FBiH2.00 RS3.00 DB1 UnskoSanski4 ZenickoDobojski5 BosanskoPodrinjski6 Srednjebosanski7 Hercegovackonertvanski8 Zapadnohercegovaci10 HercegBosanski11 Krajina12 Posavina13 Podrinje i SRR14 Hercegovina15 Distrikt BrckoJ
w0"zcc
.14
MbP?_*+%&C&A &CPage &P&?'?('}'}?)'}'}?" =,,??U}}}}
} }
}
}
}}
.
&@
0
00
0000000
000000
000000
~
!'">?K#ǖE@ D$%/Υ@/@6#U,NF@ DDDDD"&h~\@ DD( 'P?
DD D "
(qׅ@
D D/ި@/@(
#е=?D DD"&9ٕ@ D
D('I0i?D
D D "(SҎ@DD/L@/$@(#X!? D DD"&sV@ DD('=? DD D "&ޚ%[@
DD~
!
'"
Ĭ
#k?K"S#"!r@ D$%/@/@6#D,9s@ DDDDD"&"*A DD( 'x"?
DD D "
(=@ D D/@/T@(
#3# K?D DD"&2D@ D
D('@D
D D "(+T@DD/X@/X@(#swl? D DD"&ove@ DD('u@ DD D "&h3@ DD
#&
&&&&&&
&&&&&
# p@
%# p@
%# @
%# Ҷ@
%# )7z.A
%#
)@
%
# q@
%# @
%# )߮@
%# )@
%# @
%# @
%# )/)TǍ@
%# )@ 
%
*
+
7&,,
8
9
:
;
!
"
#
#5
#6
$
#%
&<
#&
&'
=
>
#?
&@
#A
&(
B
C
D
E
F
G
)/p@/p@/@@/@/_@/@/2@/@/U@/p@/@/=@/t@/P{@/_@/@/@S@/X@l@@]@_@p@
*/@/@/l@/L@/]@/@/@/P@/U@/@/@/;@/@t@/z@/_@/@/@S@/@ l@@]@]@Ҷ@
+/Υ@/@/@/@/@]@/,@/ī@/~@/U@/@/@@/;@/s@/y@/]@/(@/@S@/h@ k@@@[@@]@@
,/hF9W@/RWW@/!CtW@/\Xjp2X@/AX@/D@DV@/WHX@/urYX@~
/Y@
/AL &WV@/rz[X@~
/Y@
/88NX@/>cX@/c1cW@/z`U@~
/Y@/8,X@qqX@;dhX@}W@AX@W@
/ި@/@/*@/@/X@/@/@/Ѐ@/S@/@/0@/7@/s@/x@/Z@/P@/K@/@d@}@X@X@q@
./@/T@/Ψ@/P@/W@/8@/@/@/S@/@/0@/7@/`s@/w@/X@/{@/K@/@d@@W@W@@
//"]&X@/Ew_X@/adX@/nF7QmX@//<?List each of the sample domains. The list given is an example.< >
N; XPP$?
&
Q]4;
,<Enter the sampling fraction for each domain.<,
N; XPP$?
Y
m]4;
V<WThe design weight is automatically calculated as the inverse of the sampling fraction.<V
N\< XPP$?
k]4\<
;<<Enter the count of clusters selected in each sample domain.<;
N< XPP$?
k]4<
<<=Enter the count of clusters completed in each sample domain.<<
N$= XPP$?
\]4$=
L<MEnter the count of households with result code HI10=1 in each sample domain.<L
N= XPP$?
v
]4= ,
<The total number of households found is automatically calculated as the sum of all of the household questionnaires with a result code (HI10) of 1, 2 or 3.<
N= XPP$?
Y
U]4= L
<The raw household weight is the design weight * the inverse of the cluster completion rate * the inverse of the household response rate.<{
NP> XPP$?
q]4 P> l
m<nThe weighted number of households is the number of completed household interviews * the raw household weight.<m
N> XPP$?
Y
]4
>
<The final household weight is automatically calculated by normalizing the weights so that the weighted count of households will equal the unweighted count of households.<
N? XPP$?
]4?
o<pThe weighted number of households is the number of completed household interviews * the final household weight.<o
N? XPP$?
\
]4?
H<IThe total number of eligible women (based on HI11) in the sample domain.<H
N XPP$?
v
~]4
T<UThe total number of eligible women interviewed (based on HI12) in the sample domain.<T
N@ XPP$?
Y
U]4@
e<fThe raw women's weight is the normalized household weight * the inverse of the women's response rate.<e
N XPP$?
q]4 ,
d<eThe weighted number of women is the number of completed women's interviews * the raw women's weight.<d
Nx XPP$?
Y
]4x L
<The final women's weight is automatically calculated by normalizing the weights so that the weighted count of women interviewed will equal the unweighted count of women interviewed.<
N@ XPP$?
]4@ l
f<gThe weighted number of women is the number of completed women's interviews * the final women's weight.<f
N@ XPP$?
\
]4@
K<LThe total number of eligible children (based on HI13) in the sample domain.<K
N@ XPP$?
P~]4@
W<XThe total number of eligible children interviewed (based on HI14) in the sample domain.<W
NHA XPP$?
P]4HA
k<lThe raw children's weight is the normalized household weight * the inverse of the children's response rate.<k
NA XPP$?
]4A
d<eThe weighted number of women is the number of completed women's interviews * the raw women's weight.<d
NB XPP$?
P
0]4B !
<The final women's weight is automatically calculated by normalizing the weights so that the weighted count of women interviewed will equal the unweighted count of women interviewed.<
NtB XPP$?
P
]4tB ,"
f<gThe weighted number of women is the number of completed women's interviews * the final women's weight.<f
>@"
7
XZ
MbP?_*+%&?'?('}'}?)'}'}?"d,,``?``?U}$ #}#} #


.?Z#P?Z #I0i?Z#=?Z.@Z#x"?Z #@Z#u@\ Z
(8 PH 0(
>@
7
DocumentSummaryInformation80CompObj mWorksheets
Named Ranges
F!Microsoft Office Excel WorksheetBiff8Excel.Sheet.89q