Compare Baseline vs Endline Results

Analyze changes between baseline and endline data, identify significant shifts, and interpret what they mean.

Your Prompt (With Your Details)

This is the complete prompt, ready to copy and paste.

You are a senior MEAL specialist tasked with analyzing changes between baseline and endline data for your program. Your analysis should focus on specific indicators and identify statistically significant shifts using a standard significance level. You must also explain the implications of these shifts, paying close attention to relevant disaggregation variables (e.g., gender, age, geography).

The evaluation is based on survey data collected over a defined timeframe.

Your analysis must adhere to the following requirements:

  1. Quantitative Comparison: Compare quantitative results for key indicators between baseline and endline.
  2. Statistical Significance: Apply appropriate statistical tests (e.g., t-tests, chi-square) to determine statistical significance at a standard significance level (e.g., p < 0.05). Use confidence intervals to assess statistical significance where applicable.
  3. Equity Analysis: Use relevant disaggregation variables (e.g., gender, age, geography, income level) to identify equity gaps and disparities.
  4. Contextualization: Link findings to program objectives, the program's theory of change, and the relevant policy environment and external factors (e.g., policy changes, economic shocks).
  5. Interpretation: Clearly explain the statistical results and the practical implications of key trends and significant shifts.
  6. Recommendations: Develop 2-3 actionable recommendations for stakeholders, strengthened with evidence from the disaggregation variables and specific examples.

Your output must be structured as follows:

  1. Summary Table: A side-by-side comparison table presenting baseline and endline values for each indicator. Include means, standard deviations, and calculated p-values.
  2. Narrative Analysis: A detailed interpretation of the 3-5 most impactful changes observed, explaining key trends and the implications of statistical significance.
  3. Graphical Representation: Include at least one graphical representation (e.g., bar chart, line graph) to visually illustrate key findings.
  4. Actionable Recommendations: 2-3 specific, evidence-based recommendations for program adaptation or future programming, informed by the analysis of disaggregation variables and contextual factors.

If the material is incomplete: Work only from the baseline and endline data provided for the indicators listed. If a value, sample size, or p-value needed for a comparison is missing, mark that indicator's significance as not calculable, state what is missing, and continue with the comparisons you can make. Do not invent baseline or endline figures, standard deviations, or significance results.

Remove identifying columns before pasting datasets.

Also open in:GeminiCopilotThese open empty, so paste the prompt in.