Table Analysis Practice Questions — GMAT

The table below presents operational performance metrics for six properties within a boutique hotel portfolio:

Property Name	Region	Occupancy Rate (%)	Average Daily Rate ($)	Customer Satisfaction (1–10)
Grand Azure	Coastal	82	340	9.1
Alpine Haven	Mountain	75	410	8.8
Urban Vantage	Metropolitan	88	290	8.4
Solstice Resort	Coastal	68	450	9.3
Metro Elite	Metropolitan	91	310	8.6
Highland Lodge	Mountain	79	380	9.0

Which of the following statements regarding the portfolio data are true? Select all that apply.

Select all that apply

Exactly 3 properties have an Occupancy Rate of at least 80% AND a Customer Satisfaction score of at least 8.5.

Among properties with an Average Daily Rate greater than $350, exactly 2 have a Customer Satisfaction score of at least 9.0.

No property in the Mountain region has an Occupancy Rate exceeding 80% OR an Average Daily Rate below $350.

All properties located in the Coastal region have an Occupancy Rate of at least 70% AND an Average Daily Rate of at least $350.

Exactly 4 properties satisfy at least one of the following criteria: Occupancy Rate greater than 85% OR Average Daily Rate greater than $400.

Show answer & explanation

Answer: Among properties with an Average Daily Rate greater than $350, exactly 2 have a Customer Satisfaction score of at least 9.0.; No property in the Mountain region has an Occupancy Rate exceeding 80% OR an Average Daily Rate below$ 350.; Exactly 4 properties satisfy at least one of the following criteria: Occupancy Rate greater than 85% OR Average Daily Rate greater than $400.

Answer

The correct statements are those identifying 2 properties with ADR over

350 and satisfaction of at least 9.0, stating that no Mountain property exceeds 80% occupancy or has ADR below

350, and noting that exactly 4 properties satisfy either an occupancy over 85% or an ADR over $400.

The correct options properly execute multi-column boolean criteria (AND vs. OR). Specifically: filtering properties with ADR over

350 for satisfaction at or above 9.0 correctly isolates 2 properties; evaluating Mountain region properties confirms zero satisfy either occupancy over 80% or ADR under

350; and combining properties with occupancy over 85% or ADR over $400 correctly identifies a subset of 4 properties.

Step-by-Step Solution

1

Evaluate the statement regarding Occupancy Rate

\geq 80\%

AND Customer Satisfaction

\geq 8.5

.

Properties meeting Occupancy

\geq 80\%

are Grand Azure (82%), Urban Vantage (88%), and Metro Elite (91%). Of these, Urban Vantage has a satisfaction of 8.4 (

< 8.5

). Only 2 properties meet both criteria, making this statement false.

Conjunctive filtering requires both conditions to hold simultaneously.

2

Evaluate the statement regarding properties with ADR

> \$350

having Customer Satisfaction

\geq 9.0

.

Properties with ADR

> \$350

are Alpine Haven (

\$410

), Solstice Resort (

\$450

), and Highland Lodge (

\$380

). Solstice Resort (9.3) and Highland Lodge (9.0) meet the satisfaction threshold (2 properties total), making this statement true.

First filter the subset by ADR threshold, then apply the satisfaction criterion.

3

Evaluate the statement regarding Mountain region properties having Occupancy

> 80\%

OR ADR

< \$350

.

Alpine Haven (75%,

\$410

) and Highland Lodge (79%,

\$380

) both fail both conditions. Therefore, 0 Mountain properties satisfy the OR condition, making the statement true.

Disjunctive filtering checks if at least one condition is met per property.

4

Evaluate the statement regarding Coastal properties having Occupancy

\geq 70\%

AND ADR

\geq \$350

.

Grand Azure has ADR

\$340 < \$350

, and Solstice Resort has Occupancy

68\% < 70\%

. Since neither satisfies both criteria, the statement is false.

A universal condition requires all items in the subset to satisfy the full compound logic.

5

Evaluate the statement regarding properties with Occupancy

> 85\%

OR ADR

> \$400

.

Occupancy

> 85\%

: Urban Vantage, Metro Elite. ADR

> \$400

: Alpine Haven, Solstice Resort. Combining these gives 4 unique properties, making the statement true.

An inclusive OR filter pools all elements that satisfy either criterion.

Key Concept

Conditional Filtering and Selection

Question 2Question →

Based on the data provided in the table below regarding student enrollment across four university departments in 2025, the percentage of international students in the Business department is greater than the percentage of international students in the Engineering department.

Department	Total Students	International Students
Humanities	400	80
Business	600	150
Science	500	125
Engineering	800	160

True

False

Show answer & explanation

Answer: True

Answer

True

The statement is true. In the Business department, international students account for

\frac{150}{600} = 25\%

of total students. In the Engineering department, international students account for

\frac{160}{800} = 20\%

of total students. Since

25\% > 20\%

, the percentage is indeed greater in Business.

Step-by-Step Solution

1

Calculate the percentage of international students in the Business department

\frac{150}{600} \times 100\% = 25\%

To find the percentage, divide the number of international students in Business by the total number of students in Business and multiply by 100.

2

Calculate the percentage of international students in the Engineering department

\frac{160}{800} \times 100\% = 20\%

To find the percentage, divide the number of international students in Engineering by the total number of students in Engineering and multiply by 100.

3

Compare the two calculated percentages

25\% > 20\%

Comparing

25\%

(Business) to

20\%

(Engineering) confirms that the proportion is higher in Business.

Key Concept

Calculating and comparing subgroup proportions and percentages using department-specific total bases

Question 3Question →

The table below presents clinical trial metrics and operational parameters for seven oncology drug candidates evaluated by a biopharmaceutical firm:

Drug Candidate	Trial Phase	Patient Retention Rate	Efficacy Score (1-100)	Manufacturing Cost per Dose
Candidate A	Phase II	82%	75	$140
Candidate B	Phase III	91%	88	$310
Candidate C	Phase III	78%	82	$220
Candidate D	Phase II	88%	65	$95
Candidate E	Phase I	95%	92	$450
Candidate F	Phase III	85%	79	$180
Candidate G	Phase II	80%	70	$110

Evaluate the following statement based on the provided table: "Among the drug candidates currently in Phase III, exactly two candidates satisfy the condition of having an Efficacy Score greater than 80 OR a Manufacturing Cost per Dose less than $200."

True

False

Show answer & explanation

Answer: False

Answer

False

The statement is false because three Phase III candidates (Candidates B, C, and F) meet the specified compound criterion. Candidate B and Candidate C qualify because their Efficacy Scores exceed 80 (88 and 82, respectively). Candidate F qualifies because its Manufacturing Cost per Dose (

180) is less than

200. Because an 'OR' operator requires only one of the criteria to be met, all three candidates qualify, making the claim of 'exactly two' incorrect.

Step-by-Step Solution

1

Filter the dataset for the primary condition: Trial Phase equal to Phase III.

Candidates B, C, and F are in Phase III.

The scope of the statement is restricted specifically to Phase III candidates.

2

Apply the compound logical condition (Efficacy Score > 80 OR Manufacturing Cost per Dose < $200) to each filtered candidate.

Candidate B: Efficacy 88 (>80) -> Satisfies condition.
Candidate C: Efficacy 82 (>80) -> Satisfies condition.
Candidate F: Cost

180 (<

200) -> Satisfies condition.

A disjunction (OR) requires at least one of the two sub-conditions to be true.

3

Count the total number of qualifying candidates and compare with the statement.

Total count is 3. The statement claims the count is exactly 2.

Since 3 does not equal 2, the statement is false.

Key Concept

Conditional Filtering with Compound Logical Operators

Question 4Question →

The table below details operational telemetry for eight municipal battery energy storage system (BESS) microgrid zones during 2025:

Zone Code	Battery Capacity (MWh)	Annual Energy Discharged (GWh)	Peak Efficiency (%)	Unplanned Maintenance (Hours)
Zone Alpha	120	43.2	92.5	48
Zone Beta	200	84.0	95.0	12
Zone Gamma	150	51.0	89.0	72
Zone Delta	300	117.0	94.2	24
Zone Epsilon	80	26.4	91.0	96
Zone Zeta	250	105.0	96.5	18
Zone Eta	180	59.4	88.5	60
Zone Theta	220	85.8	93.0	36

Consider the following three independent statements:

I. If the zones are sorted in ascending order by Battery Capacity (MWh), the median Peak Efficiency (%) of the lower half of the sorted zones is greater than $90.5\%$ .
II. The average annual energy discharged per MWh of battery capacity across the three zones with the fewest unplanned maintenance hours is strictly greater than $0.40\text{ GWh per MWh}$ .
III. Among the zones with a Peak Efficiency of at least $92.0\%$ , exactly four zones recorded fewer than $40$ unplanned maintenance hours.

Based on the table provided, is the evaluation that Statement I is False, Statement II is True, and Statement III is True correct?

True

False

Show answer & explanation

Answer: True

Answer

The overall evaluation is True because Statement I is False, Statement II is True, and Statement III is True.

Evaluating all three statements shows that Statement I is False (

90.0\% \ngtr 90.5\%

), Statement II is True (

0.408 > 0.40

), and Statement III is True (

4

zones meet both criteria). Thus, the proposed outcome (False, True, True) accurately describes the dataset.

Step-by-Step Solution

1

Evaluate Statement I by sorting zones by Battery Capacity and finding the median Peak Efficiency of the lower half.

Sorted capacity order: Epsilon (

80

), Alpha (

120

), Gamma (

150

), Eta (

180

), Beta (

200

), Theta (

220

), Zeta (

250

), Delta (

300

). Lower half: Epsilon (

91.0\%

), Alpha (

92.5\%

), Gamma (

89.0\%

), Eta (

88.5\%

). Efficiencies sorted:

88.5\%

,

89.0\%

,

91.0\%

,

92.5\%

. Median =

\frac{89.0\% + 91.0\%}{2} = 90.0\%

. Since

90.0\% \le 90.5\%

, Statement I is False.

Determines whether Statement I is correctly classified as False.

2

Evaluate Statement II by identifying the three zones with the minimum unplanned maintenance hours and computing their aggregate discharge per MWh of capacity.

Fewest maintenance hours: Zone Beta (

12\text{ hrs}

), Zone Zeta (

18\text{ hrs}

), Zone Delta (

24\text{ hrs}

). Sum of energy discharged =

84.0 + 105.0 + 117.0 = 306.0\text{ GWh}

. Sum of capacity =

200 + 250 + 300 = 750\text{ MWh}

. Rate =

\frac{306.0}{750} = 0.408\text{ GWh/MWh}

. Since

0.408 > 0.40

, Statement II is True.

Determines whether Statement II is correctly classified as True.

3

Evaluate Statement III by filtering zones with Peak Efficiency

\ge 92.0\%

and counting how many have unplanned maintenance hours under

40

.

Zones with Peak Efficiency

\ge 92.0\%

: Alpha (

92.5\%

,

48\text{ hrs}

), Beta (

95.0\%

,

12\text{ hrs}

), Delta (

94.2\%

,

24\text{ hrs}

), Zeta (

96.5\%

,

18\text{ hrs}

), Theta (

93.0\%

,

36\text{ hrs}

). Those with maintenance hours

< 40

: Beta, Delta, Zeta, Theta (

4

zones). Statement III is True.

Determines whether Statement III is correctly classified as True.

Key Concept

Multi-Statement Boolean Evaluation in Tabular Data

Question 5Question →

The table below presents operational metrics for municipal EV charging infrastructure across six urban transit sectors in 2025.

Transit Sector	Total EV Stations	Fast-Charging Stations	Total Energy Delivered (MWh)	Commercial Fleet Usage (MWh)
Sector Alpha	120	36	4,800	1,440
Sector Beta	200	80	7,500	3,000
Sector Gamma	150	45	5,000	1,250
Sector Delta	90	54	3,600	2,160
Sector Epsilon	160	32	6,400	1,600
Sector Zeta	80	48	2,800	1,960

Evaluate the following statement as True or False based on the information provided:

Among all transit sectors where fast-charging stations constitute at least $40\%$ of the total EV stations, the overall proportion of total energy delivered that was consumed by commercial fleets is greater than $50\%$ .

True

False

Show answer & explanation

Answer: True

Answer

True

The qualifying sectors (Beta, Delta, Zeta) have a combined commercial fleet energy consumption of

7,120

MWh out of

13,900

MWh total energy delivered, yielding an overall percentage of

51.22\%

, which exceeds

50\%

.

Step-by-Step Solution

1

Calculate the fast-charging station percentage for each transit sector to filter qualifying sectors.

Sectors Beta (

40\%

), Delta (

60\%

), and Zeta (

60\%

) qualify with fast-charging proportions

\ge 40\%

.

Filtering rows based on a specified threshold is required before aggregating cross-column data.

2

Sum the total energy delivered and commercial fleet energy usage for the qualifying sectors.

Total energy delivered =

7,500 + 3,600 + 2,800 = 13,900

MWh. Commercial fleet usage =

3,000 + 2,160 + 1,960 = 7,120

MWh.

Calculating weighted overall percentages requires finding the sum of part values over the sum of whole values.

3

Compute the overall commercial fleet energy percentage for the qualifying sectors.

\frac{7,120}{13,900} \approx 51.22\%, which is strictly greater than 50\%.

Demonstrates whether the statement's inequality condition holds true.

Key Concept

Weighted Aggregated Percentage Calculation from Filtered Table Rows

Question 6Question →

The table below displays performance metrics for six employees at a technology firm:

Employee	Department	Experience (Years)	Completed Projects
Alex	Marketing	4	12
Bianca	Sales	6	15
Carlos	Marketing	5	8
Diana	Engineering	3	14
Evan	Sales	7	10
Fiona	Marketing	8	18

How many employees work in the Marketing department AND have completed more than 10 projects?

1

2

3

4

5

Show answer & explanation

Answer: 2

Answer

2 employees meet both conditions.

To satisfy the criteria, an employee must meet both conditions: Department must be 'Marketing' AND Completed Projects must be strictly greater than 10. Evaluating each employee: Alex (Marketing, 12 projects) meets both conditions; Carlos (Marketing, 8 projects) fails the project threshold; Fiona (Marketing, 18 projects) meets both conditions. No other employees belong to Marketing. Thus, exactly 2 employees qualify.

Step-by-Step Solution

1

Identify the multi-column filter criteria from the question stem.

The criteria require Department = 'Marketing' AND Completed Projects > 10.

Both conditions must be simultaneously true for an employee to qualify.

2

Evaluate each row against both conditions.

- Alex: Marketing (Yes), 12 Projects > 10 (Yes) → Qualifies
- Bianca: Sales (No), 15 Projects > 10 (Yes) → Does not qualify
- Carlos: Marketing (Yes), 8 Projects > 10 (No) → Does not qualify
- Diana: Engineering (No), 14 Projects > 10 (Yes) → Does not qualify
- Evan: Sales (No), 10 Projects > 10 (No) → Does not qualify
- Fiona: Marketing (Yes), 18 Projects > 10 (Yes) → Qualifies

Systematic row-by-row verification prevents missed criteria.

3

Count the qualifying rows.

Alex and Fiona qualify, giving a total count of 2.

Only rows satisfying both conditions are included in the final sum.

Key Concept

Conjunctive (AND) Multi-Column Table Filtering

Question 7Question →

The table below presents operational metrics for six regional renewable energy facilities:

Facility	Energy Source	Capacity (MW)	Operational Efficiency (%)	Storage Available
Alpha	Solar	45	88%	Yes
Beta	Wind	60	75%	No
Gamma	Hydro	50	92%	Yes
Delta	Solar	30	82%	No
Epsilon	Wind	55	84%	Yes
Zeta	Hydro	70	78%	Yes

A plant manager needs to select facilities that satisfy at least one of the following criteria:
- Criterion 1: Energy Source is Wind AND Capacity is greater than 50 MW.
- Criterion 2: Storage Available is "Yes" AND Operational Efficiency is at least 85%.

Which of the following facilities meet the manager's criteria? Select all that apply.

Select all that apply

Alpha

Beta

Delta

Epsilon

Zeta

Show answer & explanation

Answer: Alpha; Beta; Epsilon

Answer

The facilities that meet the criteria are Alpha, Beta, and Epsilon.

Alpha qualifies under Criterion 2 because it has storage available and an operational efficiency of 88% (>= 85%). Beta qualifies under Criterion 1 because its energy source is Wind and its capacity is 60 MW (> 50 MW). Epsilon qualifies under Criterion 1 because its energy source is Wind and its capacity is 55 MW (> 50 MW).

Step-by-Step Solution

1

Evaluate each facility against Criterion 1 (Energy Source = Wind AND Capacity > 50 MW).

Beta (Wind, 60 MW) and Epsilon (Wind, 55 MW) satisfy Criterion 1.

Both facilities use Wind energy and have capacities strictly above 50 MW.

2

Evaluate remaining facilities against Criterion 2 (Storage Available = Yes AND Operational Efficiency >= 85%).

Alpha (Storage = Yes, 88% Efficiency) satisfies Criterion 2. Gamma also satisfies Criterion 2, while Delta and Zeta fail both criteria.

Alpha meets both required conditions of Criterion 2.

3

Combine the results for the options provided (Alpha, Beta, Delta, Epsilon, Zeta).

Alpha, Beta, and Epsilon satisfy at least one criterion.

Selection requires satisfying Criterion 1 OR Criterion 2.

Key Concept

Evaluating compound logical conditions (AND/OR conjunctions) across multiple table attributes.

Estimated Time:1m 15s

Question 8Question →

The table below details the quarterly revenues for four operating divisions of a logistics firm in 2025:

Division	Q1 Revenue ($)	Q2 Revenue ($)
North	$80,000$	$100,000$
South	$150,000$	$180,000$
East	$120,000$	$144,000$
West	$200,000$	$230,000$

What is the percentage increase in revenue from Q1 to Q2 for the North division?

20\%

25\%

80\%

125\%

12.5\%

Show answer & explanation

Answer: $25\%$

Answer

The percentage increase in revenue for the North division from Q1 to Q2 is

25\%

.

The percentage increase is calculated as

\frac{\text{Q2 Revenue} - \text{Q1 Revenue}}{\text{Q1 Revenue}} \times 100\%

. For the North division,

\frac{100,000 - 80,000}{80,000} = \frac{20,000}{80,000} = 0.25 = 25\%

.

Step-by-Step Solution

1

Find the absolute change in revenue for the North division from Q1 to Q2.

Change =

\$100,000 - \$80,000 = \$20,000

.

Percentage increase requires comparing the change relative to the initial starting value.

2

Identify the base (initial) value for the percentage calculation.

Base value = Q1 revenue =

\$80,000

.

The base for percentage change calculation is always the initial period value (Q1).

3

Calculate the percentage increase by dividing the change by the base value and multiplying by

100\%

.

Percentage Increase =

\frac{20,000}{80,000} \times 100\% = 0.25 \times 100\% = 25\%

.

To convert a ratio to a percentage, multiply the fractional increase by

100

.

Key Concept

Percentage Change from Table Data

Estimated Time:45s

Question 9Question →

The table below displays the vehicle fleet composition across four regional divisions of a logistics corporation.

Division	Electric Vehicles	Gasoline Vehicles	Total Vehicles
North	120	280	400
South	160	240	400
East	90	210	300
West	230	270	500

What percentage of the total fleet across all four divisions consists of electric vehicles?

Show answer & explanation

Answer: 37.5

Answer

The percentage of the total fleet consisting of electric vehicles across all four divisions is

37.5\%

.

To find the overall percentage of electric vehicles, sum the number of electric vehicles across all divisions (

120 + 160 + 90 + 230 = 600

) and divide by the overall total number of vehicles (

400 + 400 + 300 + 500 = 1600

). Dividing

600

by

1600

gives

0.375

, which equals

37.5\%

.

Step-by-Step Solution

1

Calculate the total number of electric vehicles across all divisions.

120 + 160 + 90 + 230 = 600

electric vehicles.

Summing the electric vehicle column values gives the total count of electric vehicles.

2

Calculate the total vehicle count across all divisions.

400 + 400 + 300 + 500 = 1600

total vehicles.

Summing the total vehicle column values provides the aggregate denominator.

3

Compute the required percentage.

\frac{600}{1600} \times 100\% = 37.5\%

.

Dividing total electric vehicles by total vehicles yields the aggregate proportion.

Key Concept

Ratio, Proportion, and Percent Calculations

Estimated Time:1m 0s

Question 10Question →

The table below shows performance and operational metrics for six regional fulfillment hubs operated by a global logistics network:

Hub ID	Region	Automation Level	On-Time Delivery Rate (%)	Daily Order Volume (thousands)
H-101	North America	High	94.5%	120
H-102	Europe	Medium	91.0%	85
H-103	Asia-Pacific	High	96.2%	150
H-104	North America	High	89.5%	110
H-105	Europe	High	95.0%	95
H-106	Asia-Pacific	Medium	92.8%	140

A fulfillment hub qualifies for an operational excellence award if it meets all of the following three conditions:
- Its Automation Level is 'High'.
- Its On-Time Delivery Rate is at least 93.0%.
- Its Daily Order Volume is greater than 100 thousand orders.

What is the total combined Daily Order Volume (in thousands) of the fulfillment hubs that qualify for the operational excellence award?

270

365

380

475

615

Show answer & explanation

Answer: 270

Answer

270 thousand orders

To qualify for the award, a hub must satisfy three conditions simultaneously: Automation Level must be 'High', On-Time Delivery Rate must be at least 93.0%, and Daily Order Volume must exceed 100 thousand. Evaluating each hub row by row:
- H-101 meets all three criteria (High, 94.5% ≥ 93.0%, 120 > 100).
- H-102 fails on all criteria.
- H-103 meets all three criteria (High, 96.2% ≥ 93.0%, 150 > 100).
- H-104 fails the delivery rate condition (89.5% < 93.0%).
- H-105 fails the order volume condition (95 ≤ 100).
- H-106 fails the automation and delivery rate conditions.

The only qualifying hubs are H-101 and H-103. Summing their order volumes gives 120 + 150 = 270 thousand.

Step-by-Step Solution

1

Identify the compound filter criteria

Hubs must simultaneously satisfy: (1) Automation Level = 'High', (2) On-Time Delivery Rate ≥ 93.0%, and (3) Daily Order Volume > 100.

The stem specifies that a hub must meet all three conditions to qualify.

2

Evaluate each hub against all three criteria

H-101: High (Yes), 94.5% ≥ 93.0% (Yes), 120 > 100 (Yes) -> Qualifies.
H-102: Medium (No), 91.0% < 93.0% (No), 85 ≤ 100 (No) -> Does not qualify.
H-103: High (Yes), 96.2% ≥ 93.0% (Yes), 150 > 100 (Yes) -> Qualifies.
H-104: High (Yes), 89.5% < 93.0% (No), 110 > 100 (Yes) -> Does not qualify.
H-105: High (Yes), 95.0% ≥ 93.0% (Yes), 95 ≤ 100 (No) -> Does not qualify.
H-106: Medium (No), 92.8% < 93.0% (No), 140 > 100 (Yes) -> Does not qualify.

A row is excluded if even one conjunctive condition is violated.

3

Aggregate the target attribute for qualifying rows

Qualifying Hubs: H-101 (120 thousand) and H-103 (150 thousand).
Total Daily Order Volume = 120 + 150 = 270 thousand.

The question asks for the sum of Daily Order Volume for the qualifying subset.

Key Concept

Multi-Column Conjunctive Table Filtering

Estimated Time:1m 30s

Question 11Question →

The table below displays the financial metrics for six companies operating across two industry sectors:

Company	Sector	Revenue ($M)	R&D Spend ($M)
Alpha Therapeutics	Biotech	120	30
Beta Bio	Biotech	200	50
Gamma Tech	IT	450	40
Delta Pharma	Biotech	160	40
Epsilon Health	Biotech	320	70
Zeta Systems	IT	500	60

Statement: For the subset of companies operating in the Biotech sector, the median annual revenue is $180 million.

True

False

Show answer & explanation

Answer: True

Answer

True

Filtering for Biotech companies gives revenues of

120M,

160M,

200M, and

320M. With 4 items, the median is the average of the 2nd and 3rd terms:

(160 + 200) / 2 = 180

million dollars.

Step-by-Step Solution

1

Filter the dataset by Sector

Identified the four Biotech companies: Alpha Therapeutics (

120M), Beta Bio (

200M), Delta Pharma (

160M), and Epsilon Health (

320M).

The statement specifically concerns companies in the Biotech sector.

2

Sort the filtered revenues in ascending order

Ordered revenues:

120M,

160M,

200M,

320M.

Determining the median requires data elements to be ordered sequentially.

3

Calculate the median for an even-count dataset

Middle two values are

160M and

200M. Median = (

160M +

200M) / 2 = $180M.

For an even number of observations

N = 4

, the median is the arithmetic mean of the

(N/2)^{\text{th}}

and

(N/2 + 1)^{\text{th}}

elements.

Key Concept

Calculating the median of a filtered table subset with an even number of items

Estimated Time:45s

Question 12Question →

The table below presents financial and operational metrics for seven portfolio companies evaluated by a venture capital firm:

Company	Sector	Revenue Growth (%)	Profitable	Employee Retention Rate (%)
Alpha Corp	Tech	35	Yes	88
Beta Health	Biotech	45	No	92
Gamma Power	CleanEnergy	28	Yes	85
Delta Pay	FinTech	50	No	78
Epsilon Bio	Biotech	40	Yes	94
Zeta Systems	Tech	60	No	82
Eta Dynamics	CleanEnergy	52	Yes	90

An investment committee will shortlist companies that satisfy at least two of the following three conditions:
1. Revenue Growth greater than $40\%$
2. Profitable (Status = Yes)
3. Employee Retention Rate of at least $90\%$

Which of the following companies meet the investment committee's criteria for shortlisting?

Select all that apply

Beta Health

Delta Pay

Epsilon Bio

Zeta Systems

Eta Dynamics

Show answer & explanation

Answer: Beta Health; Epsilon Bio; Eta Dynamics

Answer

The companies that qualify for shortlisting are Beta Health, Epsilon Bio, and Eta Dynamics.

The correct selections are Beta Health, Epsilon Bio, and Eta Dynamics because each satisfies at least two of the three stated conditions. Beta Health achieves Revenue Growth above 40% (45%) and Retention at or above 90% (92%). Epsilon Bio is Profitable and achieves Retention of at least 90% (94%). Eta Dynamics satisfies all three requirements.

Step-by-Step Solution

1

Define the three evaluation criteria explicitly

Criterion 1: Revenue Growth

> 40\%

; Criterion 2: Profitable = Yes; Criterion 3: Employee Retention Rate

\geq 90\%

.

Clear definitions prevent boundary errors when filtering multi-column data.

2

Evaluate each company against all three criteria

Alpha Corp: C1 (No, 35%), C2 (Yes), C3 (No, 88%) -> Total: 1 criterion.
Beta Health: C1 (Yes, 45%), C2 (No), C3 (Yes, 92%) -> Total: 2 criteria.
Gamma Power: C1 (No, 28%), C2 (Yes), C3 (No, 85%) -> Total: 1 criterion.
Delta Pay: C1 (Yes, 50%), C2 (No), C3 (No, 78%) -> Total: 1 criterion.
Epsilon Bio: C1 (No, 40% is not > 40%), C2 (Yes), C3 (Yes, 94%) -> Total: 2 criteria.
Zeta Systems: C1 (Yes, 60%), C2 (No), C3 (No, 82%) -> Total: 1 criterion.
Eta Dynamics: C1 (Yes, 52%), C2 (Yes), C3 (Yes, 90%) -> Total: 3 criteria.

Systematic evaluation ensures no row or condition is miscounted.

3

Identify all companies meeting at least two conditions

Beta Health (2 criteria), Epsilon Bio (2 criteria), and Eta Dynamics (3 criteria) qualify.

Filtering for total criteria count

\geq 2

yields the correct subset.

Key Concept

Multi-condition compound filtering requires evaluating individual logical constraints across multiple columns and aggregating total satisfied criteria per row.

Question 13Question →

The table below displays the industry sector, annual revenue (in millions of dollars), and number of employees for 10 tech startups.

Startup Name	Industry Sector	Annual Revenue ($M)	Employees
Apex Systems	Software	14	45
Beacon Health	Healthcare	30	110
Crest Tech	Software	42	160
Dome Logistics	Logistics	20	80
Echo Labs	Software	35	140
Flux Interactive	Software	52	210
Grid Solutions	Energy	65	190
Horizon Soft	Software	24	95
Impulse Media	Software	18	65
Jade Bio	Healthcare	32	125

Based on the table, what is the median annual revenue, in millions of dollars, for the startups in the Software sector?

24.0

29.5

31.0

35.0

43.5

Show answer & explanation

Answer: 29.5

Answer

29.5

Filtering the dataset for startups in the Software sector yields 6 revenue figures:

14M,

18M,

24M,

35M,

42M, and

52M. Sorting these values in ascending order gives: 14, 18, 24, 35, 42, 52. Since

N = 6

is an even number, the median is the arithmetic mean of the 3rd and 4th values:

\frac{24 + 35}{2} = 29.5

.

Step-by-Step Solution

1

Filter the table for startups in the Software sector.

Identified 6 Software startups with revenues of

14M,

42M,

35M,

52M,

24M, and

18M.

The question specifies restricting calculations to startups in the Software sector.

2

Sort the filtered revenues in ascending numerical order.

Sorted list: 14, 18, 24, 35, 42, 52.

Determining the median requires ordering data from smallest to largest.

3

Calculate the median for the even dataset (

N = 6

).

The two central numbers are the 3rd value (24) and the 4th value (35). The median is

\frac{24 + 35}{2} = 29.5

.

When

N

is even, the median is the average of the two middle elements.

Key Concept

Descriptive Statistics Interpretation

Estimated Time:1m 30s

Question 14Question →

The table below displays quality assurance metrics for six semiconductor lithography tools operating in a fabrication facility:

Tool ID	Process Node (nm)	Defect Density (defects/cm²)	Operational Uptime (%)	Calibration Status
TL-01	3	0.24	95.8%	Certified
TL-02	5	0.18	96.4%	Pending
TL-03	3	0.32	92.1%	Certified
TL-04	7	0.15	97.2%	Certified
TL-05	5	0.28	94.6%	Pending
TL-06	10	0.09	98.1%	Recalibrated

Based on the data provided, is the following statement True or False?

"For all lithography tools operating at a process node of $5\text{ nm}$ or smaller that also have a defect density strictly less than $0.30\text{ defects/cm}^2$ , the median operational uptime is greater than $95.0\%$ ."

True

False

Show answer & explanation

Answer: True

Answer

True. The median operational uptime for the filtered subset of tools (TL-01, TL-02, and TL-05) is 95.8%, which is greater than 95.0%.

The statement is correct (True) because applying the two compound criteria (Process Node

\le 5\text{ nm}

AND Defect Density

< 0.30\text{ defects/cm}^2

) selects tools TL-01, TL-02, and TL-05. The operational uptimes of these three tools are

95.8\%

,

96.4\%

, and

94.6\%

. Arranged in numerical order, the median value is

95.8\%

, which exceeds

95.0\%

.

Step-by-Step Solution

1

Identify the compound logical criteria specified in the statement.

Filter 1: Process Node

\le 5\text{ nm}

. Filter 2: Defect Density

< 0.30\text{ defects/cm}^2

. Target metric: Median Operational Uptime.

Both conditions must be met simultaneously (conjunction AND) before analyzing the operational uptime column.

2

Filter the rows based on the Process Node criterion.

Candidate tools meeting Process Node

\le 5\text{ nm}

: TL-01 (3 nm), TL-02 (5 nm), TL-03 (3 nm), and TL-05 (5 nm). Tools TL-04 (7 nm) and TL-06 (10 nm) are eliminated.

Only tools operating at 3 nm or 5 nm satisfy the condition of being 5 nm or smaller.

3

Apply the second criterion (Defect Density

< 0.30\text{ defects/cm}^2

) to the candidate tools.

Qualifying subset: TL-01 (

0.24

), TL-02 (

0.18

), and TL-05 (

0.28

). TL-03 is excluded because

0.32 \ge 0.30

.

Strict inequality requires excluding values equal to or greater than 0.30.

4

Extract operational uptime values for the qualified subset and compute the median.

Values: TL-05 (

94.6\%

), TL-01 (

95.8\%

), TL-02 (

96.4\%

). Ordered values:

94.6\%, 95.8\%, 96.4\%

. Median =

95.8\%

.

For

N = 3

, the median is the 2nd value in sorted order.

5

Compare the calculated median against the target threshold.

95.8\% > 95.0\%

, verifying that the statement is True.

The calculated median of

95.8\%

strictly exceeds the benchmark value of

95.0\%

.

Key Concept

Compound Conditional Filtering and Descriptive Statistics on Subsets

Estimated Time:2m 0s

Question 15Question →

The table below provides operational data for eight solar power facilities across two regions:

Facility Name	Region	Capacity (MW)	Operational Efficiency (%)
Solaria Alpha	North	120	88
Solaria Beta	South	150	91
Solaria Gamma	North	200	97
Solaria Delta	North	110	82
Solaria Epsilon	South	180	89
Solaria Zeta	North	135	92
Solaria Eta	North	160	94
Solaria Theta	North	140	85

What is the median operational efficiency, in percent, of the solar power facilities located in the North region?

Show answer & explanation

Answer: 90

Answer

The median operational efficiency of the solar power facilities in the North region is 90%.

Filtering the table for facilities in the North region yields six efficiency values: 82%, 85%, 88%, 92%, 94%, and 97%. Because the dataset contains an even count of six values, the median is the average of the two middle values (88% and 92%). Calculating

\frac{88 + 92}{2}

gives 90%.

Step-by-Step Solution

1

Filter the table to isolate facilities in the North region.

Identified 6 facilities with operational efficiency values: 88%, 97%, 82%, 92%, 94%, and 85%.

The stem specifies evaluating descriptive statistics for the North region subset only.

2

Sort the efficiency values of the filtered subset in ascending order.

Ordered set: {82, 85, 88, 92, 94, 97}.

Calculating the median requires ordering data points from lowest to highest.

3

Compute the arithmetic mean of the two central terms in the 6-element dataset.

\frac{88 + 92}{2} = 90

.

For an even-count set of

N = 6

items, the median is defined as the average of the

\frac{N}{2}

-th (3rd) and

(\frac{N}{2} + 1)

-th (4th) terms.

Key Concept

Descriptive Statistics Interpretation (Median of Even-Count Subsets)

Question 16Question →

The table below details the quarterly electricity consumption (in kWh) for six regional branches of a commercial enterprise:

Branch	Region	Q1 (kWh)	Q2 (kWh)	Q3 (kWh)	Q4 (kWh)
Alpha	North	12,000	14,000	15,000	11,000
Beta	South	18,000	16,000	17,000	19,000
Gamma	North	9,000	10,000	11,000	10,000
Delta	East	22,000	25,000	24,000	21,000
Epsilon	West	15,000	15,000	16,000	14,000
Zeta	South	11,000	13,000	12,000	12,000

Based on the table, evaluate the following statement:
"The median Q1 electricity consumption of branches in the North region is greater than the median Q1 electricity consumption of branches in the South region."

Is this statement True or False?

True

False

Show answer & explanation

Answer: False

Answer

The statement is False. The median Q1 electricity consumption for branches in the North region (

10,500\text{ kWh}

) is less than the median Q1 electricity consumption for branches in the South region (

14,500\text{ kWh}

).

The evaluation shows that the median Q1 value for the North region (

10,500\text{ kWh}

) is strictly less than the median Q1 value for the South region (

14,500\text{ kWh}

). Therefore, the assertion that North is greater than South evaluates to False.

Step-by-Step Solution

1

Identify Q1 consumption figures for branches in the North region and calculate their median.

Branches in the North region are Alpha (

12,000\text{ kWh}

) and Gamma (

9,000\text{ kWh}

). The median is

\frac{12,000 + 9,000}{2} = 10,500\text{ kWh}

.

Filtering rows by the condition 'Region = North' isolates the correct values for statistical evaluation.

2

Identify Q1 consumption figures for branches in the South region and calculate their median.

Branches in the South region are Beta (

18,000\text{ kWh}

) and Zeta (

11,000\text{ kWh}

). The median is

\frac{18,000 + 11,000}{2} = 14,500\text{ kWh}

.

Filtering rows by the condition 'Region = South' isolates the comparison dataset.

3

Compare the two median values to evaluate the boolean statement.

Comparing

10,500\text{ kWh}

to

14,500\text{ kWh}

shows that

10,500 < 14,500

, making the statement false.

The statement claims North is greater than South, which contradicts the calculated result.

Key Concept

Filtered subset descriptive statistics comparison

Estimated Time:1m 0s

Question 17Question →

The table below presents technical specifications and operational parameters for seven Earth-observation satellites in a commercial constellation:

Satellite ID	Operational Status	Orbital Altitude (km)	Sensor Resolution (m)	Downlink Speed (Gbps)
Sat-01	Active	420	0.4	10
Sat-02	Active	580	1.1	20
Sat-03	Active	640	0.5	16
Sat-04	Active	490	0.9	12
Sat-05	Standby	510	0.6	18
Sat-06	Active	550	0.5	14
Sat-07	Active	450	1.5	8

What is the average (arithmetic mean) Downlink Speed, in Gbps, of all satellites that are currently Active, have an Orbital Altitude of at most 600 km, and satisfy AT LEAST ONE of the following criteria: a Sensor Resolution of less than 0.8 m OR a Downlink Speed of at least 15 Gbps?

12.00

12.80

14.67

15.00

15.50

Show answer & explanation

Answer: 14.67

Answer

14.67 Gbps

The correct response identifies the three satellites (Sat-01, Sat-02, and Sat-06) that satisfy all mandatory criteria (Active status and altitude

\leq 600

km) as well as at least one of the secondary criteria (resolution

< 0.8

m or downlink

\geq 15

Gbps). Their downlink speeds are 10, 20, and 14 Gbps respectively, yielding an arithmetic mean of

\frac{10 + 20 + 14}{3} = 14.67

Gbps.

Step-by-Step Solution

1

Evaluate mandatory conditions (Operational Status = Active AND Orbital Altitude

\leq 600

km).

Satellites meeting these two conditions are Sat-01 (420 km), Sat-02 (580 km), Sat-04 (490 km), Sat-06 (550 km), and Sat-07 (450 km). Sat-03 is excluded due to altitude (640 km

> 600

km), and Sat-05 is excluded due to status (Standby).

Conjunctive criteria require all mandatory parameters to be met simultaneously.

2

Evaluate the disjunctive condition (Sensor Resolution

< 0.8

m OR Downlink Speed

\geq 15

Gbps) among the candidate satellites.

- Sat-01: Resolution

= 0.4

m (

< 0.8

)

\rightarrow

QUALIFIES
- Sat-02: Downlink

= 20

Gbps (

\geq 15

)

\rightarrow

QUALIFIES
- Sat-04: Resolution

= 0.9

m and Downlink

= 12

Gbps

\rightarrow

FAILS
- Sat-06: Resolution

= 0.5

m (

< 0.8

)

\rightarrow

QUALIFIES
- Sat-07: Resolution

= 1.5

m and Downlink

= 8

Gbps

\rightarrow

FAILS

An OR condition requires a candidate to satisfy at least one of the sub-criteria.

3

Calculate the arithmetic mean Downlink Speed for the qualifying satellites (Sat-01, Sat-02, Sat-06).

Sum of downlink speeds =

10 + 20 + 14 = 44

Gbps.
Mean =

\frac{44}{3} \approx 14.67

Gbps.

The mean is the total sum of downlink speeds divided by the count of filtered rows.

Key Concept

Multi-column compound filtering combining conjunctive AND and disjunctive OR conditions prior to aggregation.

Estimated Time:2m 30s

Question 18Question →

The table below shows logistics performance data for six regional warehouses during the third quarter:

Warehouse	Region	Total Shipments	On-Time Delivery Rate	Avg. Processing Time (Hours)
Alpha	East	12,000	94%	14.5
Beta	West	8,500	96%	12.0
Gamma	East	15,200	91%	16.0
Delta	South	9,100	98%	10.5
Epsilon	West	11,400	95%	13.0
Zeta	South	14,000	93%	15.0

Match each statement on the left with its correct evaluation outcome on the right based on the table.

Click a left item, then click its matching right item

Show answer & explanation

Answer

Statement I matches with True (West region average is 12.5 hours); Statement II matches with True (Gamma has highest shipments and lowest delivery rate); Statement III matches with False (3 out of 6 is exactly half, not more than half).

Each statement is evaluated against the data in the table: Statement I evaluates to True because the average for West warehouses (12.0 and 13.0) is 12.5 hours. Statement II evaluates to True because Gamma holds both the maximum shipment volume (15,200) and minimum delivery rate (91%). Statement III evaluates to False because exactly 3 out of 6 warehouses (50%) have delivery rates above 94%, which does not exceed half.

Step-by-Step Solution

1

Evaluate Statement I by filtering by Region = West.

Beta (12.0 hrs) and Epsilon (13.0 hrs) are in the West. Average = (12.0 + 13.0) / 2 = 12.5 hours. 12.5 < 13.0 is True.

Calculate the mean value of processing time for the specified subset.

2

Evaluate Statement II by identifying the maximum shipment count and minimum delivery rate.

Maximum shipments = 15,200 (Gamma). Minimum delivery rate = 91% (Gamma). The condition holds True.

Determine if both extreme statistical properties apply to the same entity.

3

Evaluate Statement III by filtering for delivery rates > 94%.

Beta (96%), Delta (98%), and Epsilon (95%) qualify (3 warehouses). 3 out of 6 equals 50%, which is not > 50%. The statement is False.

Compare the count of matching rows against the threshold 'more than half' (strictly greater than 50%).

Key Concept

Multi-Statement Boolean Evaluation on Tabular Data

Question 19Question →

The table below displays performance metrics for six regional branch offices of a retail company.

Branch	Region	Customer Satisfaction Score (1–10)	Q3 Revenue ($ thousands)	Q4 Revenue ($ thousands)
North	East	8.2	450	510
South	West	9.1	380	420
Metro	East	8.2	520	490
Summit	North	7.5	610	580
Valley	West	8.8	490	530
Harbor	North	9.1	410	460

If the table is sorted in descending order by Customer Satisfaction Score, and any ties are broken by sorting in descending order by Q3 Revenue ($ thousands), which branch office will be listed third from the top?

Harbor

South

Valley

Metro

Summit

Show answer & explanation

Answer: Valley

Answer

Valley is listed third from the top after performing the specified primary and secondary sorts.

Sorting the branches by Customer Satisfaction Score in descending order groups Harbor and South at the top with scores of 9.1. Ordering them by Q3 Revenue places Harbor first (

410 thousand) and South second (

380 thousand). The next highest satisfaction score is 8.8, held by Valley, placing Valley third from the top.

Step-by-Step Solution

1

Identify the primary sort criterion and group branches by Customer Satisfaction Score in descending order.

Highest scores (9.1): Harbor, South. Next highest (8.8): Valley. Next highest (8.2): North, Metro. Lowest score (7.5): Summit.

The primary sort requires ordering by Customer Satisfaction Score from highest to lowest.

2

Apply the tie-breaker criterion (Q3 Revenue in descending order) to branches tied at a score of 9.1.

Harbor (

410 thousand) comes before South (

380 thousand). Rank 1: Harbor, Rank 2: South.

Ties in Customer Satisfaction Score must be broken by sorting Q3 Revenue in descending order.

3

Determine the branch in the 3rd position.

Valley has the next highest score of 8.8, placing it in Rank 3.

Since only two branches have a score of 9.1, the branch with the next highest score (8.8) occupies the 3rd row.

Key Concept

Multi-column sorting requires applying the primary sort column first, followed by secondary tie-breaking logic on secondary columns without reading positions from default unsorted rows.

Question 20Question →

The table below provides financial performance metrics for five corporate divisions of Vertex Global:

Division	Revenue ($M)	Operating Cost ($M)	Profit Margin (%)	Employees
Alpha	120	90	25.0%	450
Beta	200	170	15.0%	800
Gamma	80	50	37.5%	250
Delta	150	105	30.0%	500
Epsilon	300	270	10.0%	1,200

Evaluate the following statement as True or False based on the provided table:

Statement: For more than half of the divisions listed, the Revenue per employee strictly exceeds $250,000.

True

False

Show answer & explanation

Answer: True

Answer

True. Exactly 3 out of the 5 divisions (Alpha, Gamma, and Delta) have a Revenue per employee greater than $250,000, which satisfies the condition of being more than half.

The correct evaluation is True because calculating the ratio of Revenue to Employees for each of the five divisions shows that Alpha (

266,667), Gamma (

320,000), and Delta (

300,000) all have a Revenue per employee above

250,000. Three out of five divisions represents 60% of the divisions, which is more than half.

Step-by-Step Solution

1

Understand the condition and metric required

Need to calculate Revenue per employee (Revenue in dollars divided by number of employees) for each division and check if it is strictly greater than $250,000.

The statement specifies 'strictly exceeds $250,000' and applies to 'more than half' (at least 3 out of 5) of the divisions.

2

Compute Revenue per employee for each division

Alpha:

120M / 450 =

266,667; Beta:

200M / 800 =

250,000; Gamma:

80M / 250 =

320,000; Delta:

150M / 500 =

300,000; Epsilon:

300M / 1,200 =

250,000.

Performing explicit division allows precise comparison against the threshold value of $250,000.

3

Evaluate the threshold condition across all divisions

Divisions exceeding

250,000: Alpha, Gamma, Delta (Total = 3 divisions). Divisions equal to

250,000: Beta, Epsilon (Total = 2 divisions).

Values exactly equal to $250,000 do not satisfy 'strictly exceeds'.

4

Determine overall Boolean truth value

3 out of 5 divisions is 60%, which is more than half (50%). Thus, the statement evaluates to True.

Comparing the count of meeting divisions (3) against half of the dataset size (2.5).

Key Concept

Table Analysis & Boolean Statement Evaluation

Table Analysis

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Answer

Step-by-Step Solution

Key Concept