Now that our data is collected, and cleaned properly, we can move on to the analysis steps. This is where we look at the data to find patterns, trends, and answers to the questions we asked in Step 1.
Suppose that you have a clean and organized table of data, for example, student responses about their favorite sport or study times. Now you may ask question like "what does this data tell us?" This step helps us make decisions based on what we discover in the data.
What Does it mean to Analyze Data
Analyzing data means carefully examining data to (i) Summarize it (e.g., how many students chose each option), (ii) Compare different groups (e.g., boys vs girls, morning vs evening), (iii) Find patterns (e.g., most students prefer football and play in the evening).
You may use measures like counts (how many?), averages, frequency (how often?) etc.
Using Simple Tools for Analysis
You can start analyzing data with simple tools such as Google Sheets, Microsoft Excel or manual writing in a notebook
Example: You surveyed 20 students. Table 5.4 shows what you may have found.
| Favorite Sport | Frequency |
|---|---|
| Cricket | 10 |
| Football | 5 |
| Hockey | 4 |
| Badminton | 1 |
From this data, we can observe that most students prefer cricket.
ACTIVITY
Data Cleaning
Objective: Learn how to identify and correct common data entry mistakes (such as spelling errors, missing values, and inconsistent formatting).
Instructions:
- Review the Messy Table 5.2
| Sr. No. | Name | Favorite Sport | Frequency | Time of Day |
|---|---|---|---|---|
| 1 | Sadiq | Cricket | Daily | Evening |
| 2 | Noor | Cricket | Weekly | |
| 3 | Maryam | Football | morning | |
| 4 | Zara | Football | Daily | Afternoon |
- Work in pairs: Sit with a partner and study the table together.
- Spot and List Errors: Find at least 5 errors. These may include: Spelling mistakes (e.g., Cricket, Daily), Missing data (e.g., blank cells), Inconsistent formatting (e.g., Football vs football, morning not capitalized)
- Correct the Errors: (i) Discuss how to fix each error logically and fairly. (ii) Rewrite the cleaned table neatly in your notebook.
- Class Sharing (optional): (i) Compare your cleaned table with another group. (ii) See if they found the same errors or different ones.
- Data analysis helps us find patterns and make decisions.
- We use counts and comparisons to understand data.
- Even simple tools like tables or spreadsheets can help us analyze data.
ACTIVITY
Data Analysis
Objective: Learn how to analyze data by identifying trends and drawing basic conclusions from a frequency table.
Instructions:
Use your own survey data (if available) or the sample data given in Table 5.5 below:
| Sport | Frequency or No. of Students |
|---|---|
| Cricket | 7 |
| Football | 6 |
| Hockey | 5 |
| Badminton | 2 |
Carefully read the table showing how many students like each sport.
Identify: (i) The most popular sport, (ii) The least popular sport Write one reason why each sport might be most or least popular in your class. Present your findings in your notebook using simple sentences.
This step is to finding meaning from data (i.e., identifying trends and patterns). After summarizing the data, we may ask ourselves:
- What do the numbers tell us?
- Why are some options more popular?
- Are there any surprises or patterns?
Example: If we find that most late students live far from the school, we can recommend providing transport support as a solution.
After analyzing the data, the final step is to share the results in a way that others can understand easily. People usually understand pictures better than numbers, which is why we use data visualizations.
Remember that in previous step, we found that cricket was the most popular sport. In this step, we will create a chart that shows this clearly. This makes it easy to present our findings to classmates, teachers, or others.