An Initiative by SAARTHI IAS
Maarg Manthan · Topic 25.11

Data Interpretation Sets Requiring Cross-Referencing Between Two Tables or Graphs

Quantitative Aptitude › Data Interpretation · Topic 25.11

Data interpretation sets that need cross-referencing give two tables or graphs that share a key, such as the same colleges or years. An answer needs a value from the first display and a value from the second, which are then combined.

Share:
Data Interpretation Sets Requiring Cross-Referencing Between Two Tables or Graphs - Quantitative Aptitude - MaargX UPSC Maarg Manthan

Quick Answer

Data interpretation sets that need cross-referencing give two tables or graphs that share a key, such as the same colleges or years. An answer needs a value from the first display and a value from the second, which are then combined.

At a Glance

  • Format Two displays sharing a key
  • Common key Row or column label
  • Typical step Number × Percentage = Count
  • Output A working table
  • Risk Mismatched rows or units
  • Data used here Fictional practice data

Where Does It Fit?

This is the last topic of the Data Interpretation macro and brings together Data Interpretation from Tables, Mixed Data Interpretation Sets Combining Multiple Graph Types and Data Interpretation Involving Percentage, Ratio and Average Calculations. The skill of deciding what the data can and cannot answer leads directly to the next macro, which starts with Data Sufficiency – Two-Statement Format (Statement I and Statement II).

What Does Cross-Referencing Mean?

In short: cross-referencing means using one display to supply a number and another display to supply a percentage or price, then combining them for each item.

The fictional data below gives the enrolment of three colleges in two streams, and then the pass percentage in each stream.

College Arts enrolment Science enrolment Total enrolment
P 400 300 700
Q 500 200 700
R 300 600 900
College Arts pass % Science pass %
P 60% 80%
Q 70% 75%
R 50% 90%
  • Common key: the college and the stream appear in both tables. Match them carefully.
  • Combining step: the number who passed equals enrolment multiplied by the pass percentage.
  • College P, Arts: 60% of 400 = 240 passed.
  • College R, Science: 90% of 600 = 540 passed.

How Do You Build and Use a Working Table?

In short: compute the combined values once, store them in a working table, and answer every question from it.

College Arts passed Science passed Total passed Overall pass %
P 240 240 480 68.57%
Q 350 150 500 71.43%
R 150 540 690 76.67%

Rules for cross-referencing

  • Count passed = Enrolment × Pass percentage / 100.
  • Overall pass % = Total passed / Total enrolment × 100. Do not average the two stream percentages.
  • Share of a college in the total = College passed / All passed × 100.
  • Cross-check: the sum of Arts passed and Science passed must equal the Total passed.
  • Overall pass % of P: 480 / 700 = 68.57%, not the average of 60% and 80%, which is 70%.
  • Arts across colleges: 240 + 350 + 150 = 740 passed out of 1,200, which is 61.67%.
  • Science across colleges: 240 + 150 + 540 = 930 passed out of 1,100, which is 84.55%.

What Traps Exist in Cross-Referenced Sets?

In short: the traps are averaging percentages of unequal groups, mixing up rows between tables, and forgetting that a high percentage on a small group gives few people.

  • Averaging percentages: the simple average of 60% and 80% is 70%, but College P has 400 Arts and 300 Science students, so the correct overall figure is 68.57%.
  • Small groups: College Q has 75% in Science, but only 150 passed because only 200 enrolled.
  • Row order: the second table may list colleges in a different order. Match by name, not by position.
  • Next step: when a value cannot be found from the two tables, treat the question as one of data sufficiency, as in Data Sufficiency – Two-Statement Format (Statement I and Statement II).

Solved Examples

Example 1

Question: How many Arts students of College Q passed?

  1. Q’s Arts enrolment = 500 and pass rate = 70%.
  2. Passed = 70 / 100 × 500 = 350.

Answer: 350 students.

Example 2

Question: What is the overall pass percentage of College R (to two decimal places)?

  1. Arts passed = 50% of 300 = 150.
  2. Science passed = 90% of 600 = 540.
  3. Total passed = 690 out of 900.
  4. 690 / 900 × 100 = 76.67%.

Answer: About 76.67%.

Example 3

Question: Which college has the highest overall pass percentage?

  1. P = 480 / 700 = 68.57%, Q = 500 / 700 = 71.43%, R = 690 / 900 = 76.67%.
  2. The highest is R.

Answer: College R.

Example 4

Question: What percentage of all Science students in the three colleges passed (to two decimal places)?

  1. Science enrolment = 300 + 200 + 600 = 1,100.
  2. Science passed = 240 + 150 + 540 = 930.
  3. 930 / 1,100 × 100 = 84.55%.

Answer: About 84.55%.

Example 5

Question: What is the ratio of the number of students who passed in College P to the number who passed in College Q?

  1. P passed = 480 and Q passed = 500.
  2. 480 : 500 = 24 : 25.

Answer: 24 : 25.

Shortcuts and Tricks

  • Find the common key first and mark it in both tables.
  • Compute all combined values once and keep them in a working table.
  • Never average percentages of unequal groups. Use counts.
  • Cross-check row and column totals after building the table.
  • Match entries by name when the order of rows differs between tables.

Common Mistakes

  • Averaging the Arts and Science percentages to get an overall percentage.
  • Using the wrong row because the tables list colleges in a different order.
  • Treating a high percentage on a small group as a large number of students.
  • Forgetting to convert the percentage to a number before comparing groups.
  • Not checking that the totals match after combining.

Practice Questions

  1. How many Science students of College P passed?
  2. What is the overall pass percentage of College P (to two decimal places)?
  3. How many students in total passed in all three colleges?
  4. What percentage of all Arts students in the three colleges passed (to two decimal places)?
  5. Which college had the largest number of Science students who passed?
  6. What is the difference between the number of Arts students and Science students who passed in College Q?

Answers: 1) 240; 2) 68.57%; 3) 1,670; 4) 61.67%; 5) College R; 6) 200.

Why Is This Topic Important?

  • Exam pattern Two-table sets appear in SSC CGL and in CAT.
  • Reasoning They test whether you can combine information correctly.
  • Accuracy A working table prevents repeated, error-prone calculations.
  • Link Deciding when data is enough leads to Data Sufficiency – Two-Statement Format (Statement I and Statement II).

What Comes Next?

The next macro is Data Sufficiency, which starts with Data Sufficiency – Two-Statement Format (Statement I and Statement II). It asks not for the answer itself but whether the given statements are enough to find it.

Key Terms and Formulas

  • Cross-referencing Using two displays together
  • Common key A label that appears in both displays
  • Working table Your own table of combined values
  • Enrolment The number of students registered
  • Pass percentage Students passed out of students enrolled, as a percentage
  • Overall percentage The percentage on the total of all groups

Exam Corner

Points to Remember

  • Match rows by name, not position.
  • Convert percentages to counts first.
  • Never average percentages of unequal groups.
  • Use a working table.
  • Cross-check totals.

Do Not Confuse With

  • Overall vs average percentage Overall uses total counts, and the average ignores group sizes.
  • Number vs percentage A high percentage on a small group can be a small number.
  • Enrolled vs passed Enrolled is the base, and passed is the part.
  • Table 1 vs table 2 Each supplies a different quantity, so both are needed.

Memory Hook

Match the key, multiply, and total.

GS Relevance

Cross-referencing data interpretation for SSC CGL, CAT and CSAT: combining two tables or graphs that share a key to answer linked questions.

Frequently Asked Questions

What is cross-referencing in data interpretation?

Cross-referencing in data interpretation is the use of two tables or graphs that share a common key, such as the college and stream. One display gives the number of students and the other gives a pass percentage, and the two are combined to find the number passed.

How do you find the number who passed from two tables?

The number who passed is found by multiplying the enrolment from the first table by the pass percentage from the second table and dividing by 100. College P's Arts stream, with 400 students and a 60 per cent pass rate, has 240 students who passed.

Why should percentages not be averaged across groups?

Percentages should not be averaged across groups of different sizes because each group counts differently. College P's average of 60 and 80 per cent is 70, but its true overall pass rate is 480 out of 700 students, which is 68.57 per cent.

How do you avoid mistakes in two-table sets?

Mistakes in two-table sets are avoided by finding the common key, matching rows by name instead of position, building one working table of combined values, and checking that row and column totals agree. Converting percentages to counts first prevents the common error of averaging them.

When is the data in two tables not enough?

The data in two tables is not enough when a quantity needed for the answer appears in neither table, or when they give only percentages without a base. In such cases the correct response in a sufficiency question is that the data cannot determine the answer.

PYQ Practice — Statement Analysis

1 The overall pass percentage of a college is always the simple average of its stream percentages.
False

The streams have different numbers of students, so counts must be used.

2 College P's 400 Arts students with a 60 per cent pass rate give 240 passes.
True

60 / 100 × 400 = 240.

3 Rows in two tables must be matched by name, not by position.
True

The tables may list items in different orders.

4 A high pass percentage on a small group always means many students passed.
False

The number depends on the size of the group.

Share: