UPSC CMS – Quantitative Aptitude
Tables
Quick tip: Think of a table like a recipe card for numbers – it keeps everything in neat rows and columns so you can find the information you need quickly.
1. What is a Table?
A table is a grid of numbers arranged in rows (horizontal) and columns (vertical).
Each cell holds a single value.
Tables let you see patterns, compare data, and solve problems faster than looking at a list of numbers.
Analogy:
Imagine a grocery list written in a table:
- Row 1: Apples – 3kg, Bananas – 2kg
- Row 2: Milk – 1L, Bread – 2 loaves
You can quickly see how much each item costs or how many you need.
2. Everyday Analogy
| Item | Quantity | Price per Unit |
|---|---|---|
| Apples | 3 kg | ₹40/kg |
| Bananas | 2 kg | ₹30/kg |
- Rows = different items.
- Columns = different attributes (quantity, price).
- Cells = the actual numbers.
In exams, tables are used to show test scores, survey results, or any grouped data.
3. Types of Tables in UPSC
| Type | When It’s Used | Example |
|---|---|---|
| Simple Frequency Table | Count how many times each value occurs. | Scores of 50 students. |
| Cumulative Frequency Table | Add up counts as you go down. | Ages of people in a village. |
| Cross‑Tabulation (Contingency) Table | Compare two categories. | Gender vs. satisfaction level. |
| Comparative Table | Show two sets of data side by side. | Sales in 2023 vs. 2024. |
| Stacked Table | Show parts of a whole. | Population distribution by age group. |
4. Reading a Table
- Look at the headers – they tell you what each column means.
- Find the row that matches your query (e.g., “Score 70”).
- Read the cell that sits at the intersection of that row and the column you need (e.g., “Number of students”).
- Do the math if required (add, divide, multiply).
5. Common Questions & How to Solve
| Question | What to Do | Quick Formula |
|---|---|---|
| How many students scored 70? | Find row “70” → read column “Frequency”. | N/A |
| What is the mean score? | Sum of (Score × Frequency) ÷ Total students. | Σ(S × f) ÷ N |
| What is the median score? | Find the middle value using cumulative frequencies. | Cumulative count ≥ N/2 |
| What percentage scored above 80? | (Students > 80 ÷ Total) × 100. | (Σf for >80 ÷ N) × 100 |
| What is the mode? | The score with the highest frequency. | Highest f |
6. Tiny Example
Frequency Table of Scores (in a Class)
| Score | Frequency |
|---|---|
| 60 | 2 |
| 65 | 4 |
| 70 | 3 |
| 75 | 5 |
| 80 | 6 |
- Total students = 2 + 4 + 3 + 5 + 6 = 20
- Mean = (60×2 + 65×4 + 70×3 + 75×5 + 80×6) / 20
= (120 + 260 + 210 + 375 + 480) / 20 = 73 - Median: 20 students → middle positions 10 and 11.
Cumulative counts:
60 → 2, 65 → 6, 70 → 9, 75 → 14 → Median = 75 (between 70 and 75, choose 75). - Mode = 80 (highest frequency).
- Percentage above 70 = (5 + 6) / 20 × 100 = 55 %
7. Quick Tips for UPSC
- Always check the total (sum of frequencies) before calculating mean or percentages.
- Use cumulative frequency to find median quickly.
- Look for the highest frequency to spot the mode.
- Remember formulas:
- Mean = Σ(Score × Frequency) ÷ Total
- Percentage = (Part ÷ Whole) × 100
- Practice with real data: Use past exam tables or news statistics to get comfortable.
8. Practice Problem
| Year | Population (in millions) |
|---|---|
| 2018 | 1.20 |
| 2019 | 1.25 |
| 2020 | 1.30 |
| 2021 | 1.35 |
| 2022 | 1.40 |
Questions
- What is the total population over the five years?
- What is the average yearly population?
- What is the percentage increase from 2018 to 2022?
Answers
- 1.20 + 1.25 + 1.30 + 1.35 + 1.40 = 6.50 million
- 6.50 ÷ 5 = 1.30 million (average per year)
- Increase = 1.40 –