UPSC CAPF – Quantitative Aptitude
Topic: Tables
Tables are a compact way of presenting data. In the CAPF exam they appear in
- Data interpretation questions
- Quick calculation problems
- Comparative analysis (ratios, percentages, trends)
1. Simple Explanation
A table is a systematic arrangement of data in rows and columns.
- Rows represent distinct entities (e.g., months, cities, years).
- Columns represent attributes or variables (e.g., rainfall, population, price).
- A cell contains the value that corresponds to the intersection of a row and a column.
The goal is to read the table accurately, compare values, and use the data to answer questions quickly.
2. Key Points
| Item | What to Look For | Why it Matters |
|---|---|---|
| Header & Units | Ensure you know the units (kg, %, years, etc.) | Prevents mis‑calculations |
| Scale & Range | Notice if the numbers are in thousands, millions, or percentages | Helps in mental scaling |
| Special Symbols | “>”, “<”, “≈”, “–” | Indicates approximations or missing data |
| Legend | Sometimes a key is provided | Clarifies abbreviations |
| Pattern | Look for trends (increasing, decreasing, cyclical) | Useful for questions on growth/decline |
| Totals & Averages | Check if sums or averages are given | Often needed for percentage calculations |
3. Common Types of Tables in CAPF
| Type | Typical Use | Example |
|---|---|---|
| Frequency Distribution | Count of occurrences | Age group: 0‑10 → 1200, 11‑20 → 1500 |
| Cross‑Tabulation | Relationship between two variables | City × Gender |
| Time‑Series / Trend | Change over time | `Year |
| Ratio / Proportion | Comparison of parts to whole | Sold × Unsold |
| Percentages | Parts of a whole | Votes % |
4. How to Read and Interpret a Table
-
Identify the Question Type
- Comparison → look for relative values.
- Percentage change → need initial & final values.
- Average → compute if not given.
-
Locate the Relevant Cells
- Use the row and column headers.
- If the table is large, use the “X‑Y” approach (e.g., 3rd row, 5th column).
-
Convert Units if Needed
- 1,000 = 1K, 1,000,000 = 1M, etc.
- Keep track of thousands/millions to avoid errors.
-
Perform Quick Arithmetic
- Use mental math tricks:
- Multiplying by 10 → add a zero.
- Dividing by 10 → move decimal one place left.
- Multiplying by 5 → multiply by 10 then halve.
- Use mental math tricks:
5. Constructing Tables (When Data is Given in Text)
- List Variables – Decide what will be rows and what will be columns.
- Create Headers – Include units.
- Fill Cells – Translate text into numbers.
- Check for Consistency – Verify totals, averages, or any relationships mentioned.
6. Using Tables for Problem Solving
| Problem Type | Typical Calculation | Quick Trick |
|---|---|---|
| Percentage change | ((New - Old)/Old × 100) | Compute ratio first (New/Old), subtract 1, then ×100. |
| Ratio comparison | (\frac{A}{B}) | Simplify by common factors. |
| Average | (\frac{Sum}{Count}) | If sum is given, use it directly. |
| Growth over years | (\frac{Last Year - First Year}{First Year} × 100) | Same as percentage change. |
| Finding missing value | Use given totals or averages to solve for unknown. | Set up equation: KnownSum + Unknown = Total. |
7. Worked Example
Question (CAPF‑style)
A table shows the monthly rainfall (in mm) of City X from January to December:
| Month | Rainfall (mm) |
|---|---|
| Jan | 85 |
| Feb | 110 |
| Mar | 95 |
| Apr | 120 |
| May | 200 |
| Jun | 250 |
| Jul | 300 |
| Aug | 280 |
| Sep | 190 |
| Oct | 140 |
| Nov | 90 |
| Dec | 70 |
(a) Which month had the maximum rainfall?
(b) What was the total rainfall for the year?
(c) What was the average monthly rainfall?
(d) By what percent did the rainfall in July exceed the rainfall in June?
Solution
| Step | Calculation | Result |
|---|---|---|
| (a) | Look for the largest number | July (300 mm) |
| (b) | Sum all months | 85+110+95+120+200+250+300+280+190+140+90+70 = 2 250 mm |