13.3 Table Analysis: Interactive Sorting, Filtering, and Trend Identification

13.3 Table Analysis: Interactive Sorting, Filtering, and Trend Identification

Quick Summary: Table Analysis (TA) questions on the GMAT Focus Edition present a complex, multi-column dataset accompanied by an introductory narrative and three binary evaluation statements. The defining feature of the TA interface is the interactive column sort dropdown, which allows you to reorder the entire table ascending or descending by any column. The central tactical imperative in TA is never manually scan an unsorted table: sorting transforms time-consuming, error-prone visual searches into instantaneous lookups of extremes, medians, percentiles, contiguous subgroups, and bivariate correlations.

---

Anatomy of the Table Analysis Interface

Every Table Analysis item consists of three distinct components:

1. Contextual Text (Prompt Header): An introductory passage defining the background scenario, data sources, column definitions, units of measurement (e.g., "in thousands of metric tons" or "expressed as an index from 0 to 100"), and any special conditions or footnotes.
2. The Interactive Table: A sortable data grid with multiple rows and columns. Above the table sits the dropdown menu:
   [ Sort by: [ Select Column v ] ]
   Selecting a column immediately re-indexes every row in either ascending (A-to-Z, lowest-to-highest) or descending order.
3. The Dichotomous Question Block: Three statements, each requiring a binary decision (Yes/No or True/False). All three statements must be answered correctly for raw score credit.

---

The Power of the Interactive Sort

Under exam pressure, untrained candidates often treat Table Analysis like a static textbook diagram, scanning up and down with their eyes or a finger on the screen. In a 20-row, 6-column table (120 individual cells), visual scanning leads to omission errors (skipping a row that satisfies a condition) and consumes 60 to 90 seconds per statement.

By leveraging the sort dropdown, you can execute complex statistical and logical tasks in seconds:

---

Advanced Analytical Applications of Sorting

1. Rapid Median and Percentile Isolation

Consider a table with 17 rows (N = 17, an odd number). A statement asks: "The median annual revenue of the surveyed software firms is greater than $45 million."

• Manual Scanning: You would have to write down or track all 17 numbers, rank them, and find the 9th number. Time: ~75 seconds; risk of error: high.
• Sort Execution:
  1. Select Sort by: Revenue ($M).
  2. Calculate median index: (17 + 1) / 2 = 9.
  3. Count directly down to Row 9. If Row 9 is $48M, the statement is verified in 8 seconds.

For an even number of rows, say N = 20:

• The median falls halfway between Row 20/2 = 10 and Row 10 + 1 = 11.
• Sort ascending by the column, look directly at Row 10 and Row 11, and calculate their arithmetic mean: (Row 10 + Row 11) / 2.

For Quartiles and Percentiles:

• 25th Percentile (Q1) in a 20-row table: bounded by Row 5 (20 * 0.25).
• 75th Percentile (Q3): bounded by Row 15 (20 * 0.75).
• Interquartile Range (IQR): Value at Row 15 - Value at Row 5.

2. Bivariate Correlation vs. Strict Monotonicity

Test developers frequently ask whether two variables exhibit a positive relationship, negative relationship, or strictly increasing (monotonic) relationship.

• General Correlation: Does Variable Y tend to rise as Variable X rises?
  Method: Sort by X ascending. Divide the table into an upper half (low X) and a lower half (high X). Compare the average or median of Y in the upper half to that in the lower half. If high-X rows predominantly show higher Y values, positive correlation is supported.
• Strict Monotonicity: "For any two countries in the table, the country with the higher GDP per capita also has a higher life expectancy."
  Method: Sort by GDP per capita ascending. Now inspect life expectancy from top to bottom. To satisfy strict monotonicity, every single row must have a life expectancy greater than or equal to the row immediately preceding it. A single inversion (e.g., Row 4 is 78.2 and Row 5 is 77.9) immediately disproves the statement.

---

Comprehensive Worked Example: Global Maritime Logistics

Let us analyze a representative GMAT Focus Table Analysis dataset consisting of 15 major container ports.

Contextual Narrative

The table below provides operational metrics for 15 major international container ports in 2025. Annual throughput is reported in millions of Twenty-Foot Equivalent Units (TEU). Average vessel turnaround time measures the mean hours from berth arrival to departure. Rail connectivity indicates the percentage of inbound container volume transferred directly to intermodal rail freight. The Port Efficiency Index (PEI) is an aggregate score on a scale from 1 to 100 calculated by an independent maritime agency.

Table: Major International Container Ports (2025)

---

Step-by-Step Problem Walkthrough

Task: Evaluate each of the following three statements. Select Yes if the statement can be verified from the table; otherwise, select No.

1. The median Annual Throughput for the 15 ports is greater than 15.0 million TEU.
2. Among ports with Rail Connectivity exceeding 20.0%, there is a strictly monotonic inverse relationship between Rail Connectivity and Port Efficiency Index.
3. The mean Port Efficiency Index of the ports located in East Asia is greater than 88.0.

Detailed Analytical Verification

Statement 1: Median Annual Throughput

1. Operation: Sort the table by Annual Throughput (M TEU) ascending.
2. Identify Median Position: There are N = 15 ports (an odd number). The median is row (15 + 1) / 2 = 8.
3. Ascending Order of Throughput:
   • Row 1: Port Mu (5.4)
   • Row 2: Port Omicron (7.8)
   • Row 3: Port Kappa (8.2)
   • Row 4: Port Theta (9.4)
   • Row 5: Port Delta (10.6)
   • Row 6: Port Nu (11.2)
   • Row 7: Port Zeta (12.1)
   • Row 8: Port Gamma (14.8)
   • Row 9: Port Eta (15.3)
   • Rows 10–15: Port Xi (18.5), Port Epsilon (24.2), Port Lambda (28.0), Port Beta (31.5), Port Iota (37.0), Port Alpha (47.3).
4. Evaluate Value: Row 8 is Port Gamma with throughput 14.8 million TEU. Because 14.8 < 15.0, the median throughput is NOT greater than 15.0 million TEU.
5. Verdict for Statement 1: No.

Statement 2: Strict Monotonicity in Filtered Subgroup

1. Operation: Filter for ports with Rail Connectivity (%) > 20.0%, then sort that subset by Rail Connectivity ascending.
2. Isolate the Subgroup:
   • Port Theta: Rail = 22.0%, PEI = 69
   • Port Omicron: Rail = 25.0%, PEI = 65
   • Port Delta: Rail = 28.5%, PEI = 74
   • Port Kappa: Rail = 31.0%, PEI = 76
   • Port Gamma: Rail = 38.0%, PEI = 81
   • Port Zeta: Rail = 42.0%, PEI = 84
3. Check for Inverse Monotonicity:
   An inverse monotonic relationship requires that as Rail Connectivity increases, PEI must strictly decrease (or at least never increase) across every single consecutive step.
   • Moving from Port Theta (22.0%, PEI 69) to Port Omicron (25.0%, PEI 65): PEI decreases (69 to 65).
   • Moving from Port Omicron (25.0%, PEI 65) to Port Delta (28.5%, PEI 74): PEI increases from 65 to 74!
   • In fact, for the higher rail ports (Delta, Kappa, Gamma, Zeta), PEI continuously climbs (74 to 76 to 81 to 84).
4. Verdict: The relationship is not inverse monotonic; it violates the condition immediately.
5. Verdict for Statement 2: No.

Statement 3: Mean PEI for East Asia Ports

1. Operation: Sort by Region to cluster all East Asia ports together.
2. Isolate East Asia Cluster:
   • Port Alpha: PEI = 92
   • Port Beta: PEI = 86
   • Port Epsilon: PEI = 89
   • Port Lambda: PEI = 88 Total East Asia ports = 4.
3. Compute the Mean:
   $\text{Sum of PEI} = 92 + 86 + 89 + 88 = 355$ $\text{Mean PEI} = \frac{355}{4} = 88.75$
4. Evaluate Value: Because 88.75 > 88.0, the statement is mathematically confirmed.
5. Verdict for Statement 3: Yes.

Final Correct Dichotomous Triplet: Statement 1 = No; Statement 2 = No; Statement 3 = Yes.

---

Calculator Strategy in Table Analysis

While an on-screen calculator is provided in Data Insights, relying on it for every step is a trap. Use this decision rule:

• Estimate When Bounding: If asked whether a sum is greater than 500, and rounding the numbers down yields 520, the condition is satisfied without opening the calculator.
• Use Calculator for Multi-Digit Division: When computing precise values like 355 / 4 = 88.75 or percentage changes where numbers are close to the threshold (e.g., verifying whether a value is 14.8% vs 15.2%), launch the calculator immediately, enter the values, and record the result.