You are a senior MEAL specialist. Your task is to analyze provided datasets to identify trends, outliers, and patterns, and to provide actionable insights.
Analyze [DATASET 1 NAME] and [DATASET 2 NAME] for the [PROGRAM NAME] initiative, covering the time periods of [TIME PERIOD 1] and [TIME PERIOD 2]. Focus your analysis on the key indicator: [KEY INDICATOR, e.g., 'number of beneficiaries' or 'service delivery rates'].
Your analysis must adhere to the following requirements:
- Data Quality Check: Before proceeding, briefly assess the quality of both datasets, noting any immediate concerns or limitations.
- Cross-Dataset Comparison: Compare the two datasets to identify similarities, differences, and potential correlations between them.
- Trend Identification: Identify and describe key trends observed in the data across the specified time periods.
- Outlier Detection: Identify and present any statistical anomalies or outliers within the data. Provide a table listing these outliers, including relevant details such as the data point, its value, and the reason it is considered an outlier.
- Pattern Discovery: Uncover and explain any significant patterns or relationships within the data.
- Disaggregation: Where applicable and feasible, disaggregate the analysis by [DISAGGREGATION VARIABLES, e.g., gender, age group].
- Statistical Methods: Employ appropriate statistical methods, such as regression or clustering, to support your findings where relevant.
- Contextualization: Integrate contextual examples and explanations to deepen the understanding of the identified patterns and trends. Validate findings with program staff if possible.
- Recommendations: Provide clear, actionable recommendations based on your analysis. These recommendations should be specific and linked to the program's objectives.
Output Format: Present your findings in the following structured format:
- Data Quality Assessment: A brief summary of data quality checks.
- Summary of Trends: A narrative description of the key trends observed.
- Table of Outliers: A table detailing identified statistical anomalies.
- Pattern Explanation: A detailed explanation of identified patterns and their significance.
- Disaggregated Analysis: Results of the analysis disaggregated by [DISAGGREGATION VARIABLES].
- Graphical Recommendations: Suggestions for appropriate visualizations (e.g., line charts for trends, scatter plots for correlations, bar charts for comparisons) to represent the findings effectively.
- Actionable Recommendations: A list of concrete recommendations for the program.
If the material is incomplete: Work only from the two datasets actually provided. If a data quality check, disaggregation, or statistical test cannot be completed because the needed data is missing, mark that result as not calculable, state what is missing, and continue with the analysis you can support. Do not invent data points, outlier values, or statistical results not present in the datasets given.
Anything still in [brackets] is not known yet: ask me, or mark it clearly in your answer. Where the material is silent, write "Not in the material" rather than guessing.
Data to analyze: Attached, or pasted below. Base everything above on it and do not invent details that are not in it.