← Explore exam analytics

GMAT · Table Analysis · TOPIC LESSON

Sorting tables and testing data claims

Preserve row identities, calculate the right denominator and test each claim separately.

GMAT35 min study guide8 indexed sections

BY THE END, YOU CAN

  • Explain read units and headers
  • Explain sorting without losing row identity
  • Explain filtering multiple conditions
  • Explain count versus rank
  • Explain median after sorting
  • Explain percent change and denominators
  • Explain correlations versus causes
  • Explain all-some-none claims
  • Explain binary judgments per row
  • Explain missing data versus false claims

BEFORE YOU START

  • Percent change, averages and medians
  • Meaning of all, some and none

Original educational lesson. Work through the examples before revealing the practice answers. This original lesson supports current GMAT study through an editorial skill map. It does not reproduce official questions, predict exam content or guarantee a score.

LEARN THROUGH ORIGINAL PRACTICE

Original GMAT-style worked examples and practice

All passages, examples and exercises here are original. No official GMAC questions, choices or explanations are reproduced. This independent preparation resource is not affiliated with or endorsed by GMAC. GMAT is a trademark of the Graduate Management Admission Council.

01 / UNDERSTAND & APPLY

Read headers, units and missing-value conventions

Table Analysis asks you to evaluate claims against a structured dataset. First identify what each row represents and which columns are counts, rates, times or categories. A value such as 20 is uninterpretable without its header.

Fictional production table: columns are team, January units, February units, February operating hours, and February defective units. Rows: A: 80,100,20,2; B: 100,90,15,0; C: 60,90,18,3; D: 120,150,30,6; E: 40,60,12,not recorded; F: 100,110,22,1. Units produced include defective units. A blank defect entry means unknown, not zero.

The figure is an original static representation of a sortable table. These lessons show the reasoning behind sorting; they do not require an interactive sorting widget.

Full-size scientific diagram. Swipe or scroll horizontally; keyboard users can focus the diagram and use arrow keys.

Production records: keep each team’s values togetherTeam, Jan units, Feb units, Feb hours, Feb defects; A, 80, 100, 20, 2; B, 100, 90, 15, 0; C, 60, 90, 18, 3; D, 120, 150, 30, 6; E, 40, 60, 12, Unknown; F, 100, 110, 22, 1. Original fictional data. Produced units include defects; Unknown does not mean zero.Production records: keep each team’s values togetherTeamJan unitsFeb unitsFeb hoursFeb defectsA80100202B10090150C6090183D120150306E406012UnknownF100110221Original fictional data. Produced units include defects; Unknown does not mean zero.
Original fictional data. Produced units include defects; Unknown does not mean zero.

ORIGINAL WORKED EXAMPLE

Interpret a row before calculating

Production table: What is Team A’s February gross output per operating hour?

  1. Use February units=100 and February hours=20 from the same row.
  2. Gross output includes defective units, so do not subtract 2 for this question.
  3. 100/20=5 units per operating hour.

Answer 5 units/hour

02 / UNDERSTAND & APPLY

Sort entire records, not isolated cells

Sorting a table by February units changes the order of rows, not which team owns each value. Sorting only one numeric column would corrupt the data by attaching it to the wrong team. Ties must remain visible.

Ascending February order is E(60), B(90), C(90), A(100), F(110), D(150), with B and C interchangeable within the tie. A rank question must specify how ties are handled; a count question simply counts records satisfying its condition.

ORIGINAL WORKED EXAMPLE

Count is not rank

Production table: How many teams produced at least 100 February units, and which team had the third-largest distinct February output? Give both answers.

  1. Qualifying teams for at least 100 are A, D and F, so the count is 3.
  2. Distinct outputs in descending order are 150,110,100,90,60.
  3. The third distinct output is 100, held by A.

Answer Count: 3; team: A

ORIGINAL PRACTICE · 1

Production table: Name all teams tied at 90 February units.

Reveal answer & reasoning

B and C

Both rows contain 90 in the February units column. Sorting does not break or eliminate the tie.

03 / UNDERSTAND & APPLY

Combine conditions with AND or OR carefully

A multiple-condition filter is an intersection for AND and a union for inclusive OR. Check each condition against the same row. A row satisfying only one condition fails an AND filter.

Do not confuse “at least” with “more than.” Threshold equality matters, especially when a table contains observations exactly at the boundary.

ORIGINAL WORKED EXAMPLE

Two simultaneous thresholds

Production table: Which teams have February output at least 90 and February hours at most 20?

  1. A:100 and 20 qualifies; B:90 and 15 qualifies; C:90 and 18 qualifies.
  2. D has 30 hours and F has 22, so both fail the time condition. E has only 60 units.
  3. All conditions are tested row by row, not against separate lists with lost identities.

Answer A, B and C

ORIGINAL PRACTICE · 1

Production table: How many teams have February output greater than January output AND at most 18 February operating hours?

Reveal answer & reasoning

2

C improves 60→90 with 18 hours and E improves 40→60 with 12 hours. B has 15 hours but declines; the other teams exceed 18 hours.

ORIGINAL PRACTICE · 2

Production table: How many teams have February output below 90 OR operating hours above 25?

Reveal answer & reasoning

2

E qualifies through output 60. D qualifies through hours 30. No other row meets either condition; count each qualifying row only once.

04 / UNDERSTAND & APPLY

Sort the target variable before locating its center

For an even number of observations, the median is the average of the two central values after sorting. Sorting by a different column does not automatically order the target variable. Missing values also require a stated treatment rather than an invented zero.

The median is robust to some extreme-value changes but still depends on positions. The mean uses every value and can move when an extreme value changes even if the median stays fixed.

ORIGINAL WORKED EXAMPLE

Median and mean differ

Production table: Find the median and mean February output.

  1. Sorted outputs are 60,90,90,100,110,150.
  2. Median is (third+fourth)/2=(90+100)/2=95.
  3. Total=600 across 6 teams, so mean=100.

Answer Median: 95 units; mean: 100 units

ORIGINAL PRACTICE · 1

Production table: What is the median February operating time?

Reveal answer & reasoning

19 hours

Sorted times are 12,15,18,20,22,30. The middle pair is 18 and 20, whose average is 19.

05 / UNDERSTAND & APPLY

Choose the baseline before computing a percentage

Percent change=(new−old)/old×100%. A percentage increase measured against January uses January as denominator, not February. A defective-unit rate uses defective units divided by the relevant total units, not operating hours.

Equal absolute increases can have different percentage changes. A 20-unit gain on a base of 40 is 50%, while the same gain on a base of 80 is 25%.

ORIGINAL WORKED EXAMPLE

Compare relative changes

Production table: Do Teams C and E have equal percentage increases from January to February?

  1. C increases by 30 on base 60: 30/60=50%.
  2. E increases by 20 on base 40: 20/40=50%.
  3. Their absolute increases differ but their relative increases match.

Answer Yes, each increases 50%

ORIGINAL PRACTICE · 1

Production table: Is B’s January-to-February change −10% or approximately −11.11%? Select one.

Reveal answer & reasoning

−10%

The change is −10 with January base 100, so −10/100=−10%. Dividing by February’s 90 answers a different comparison.

ORIGINAL PRACTICE · 2

Production table: What is D’s February defective-unit rate?

Reveal answer & reasoning

4%

Six defective units out of 150 total gives 6/150=0.04. The 30 operating hours are not the denominator.

06 / UNDERSTAND & APPLY

Test all, some and none with the right proof burden

An “all” claim fails with one counterexample and succeeds only after every relevant row is checked or a valid general argument covers them. A “some” claim needs one witness. A “none” claim fails with one witness.

For each binary row, apply the stated criterion separately. Multiple claims can all be true or all false. There is no prescribed pattern of responses.

ORIGINAL PRACTICE · 1

Production table: Select True or False for each of three rows: (i) All teams increased output; (ii) some teams increased by 50%; (iii) no team produced more than 5 units/hour in February.

Reveal answer & reasoning

(i) False; (ii) True; (iii) False

B declined, refuting (i). C and E each gained 50%, supporting (ii). B produced 90/15=6 units/hour, refuting (iii). This is one exercise requiring three row judgments.

07 / UNDERSTAND & APPLY

Unknown is not zero and not a proven negative

A missing observation prevents some conclusions but does not automatically make the associated claim false. Use the question’s requested labels: “Supported by the table” can be answered no when evidence is missing, even though the claim could happen to be true.

For the production set, E’s defect count is not recorded. You can calculate E’s gross productivity and growth, but you cannot calculate its nondefective output or its exact defect rate.

ORIGINAL PRACTICE · 1

Production table: Select Supported or Not supported for each of two rows: (i) E had zero defective units; (ii) the other five teams had 12 defective units in total.

Reveal answer & reasoning

(i) Not supported; (ii) Supported

Missing E data cannot establish zero. Known counts sum 2+0+3+6+1=12. The overall six-team total is not thereby fixed.

08 / UNDERSTAND & APPLY

A table can describe a pattern without explaining it

Teams with longer operating times tend here to have higher output, but a descriptive pattern does not show that assigning more hours would produce the same effect for every team. Equipment, staffing, demand and other variables may differ.

A final audit checks row identity, units, denominator, missingness and quantifier. This sequence is more reliable than performing every available calculation and then searching for a matching answer.

KEEP THE BIG IDEAS

Quick revision

  • Sort whole rows and preserve ties.
  • Use the requested variable to find the median.
  • Name the percent denominator explicitly.
  • Missing data mean unknown; association does not establish causation.
Back to the top ↑

READ WITH CONTEXT

References & scope

The teaching notes, passages, worked explanations and practice are original. Official references identify the assessment framework and skill scope; they do not endorse this lesson or license official question reproduction.

Explore this topic in context

GMAT analytics distinguish current structure from incomplete reviewed public-sample observations. Questions, response parts and shared stimuli have separate counts. Unreviewed items are excluded; zero reviewed observations do not imply exam absence.

KEEP EXPLORING

Your next idea is waiting.

Back to Data Insights index →Browse all topic notes