Interpreting SMART results (CDC calculator)
The CDC Statistical Calculators (in Excel format) are used to help interpret prevalence results from nutritional surveys, which are often expressed as an estimate with a confidence interval..
The calculator for one survey allows you to know the probability that your true prevalence value exceeds a certain threshold; in other words, it helps you know where the true value lies within the confidence interval. The calculator for one survey is useful for comparing survey results to global benchmarks (e.g., what’s the probability that the true prevalence of malnutrition exceeds 10%?).
The calculator for two surveys allows you to know the probability that the prevalence estimate from one survey is significantly different from that of a second survey. For example, the calculator for two surveys can be used to compare prevalence in different areas, or during different time periods.
There are three sheets in both of these Excel tools, two of which are for cluster surveys (depending whether design effect is known or not) and one for simple or systematic random sampling.
Download the entire English set here.
Download the entire French set here.
Download individual files below:
One Survey (Une Enquête)
CDC Statistical Calculator (one survey).
Instructions for calculator (one survey)
Calculatrice Statistique du CDC (une enquête).
Comment utiliser la Calculatrice Statistique (une enquête)
Two Surveys (Deux Enquête)
CDC Statistical Calculator (two surveys).
Instructions for calculator (two surveys)
Calculatrice Statistique du CDC (deux enquête).
Comment utiliser la Calculatrice Statistique (deux enquête)