An Initiative by SAARTHI IAS
Maarg Manthan · Topic 25.7

Missing Data/Value Estimation in Data Interpretation Sets

Quantitative Aptitude › Data Interpretation · Topic 25.7

Missing data estimation in a DI set means finding a value that the table or chart does not print, by using totals, averages, ratios, percentages or sum-to-100 rules that the set does provide. The missing value is the one number that makes all the given information consistent.

Share:
Missing Data/Value Estimation in Data Interpretation Sets - Quantitative Aptitude - MaargX UPSC Maarg Manthan

Quick Answer

Missing data estimation in a DI set means finding a value that the table or chart does not print, by using totals, averages, ratios, percentages or sum-to-100 rules that the set does provide. The missing value is the one number that makes all the given information consistent.

At a Glance

  • Core idea Use what is given to find what is missing
  • Clues Total, average, ratio, percentage
  • Pie rule Shares add to 100%
  • Check All rows and columns must add up
  • Method Form a simple equation
  • Data used here Fictional practice data

Where Does It Fit?

This topic follows Data Interpretation Involving Percentage, Ratio and Average Calculations and uses the same tools in reverse: instead of finding an answer from complete data, you find the data. It also relies on the caselet skill from Data Interpretation from Caselets (CAT-Level) and leads into Data Interpretation Involving Ratio and Percentage Change Across Multiple Years and Data Interpretation Sets Requiring Cross-Referencing Between Two Tables or Graphs.

What Clues Reveal a Missing Value?

In short: a missing value is found from a given total, a given average, a ratio, a percentage rule, or the fact that parts add up to a whole.

The fictional set below gives the monthly production of three plants, with some cells missing and a clue for each plant.

Plant Jan (tonnes) Feb (tonnes) Mar (tonnes) Total
P 120 150 ? 450
Q 100 ? 140 Average 120
R ? 130 150 Mar is 25% more than Jan
  • Given total: Plant P produced a total of 450 tonnes, so March = 450 – 120 – 150 = 180.
  • Given average: Plant Q averaged 120 tonnes over three months, so the total = 120 × 3 = 360, and February = 360 – 100 – 140 = 120.
  • Given percentage relation: Plant R’s March output of 150 is 25% more than January. So January × 1.25 = 150, and January = 120.
  • Sum to 100: in a pie chart, if three sectors are 25%, 35% and 15%, the missing sector is 100 – 75 = 25%.

How Do You Set Up the Equation?

In short: write the unknown as x, express each clue as an equation, and solve. With one unknown and one clue, the answer is direct.

Standard set-ups

  • Missing item = Total – Sum of known items.
  • Missing item = (Average × Count) – Sum of known items.
  • If B is p% more than A, then A = B / (1 + p/100).
  • If the ratio of X to Y is a : b and X + Y = T, then X = T × a / (a + b).
  • Missing sector = 100% – Sum of the known sectors.

The completed table is shown below, so you can check the answers.

Plant Jan Feb Mar Total
P 120 150 180 450
Q 100 120 140 360
R 120 130 150 400
All plants 340 400 470 1,210
  • Check rows: 120 + 150 + 180 = 450, 100 + 120 + 140 = 360 and 120 + 130 + 150 = 400.
  • Check columns: January 340, February 400 and March 470 add to the grand total 1,210.

When Can the Value Not Be Found?

In short: if there are more unknowns than clues, or the clues repeat each other, the value cannot be determined.

  • Two unknowns, one clue: if both January and February are missing and only the total is known, many pairs fit.
  • Estimation: when a chart shows bars without numbers, estimate to the nearest gridline, and prefer answer options far apart.
  • Link to sufficiency: asking whether the data is enough is the idea behind Data Sufficiency – Two-Statement Format (Statement I and Statement II).

Solved Examples

Example 1

Question: In the practice set, what is Plant P’s output in March?

  1. Plant P’s three-month total = 450.
  2. Known months: 120 + 150 = 270.
  3. March = 450 – 270 = 180.

Answer: 180 tonnes.

Example 2

Question: What is Plant Q’s output in February?

  1. Average = 120 over 3 months, so the total = 360.
  2. Known months: 100 + 140 = 240.
  3. February = 360 – 240 = 120.

Answer: 120 tonnes.

Example 3

Question: What is Plant R’s output in January?

  1. March = 150 and it is 25% more than January.
  2. January × 1.25 = 150.
  3. January = 150 / 1.25 = 120.

Answer: 120 tonnes.

Example 4

Question: Three sectors of a pie chart are 25%, 35% and 15%. What is the fourth sector in degrees?

  1. Fourth sector = 100% – 75% = 25%.
  2. Angle = 25 × 3.6 = 90 degrees.

Answer: 90 degrees.

Example 5

Question: The ratio of two numbers is 3 : 2 and their sum is 50. What are the numbers?

  1. Total parts = 3 + 2 = 5.
  2. First number = 50 × 3 / 5 = 30.
  3. Second number = 50 × 2 / 5 = 20.

Answer: 30 and 20.

Shortcuts and Tricks

  • Convert every clue into an equation with a single unknown.
  • For an average clue, multiply the average by the count to get the total first.
  • For a percentage more than, divide by (1 + p/100), not subtract p percent.
  • After finding the value, check that every row and column still adds up.
  • If two unknowns remain after using all clues, mark the answer as not determinable.

Common Mistakes

  • Subtracting 25% from 150 to find the base, when the correct step is dividing by 1.25.
  • Forgetting to multiply the average by the count.
  • Using a total that includes the missing value as if it were complete.
  • Assuming a missing value equals its neighbour.
  • Failing to re-check the column totals after filling a row.

Practice Questions

  1. Plant P produced 120, 150 and a missing amount in three months with a total of 500. What is the missing amount?
  2. A plant averages 90 tonnes over 4 months. Three months give 80, 100 and 95. What is the fourth?
  3. A value is 20% more than the January value. If the value is 180, what is January?
  4. Pie sectors of 40%, 30% and 10% are shown. What is the fourth sector in degrees?
  5. Two numbers are in the ratio 5 : 3 and their sum is 64. What is the smaller?
  6. What is the total of all plants in March in the completed practice table?

Answers: 1) 230; 2) 85; 3) 150; 4) 72 degrees; 5) 24; 6) 470.

Why Is This Topic Important?

  • Reasoning It tests whether you can use clues, a core DI skill.
  • Flexibility The same data can be used forward or backward.
  • Accuracy Row and column checks catch errors early.
  • Link Missing-data thinking prepares for Data Sufficiency – Two-Statement Format (Statement I and Statement II).

What Comes Next?

The next topic is Data Interpretation Involving Ratio and Percentage Change Across Multiple Years. It uses data from several years and asks for ratios and percentage changes, often with a missing value.

Key Terms and Formulas

  • Missing value A number that must be found from clues
  • Given total A printed sum that includes the missing value
  • Clue Any statement that links known and unknown values
  • Consistent Agreeing with all given facts
  • Unknown The letter or symbol for the missing value
  • Not determinable The data is not enough for one answer

Exam Corner

Points to Remember

  • Missing value equals total minus known values.
  • Average times count gives the total.
  • For p% more, divide by 1 + p/100.
  • Pie shares add to 100%.
  • Check every row and column.

Do Not Confuse With

  • Percent more vs percent less The base is different, so the reverse step differs.
  • Average vs total An average must be multiplied by the count to get the total.
  • Ratio vs actual number A ratio needs a total or one actual value to give numbers.
  • Estimate vs exact Estimate from charts without numbers, and calculate exactly when numbers are given.

Memory Hook

Clue, equation, check.

GS Relevance

Missing-value data interpretation sets for SSC CGL, CAT and CSAT: finding unknown cells from totals, averages, ratios and percentage rules.

Frequently Asked Questions

How do you find a missing value in a data interpretation table?

A missing value in a data interpretation table is found by using a given total, average, ratio or percentage relation to form an equation. For a plant with a total of 450 and known months of 120 and 150, the missing month is 450 minus 270, which is 180.

How do you find a missing total from an average?

A missing total is found by multiplying the average by the number of items. A plant averaging 120 tonnes over three months produced 360 tonnes in total, and subtracting the known months, 100 and 140, leaves 120 tonnes for the missing month.

How do you find the base when a value is 25 per cent more?

The base is found by dividing the value by 1 plus the percentage as a decimal. If a value of 150 is 25 per cent more than January, January equals 150 divided by 1.25, which is 120, and not 150 minus 25 per cent of 150.

How do you find a missing sector in a pie chart?

A missing sector in a pie chart is found by subtracting the known shares from 100 per cent, because all sectors add to 100 per cent or 360 degrees. If three sectors are 25, 35 and 15 per cent, the fourth is 25 per cent, or 90 degrees.

When is a missing value not determinable?

A missing value is not determinable when there are more unknowns than independent clues, such as two missing months and only the total given. In that case many pairs of values fit the data, so a single answer cannot be found without more information.

PYQ Practice — Statement Analysis

1 If a value of 150 is 25 per cent more than January, January equals 120.
True

150 / 1.25 = 120.

2 A missing total from an average is found by dividing the average by the count.
False

It is found by multiplying the average by the count.

3 The sectors of a pie chart add to 100 per cent.
True

So a missing sector is 100 per cent minus the known ones.

4 With two unknown values and one total clue, the answer is always unique.
False

Many pairs of values can fit one total.

Share: