Mixed graphs

1. What mixed graphs test

A mixed-graph set distributes information across two or more visual representations. One chart may show the number of applicants to an examination, while another shows the percentage who qualified. Alternatively, bars may represent annual production and a line may represent the percentage sold. Neither representation alone answers every question; the candidate must establish the mathematical relationship between them.

Common combinations include bars and lines sharing a horizontal axis, a pie chart accompanied by a table of totals, and two separate charts describing different aspects of the same categories. The shared link may be a year, quarter, district, product or population group. Before calculating, confirm that both sources refer to the same category, period and coverage.

CSAT questions commonly ask for totals, ratios, percentage changes, weighted averages, rankings or conclusions supported by the data. A question may also be impossible to determine because a necessary total is absent. Recognising such insufficiency is as important as performing arithmetic. Do not assume missing values from general knowledge or from the apparent shape of a graph.

• Bar plus line: often links an absolute quantity with a rate, percentage or price.
• Pie chart plus table: often links category shares with totals or per-unit values.
• Two charts: may require matching categories before deriving a third quantity.

2. Read the visual language before calculating

Start with the title, legend, horizontal categories and vertical scales. Note whether quantities are expressed in units, thousands, lakh or crore. A value of 80 on an axis labelled thousand units means 80,000 units. Likewise, ₹5 crore and ₹500 lakh are equal, although their displayed numbers differ greatly. Unit conversion should precede addition or comparison.

In a dual-axis chart, bars may use the left axis while the line uses the right axis. Their apparent intersection has no inherent numerical meaning. A bar reaching 100 thousand units and a line reaching 80% cannot be compared as though they represent the same variable. Check for truncated axes, unequal intervals and explicitly printed data labels before estimating values.

Read the percentage base carefully. Qualification rate usually means qualified candidates divided by applicants, but a question may instead give qualified candidates as a percentage of those who appeared. Similarly, profit as a percentage of cost differs from profit as a percentage of revenue. The words surrounding the chart determine which denominator is valid.

Distinguish flows from stocks and annual values from cumulative values. Quarterly sales are a flow over a period; inventory at quarter-end is a stock at a particular time. Adding cumulative monthly totals double-counts earlier observations. Also, unsold current production is not necessarily closing inventory because opening stock, returns or transfers may exist.

• Write a short unit label beside every derived quantity.
• Treat missing observations as unknown, not zero.
• Use printed values where available; avoid extracting false precision from an approximate diagram.

3. Core calculations and denominator discipline

When a bar supplies a total and a line supplies a percentage, multiply them to obtain the corresponding quantity. If production is P and the percentage sold is s, units sold equal P × s/100. Units not sold from that production equal P × (100 − s)/100, provided the percentage specifically refers to current production.

For comparisons over time, percentage change equals (new value − old value)/old value × 100. The earlier value is the base. A rise in a rate from 40% to 50% is 10 percentage points but a 25% relative increase. These two descriptions are not interchangeable. Reverse questions also require care: if sales after a 20% increase are 120, earlier sales were 120/1.20, or 100.

Aggregate rates normally require weighting. If one centre qualifies 50% of 100 applicants and another qualifies 80% of 400 applicants, their combined qualification rate is (50 + 320)/(100 + 400) × 100 = 74%. The simple average, 65%, gives equal weight to centres of unequal size and is incorrect.

For pie charts, category quantity equals total × sector percentage/100, or total × sector angle/360. Shares from different years cannot establish absolute growth unless the respective totals are known. A category's share can fall even while its absolute quantity rises if the overall total grows sufficiently.

• Revenue = quantity sold × selling price per unit.
• Overall rate = sum of relevant outcomes / sum of relevant base quantities × 100.
• Ratio comparisons can often be simplified by cancelling a shared total or common unit.

4. Worked mixed-graph example

The table below represents a hypothetical mixed-graph set: bars show quarterly production, a line shows the percentage of that quarter's production sold, and an accompanying table gives selling prices. Assume the reported sales are entirely from the corresponding quarter's production. These figures are illustrative examination data, not observations about an actual enterprise.

For Q2, production is 120 thousand units and 75% is sold. Sales therefore equal 90 thousand units. At ₹60 per unit, revenue is ₹54 lakh. A useful conversion is that thousand units multiplied by rupees per unit gives thousand rupees; divide this result by 100 to express it in lakh rupees.

Across all quarters, production totals 500 thousand units and sales total 407 thousand units. The overall sold proportion is therefore 81.4%, not the simple average of the four percentages, which is 81.25%. Production volumes provide the weights. The small difference illustrates why apparently close answers still require the correct method.

The highest production occurs in Q3, but the highest revenue occurs in Q4. Q3 sells 120 thousand units at ₹50 each, whereas Q4 sells 117 thousand at ₹80 each. Thus, neither the tallest production bar nor the highest sales quantity alone identifies the highest revenue. The required ranking depends on the variable named in the question.

• Quarterly sales, in thousand units: Q1 = 80; Q2 = 90; Q3 = 120; Q4 = 117.
• Quarterly revenue, in ₹ lakh: Q1 = 40; Q2 = 54; Q3 = 60; Q4 = 93.6.
• Current production not sold, in thousand units: Q1 = 20; Q2 = 30; Q3 = 30; Q4 = 13.

5. An efficient CSAT solving strategy

Read the question before doing extensive calculations. Identify the target variable and locate only the values needed for it. If the question asks about revenue, production alone is insufficient: first derive sales and then apply price. A compact scratch table with category, total, rate and derived quantity reduces repeated graph reading and transcription errors.

Estimate before calculating exactly. Compare products, cancel common factors and use familiar fractions where helpful: 75% is three-fourths and 12.5% is one-eighth. Approximation is useful when options are well separated, but close alternatives require exact arithmetic. Never round intermediate values so heavily that a ranking or answer choice may change.

Finish with a plausibility check. A sold percentage between 75% and 90% must produce an aggregate within that interval. Revenue must carry a currency unit, while a ratio is dimensionless. If an answer contradicts these checks, inspect the denominator, axis or conversion. In a qualifying examination, dependable selection of solvable sets is preferable to spending excessive time on one calculation-heavy question.

• Separate information explicitly provided from quantities that must be derived.
• Do not infer causation merely because two plotted variables move together.
• Where required bases are missing, assess whether the answer is genuinely indeterminate.

Previous year questions

No UPSC question has been asked directly on this micro-topic yet. Use the practice questions below.

Practice questions