Data Analysis for M&E
Introduction to Data Analysis
Data's Role in M&E
Monitoring and Evaluation (M&E) runs on data. But raw data—spreadsheets full of numbers, stacks of survey forms, or transcripts from interviews—doesn't tell you much on its own. The goal is to turn that raw material into something useful. That's where data analysis comes in.
Data analysis is the process of inspecting, cleaning, and modeling data to discover useful information, draw conclusions, and support decision-making. In M&E, this means figuring out if a program is working as intended, why it is or isn't, and what can be done better. It’s how we find the story hidden in the information we collect.
Two Types of Data
The data you collect generally falls into two categories: quantitative and qualitative. Understanding the difference is key because they tell you different things and are analyzed in different ways.
Quantitative data is anything you can count or measure. It deals with numbers and statistics. Think of it as the "what," "how much," and "how many."
Qualitative data is descriptive. It deals with words, observations, and interpretations. This is the "why" and "how" behind the numbers.
Imagine you're evaluating a tutoring program. The number of students who passed an exam is quantitative data. Notes from a focus group where students described their experience with the tutors? That's qualitative.
Neither type is better than the other; they work best together. The numbers tell you what happened, and the stories tell you why.
| Feature | Quantitative Data | Qualitative Data |
|---|---|---|
| Format | Numbers, graphs, tables | Words, images, observations |
| Asks | How many? How much? | Why? How? In what way? |
| Example | 85% of participants completed the training. | Participants said they felt more confident after the training. |
| Analysis | Statistical calculations | Interpretation of themes and patterns |
Finding the Center
When you have a set of numbers, you often want to find a typical or central value. This is a way to summarize the entire dataset with a single number. Three common ways to do this are by finding the mean, median, and mode.
Mean
noun
The average of all the numbers in a dataset. You find it by adding up all the values and dividing by the count of values.
Median
noun
The middle number in a dataset that has been arranged in order from smallest to largest. If there's an even number of values, the median is the average of the two middle numbers.
The median is useful because it isn't affected by unusually high or low values, known as outliers.
Mode
noun
The number that appears most often in a dataset.
While mean, median, and mode tell you about the center of your data, it's also helpful to know how spread out the data is. Variance is a measure of this spread. A small variance means the data points are clustered closely around the mean. A large variance means they are more spread out.
Good Data In, Good Insights Out
Your analysis is only as good as the data you put into it. This is a core principle in data analysis, often summarized as "garbage in, garbage out." Before you can find meaningful insights, you must ensure your data has quality and integrity.
Data quality is crucial in data analysis because it directly impacts the validity of the insights gained.
What makes data high-quality?
- Accuracy: Is the data correct? A simple typo can throw off your results.
- Completeness: Are there missing values? If many participants didn't answer a survey question, it's hard to draw a reliable conclusion.
- Consistency: Is the data recorded in the same way everywhere? For example, are dates all in the same format (MM/DD/YYYY)?
Ensuring data quality isn't a one-time step. It's an ongoing process of checking and cleaning to make sure your conclusions are built on a solid foundation.
In the context of Monitoring and Evaluation (M&E), what is the primary purpose of data analysis?
An M&E team is evaluating a job training program. They have collected the number of graduates who found employment and transcripts from interviews where graduates describe their job-seeking experiences. How would you categorize these two types of data?