UPSC CMS /Quantitative Aptitude

Tables

Data Interpretation · free study notes

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

  1. Look at the headers – they tell you what each column means.
  2. Find the row that matches your query (e.g., “Score 70”).
  3. Read the cell that sits at the intersection of that row and the column you need (e.g., “Number of students”).
  4. 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

  1. Always check the total (sum of frequencies) before calculating mean or percentages.
  2. Use cumulative frequency to find median quickly.
  3. Look for the highest frequency to spot the mode.
  4. Remember formulas:
    • Mean = Σ(Score × Frequency) ÷ Total
    • Percentage = (Part ÷ Whole) × 100
  5. 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

  1. What is the total population over the five years?
  2. What is the average yearly population?
  3. What is the percentage increase from 2018 to 2022?

Answers

  1. 1.20 + 1.25 + 1.30 + 1.35 + 1.40 = 6.50 million
  2. 6.50 ÷ 5 = 1.30 million (average per year)
  3. Increase = 1.40 –

Your note

Page 1

Doubt hai is topic me?

Free AI teacher se poocho — 24/7, step by step.