Mixed Data Interpretation Sets Combining Multiple Graph Types
Quantitative Aptitude › Data Interpretation · Topic 25.5
A mixed data interpretation set combines two or more displays, such as a table with a bar graph or a pie chart with a line graph, in one question set. The solver reads each display, links them through a common item, and then calculates the answer.
6 min read · Quantitative Aptitude · Data Interpretation
Quick Answer
A mixed data interpretation set combines two or more displays, such as a table with a bar graph or a pie chart with a line graph, in one question set. The solver reads each display, links them through a common item, and then calculates the answer.
At a Glance
- Format Two or more displays in one set
- Link A common item such as region or year
- Typical calculation Units × Price = Revenue
- First step Read every display and its units
- Common trap Mixing units of two displays
- Data used here Fictional practice data
Where Does It Fit?
This topic follows the single-display topics Data Interpretation from Tables, Data Interpretation from Bar Graphs and Line Graphs and Data Interpretation from Pie Charts. It leads into Data Interpretation Involving Percentage, Ratio and Average Calculations, which deals with the percentage, ratio and average steps used inside these sets, and Data Interpretation Sets Requiring Cross-Referencing Between Two Tables or Graphs, which focuses on cross-referencing two tables.
What Makes a Mixed Set Different?
In short: in a mixed set, no single display gives the answer. One display may give the number of units, another gives the price, and the question asks for revenue, which needs both.
The practice set below shows a table of units and prices (the numbers a bar graph and a line graph would show) and the revenue computed from them. It is fictional.
| Region | Units sold | Price per unit (Rs) | Revenue (Rs) |
|---|---|---|---|
| North | 200 | 50 | 10,000 |
| South | 300 | 40 | 12,000 |
| East | 150 | 60 | 9,000 |
| West | 350 | 30 | 10,500 |
| Total | 1,000 | – | 41,500 |
- Common key: the region is the key that joins the units to the prices. Always find the item that links the displays.
- Units differ: the first display counts units, and the second gives rupees per unit. Check before multiplying.
- Derived quantities: revenue is not printed anywhere in the original displays. You must build it.
How Do You Solve a Mixed Set Step by Step?
In short: read all displays, build one working table on paper, and answer from that table.
- Write the title and units of each display.
- Identify the common key, such as region or year.
- Build one working table with one row per key and one column per quantity.
- Compute the derived column, such as revenue = units × price.
- Answer the questions from the working table, and cross-check the grand total.
Quantities that mixed sets often combine
- Revenue = Units sold × Price per unit.
- Weighted average price = Total revenue / Total units. Here 41,500 / 1,000 = 41.5.
- Profit = Revenue – Cost.
- Share of total = Part / Total × 100.
The percentage, ratio and average steps used here are explained in Data Interpretation Involving Percentage, Ratio and Average Calculations.
What Are the Traps in Mixed Sets?
In short: the usual errors are mixing units, using a simple average where a weighted average is needed, and comparing displays that use different bases.
- Simple vs weighted average: the simple average of the four prices is (50 + 40 + 60 + 30) / 4 = 45. The correct average price per unit sold is 41.5, because regions sold different numbers of units.
- Units: a bar graph in thousands and a table in units must be converted first.
- Consistency check: the sum of regional revenues must equal the total revenue. If it does not, a value has been misread.
Solved Examples
Example 1
Question: Using the practice set, what is the revenue from the South region?
- South units = 300 and price = Rs 40.
- Revenue = 300 × 40 = 12,000.
Answer: Rs 12,000.
Example 2
Question: Which region earned the highest revenue, and which sold the most units?
- Revenues: North 10,000, South 12,000, East 9,000, West 10,500.
- The highest revenue is South at 12,000.
- Units: the highest is West at 350.
Answer: South has the highest revenue, and West sold the most units.
Example 3
Question: What percentage of the total revenue came from the West region (to two decimal places)?
- West revenue = 350 × 30 = 10,500.
- Total revenue = 10,000 + 12,000 + 9,000 + 10,500 = 41,500.
- Share = 10,500 / 41,500 × 100 = 25.30%.
Answer: About 25.30%.
Example 4
Question: What is the average price per unit sold across all regions?
- Total revenue = 41,500 and total units = 1,000.
- Average price = 41,500 / 1,000 = 41.5.
Answer: Rs 41.5 per unit.
Example 5
Question: What percentage of the total units were sold in the West region?
- West units = 350 and total units = 1,000.
- Share = 350 / 1,000 × 100 = 35%.
Answer: 35%.
Shortcuts and Tricks
- Build a working table with all derived columns before reading the questions.
- Use the weighted average, total value divided by total units, and not the average of the prices.
- Cross-check the grand total by adding the row values.
- Convert all units once, at the start.
- When one display is a pie chart, convert its shares to values using the total first.
Common Mistakes
- Taking the simple average of prices when quantities differ.
- Multiplying units by the wrong column.
- Forgetting to convert thousands to units.
- Reading a value from the wrong region because the displays list regions in a different order.
- Ignoring the common key and comparing unrelated items.
Practice Questions
- What is the revenue from the East region?
- What percentage of the total revenue came from the South region (to one decimal place)?
- What is the ratio of North units to West units?
- By how much does West revenue exceed North revenue?
- What is the simple average of the four prices?
- What is the average revenue per region?
Answers: 1) Rs 9,000; 2) 28.9%; 3) 4 : 7; 4) Rs 500; 5) Rs 45; 6) Rs 10,375.
Why Is This Topic Important?
- Exam pattern Mixed sets are common in CAT and in higher-level SSC papers.
- Integration They test whether you can combine ideas from Data Interpretation from Tables and Data Interpretation from Pie Charts.
- Real use Business reports often show units in one chart and prices in another.
- Foundation for The cross-referencing in Data Interpretation Sets Requiring Cross-Referencing Between Two Tables or Graphs uses the same working-table method.
What Comes Next?
The next topic is Data Interpretation Involving Percentage, Ratio and Average Calculations. It focuses on the percentage, ratio and average calculations that run through every mixed set.
Key Terms and Formulas
- Mixed set A DI set that uses more than one display
- Common key The item that links two displays
- Derived column A quantity calculated from the displays
- Weighted average Total value divided by total quantity
- Working table Your own table that merges the displays
- Cross-check Verifying a total in two ways
Related Topics
- Data Interpretation from Caselets (CAT-Level)
- Data Interpretation Involving Percentage, Ratio and Average Calculations
- Data Interpretation from Tables
- Data Interpretation from Bar Graphs and Line Graphs
Exam Corner
Points to Remember
- Read every display and its units first.
- Find the key that links the displays.
- Build one working table.
- Use weighted averages for mixed quantities.
- Cross-check the grand total.
Do Not Confuse With
- Simple vs weighted average A simple average ignores quantities, and a weighted average uses them.
- Units vs revenue Units are a count, and revenue is units times price.
- Share of units vs share of revenue They are different because prices differ.
- Mixed set vs two separate sets In a mixed set the displays depend on each other.
Memory Hook
Link, build, then answer.
GS Relevance
Frequently Asked Questions
What is a mixed data interpretation set?
A mixed data interpretation set uses two or more displays, such as a table and a pie chart or a bar graph and a line graph, in one set of questions. The solver must link the displays through a common item and combine their data to compute each answer.
How do you calculate revenue from a units table and a price table?
Revenue is calculated by multiplying the units sold by the price per unit for each item or region. In the practice set, the South region sold 300 units at Rs 40 each, so its revenue is Rs 12,000, and the sum across regions gives the total.
Why is the simple average of prices wrong in a mixed set?
The simple average of prices is wrong when quantities differ, because every price is counted equally even if one region sold more units. The correct figure is total revenue divided by total units, which is 41.5 in the practice set, not the simple average of 45.
How should you read a mixed DI set efficiently?
A mixed DI set is read efficiently by noting the units of each display, finding the common key, building one working table with derived columns, and answering from that table. A final check that the regional values add up to the printed total catches most reading errors.
Where do mixed sets appear in competitive exams?
Mixed sets appear mainly in CAT and in the higher-level sections of SSC papers, and they test how well a candidate combines tables, bar graphs, line graphs and pie charts. Practising single-display sets first makes the combined sets much easier to solve.
PYQ Practice — Statement Analysis
1 The simple average of prices equals the average price per unit sold in every case.
It does so only when each price has the same number of units sold.
2 Revenue equals units sold multiplied by price per unit.
For example, 300 units at Rs 40 gives Rs 12,000.
3 In the practice set, the West region has the highest revenue.
South is highest at Rs 12,000, and West is Rs 10,500.
4 The common key in a mixed set joins the displays.
For example, the region links units to prices.
Related Topics
Browse the full Quantitative Aptitude index