Uttar Pradesh Patwari / Lekhpal /Quantitative Aptitude

Tables

Data Interpretation · free study notes · Updated

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

  1. Identify Pattern

    • For each region, sales increase each month.
    • Find the monthly increment for each region.
  2. 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.

  3. 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.
  4. 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 ]

  5. 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.

Your note

Page 1

Doubt hai is topic me?

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