Uttar Pradesh Patwari / Lekhpal – Quantitative Aptitude
Topic: Tables
1. Simple Explanation
In Quantitative Aptitude, a table is a systematic arrangement of numbers in rows and columns.
They are used to:
- Organise data (e.g. frequency tables, age tables, time tables).
- Show relationships (e.g. multiplication tables, conversion tables).
- Make comparisons easy (e.g. comparing sales across months).
The key to solving problems with tables is to read the structure correctly, understand the pattern, and use arithmetic/logic to fill missing entries or derive required quantities.
2. Key Points
| # | Concept | Why It Matters | Quick Tip |
|---|---|---|---|
| 1 | Table Structure | Rows = categories; Columns = sub‑categories or values. | Always label both axes. |
| 2 | Missing Data | Often one or more cells are blank; you must infer them. | Use row/column totals or given relationships. |
| 3 | Patterns | May involve arithmetic progression, geometric progression, ratios, or percentages. | Look for consistent differences or multipliers. |
| 4 | Cross‑Tabulation | Two variables are interrelated (e.g., Age vs. Salary). | Use the “sum of rows” or “sum of columns” to deduce unknowns. |
| 5 | Conversion Tables | Convert units (e.g., km/hr ↔ m/s). | Memorise basic conversion factors. |
| 6 | Percentage Tables | Show how much one part contributes to a whole. | Convert percentages to fractions for easier calculation. |
| 7 | Data Interpretation | Extract the required number (e.g., maximum, minimum, average). | Scan the table for the keyword in the question. |
3. Worked Example
Problem
A table shows the sales of a product in 4 regions for the first 3 months of 2025. The 4th month data for Region B is missing. Fill the missing value.
| Region | Jan | Feb | Mar | Apr |
|---|---|---|---|---|
| A | 120 | 140 | 160 | 180 |
| B | 100 | 110 | 130 | ? |
| C | 90 | 95 | 110 | 120 |
| D | 80 | 85 | 100 | 110 |
Solution Steps
-
Identify Pattern
- For each region, sales increase each month.
- Find the monthly increment for each region.
-
Calculate Increments
- Region A: 140‑120 = 20; 160‑140 = 20 → increment = 20.
- Region B: 110‑100 = 10; 130‑110 = 20 → not constant.
- Region C: 95‑90 = 5; 110‑95 = 15 → not constant.
- Region D: 85‑80 = 5; 100‑85 = 15 → not constant.
Since the increments are not constant, look for a ratio or percentage increase.
-
Compute Percentage Increase
- Region A: 20/120 = 16.67 % each month.
- Region B:
- Jan→Feb: 10/100 = 10 %
- Feb→Mar: 20/110 ≈ 18.18 %
- The pattern seems irregular; try a linear fit using the first two months to extrapolate.
-
Linear Extrapolation for Region B
Assume a linear increase from Jan to Mar:
[ \text{Average increment} = \frac{(110-100)+(130-110)}{2} = \frac{10+20}{2}=15 ] Apply this to Mar→Apr:
[ \text{Apr sales} = 130 + 15 = 145 ] -
Check Consistency
- The average increment (15) lies between the two monthly increments (10 and 20).
- This gives a reasonable estimate.
Answer
The missing value for Region B in April is 145.
4. Quick Revision Summary
| Topic | What to Remember |
|---|---|
| Table Basics | Rows: categories; Columns: sub‑categories; always label axes. |
| Finding Missing Data | Use totals, patterns, or logical deduction; consider averages or ratios. |
| Patterns to Spot | Arithmetic progression, geometric progression, percentage changes, ratios. |
| Cross‑Tabulation | Row/column totals help deduce unknowns; check for “sum of rows” or “sum of columns”. |
| Conversion Tables | Memorise key unit conversions (e.g., 1 km = 1000 m, 1 hr = 60 min). |
| Percentage Tables | Convert percentages to fractions for easier arithmetic. |
| Common Mistakes | - Assuming constant increments when not given. - Ignoring units. - Mixing up rows and columns. |
| Speed Tips | - Read the whole table first. - Highlight known values. - Write down patterns before calculation. |
Practice Question
In a table, the number of students who passed a test in 3 subjects (Math, Science, English) for 5 classes is given. The total number of students in each class is known. Find the number of students who passed all three subjects in Class 3.
(Use the same approach: identify totals, find missing values, apply inclusion‑exclusion if needed.)
Good luck! Keep practicing with different table formats to build speed and accuracy.