GMAT - Graduate Management Admission Data Insights: Table Analysis Questions and Answers

Question 1

The table below shows quarterly revenue for four product lines at a technology company. Which product line experienced the greatest percentage increase in revenue from Q1 to Q2?

| Product Line | Q1 Revenue ($M) | Q2 Revenue ($M) |
|---|---|---|
| Software | 4.0 | 5.0 |
| Hardware | 10.0 | 12.0 |
| Services | 2.0 | 2.8 |
| Cloud | 5.0 | 6.0 |

Accepted Answer

Services

Answer

To determine the greatest percentage increase, calculate the percent change for each product line using the formula: ((Q2 Revenue - Q1 Revenue) / Q1 Revenue) * 100.
- Software: ((5.0 - 4.0) / 4.0) * 100 = (1.0 / 4.0) * 100 = 25%.
- Hardware: ((12.0 - 10.0) / 10.0) * 100 = (2.0 / 10.0) * 100 = 20%.
- Services: ((2.8 - 2.0) / 2.0) * 100 = (0.8 / 2.0) * 100 = 40%.
- Cloud: ((6.0 - 5.0) / 5.0) * 100 = (1.0 / 5.0) * 100 = 20%.
The 'Services' product line had the highest percentage increase at 40%.

Question 2

The table displays data for several employees at a company. What is the average annual salary for employees in the Marketing department who have a performance rating of 4 or higher?

| Employee ID | Department | Years of Service | Performance Rating (1-5) | Annual Salary ($) |
|---|---|---|---|---|
| E201 | Sales | 5 | 4 | 75,000 |
| E202 | Marketing | 8 | 3 | 68,000 |
| E203 | Sales | 12 | 5 | 95,000 |
| E204 | Marketing | 3 | 4 | 82,000 |
| E205 | Sales | 2 | 3 | 60,000 |
| E206 | Marketing | 10 | 5 | 88,000 |
| E207 | Engineering | 7 | 4 | 90,000 |

Accepted Answer

85,000

Answer

First, identify the employees who meet both criteria: they must be in the 'Marketing' department AND have a performance rating of 4 or 5. The employees who fit this description are E204 (Rating 4, Salary $82,000) and E206 (Rating 5, Salary $88,000). To find the average salary, sum their salaries and divide by the number of employees (2). Average = ($82,000 + $88,000) / 2 = $170,000 / 2 = $85,000.

Question 3

The table below shows agricultural output for four regions. What is the ratio of the total wheat output from the North and West regions combined to the total corn output from the South and East regions combined?

| Region | Wheat (millions of tons) | Corn (millions of tons) | Soybeans (millions of tons) |
|---|---|---|---|
| North | 150 | 350 | 210 |
| South | 40 | 180 | 250 |
| East | 60 | 220 | 150 |
| West | 250 | 90 | 80 |

Accepted Answer

1:1

Answer

First, calculate the combined wheat output for the North and West regions: 150 + 250 = 400 million tons. Next, calculate the combined corn output for the South and East regions: 180 + 220 = 400 million tons. The ratio of the combined wheat output to the combined corn output is 400:400, which simplifies to 1:1.

Question 4

The unsorted table below lists the final exam scores for a class of 9 students. What is the median score for the class?

| Student | Score |
|---|---|
| Amy | 88 |
| Ben | 72 |
| Chloe | 95 |
| David | 68 |
| Eva | 85 |
| Frank | 79 |
| Grace | 91 |
| Henry | 72 |
| Ian | 82 |

Accepted Answer

82

Answer

To find the median, the data must first be sorted in ascending order. The sorted scores are: 68, 72, 72, 79, 82, 85, 88, 91, 95. In a set with an odd number of values (9 in this case), the median is the middle value. The middle value is the (n+1)/2 term, which is the (9+1)/2 = 5th term. The 5th score in the sorted list is 82.

Question 5

A company is selecting a new shipping partner based on the data in the table. A manager states, 'Partner B has consistently improved its on-time delivery rate each year.' Based on the data, is the manager's statement accurate?

| Partner | 2021 On-Time Rate | 2022 On-Time Rate | 2023 On-Time Rate | 2024 On-Time Rate |
|---|---|---|---|---|
| A | 92.1% | 93.5% | 93.8% | 94.2% |
| B | 95.5% | 96.2% | 96.0% | 96.8% |
| C | 94.8% | 94.6% | 95.1% | 95.3% |
| D | 93.0% | 94.5% | 95.5% | 96.5% |

Accepted Answer

No, because the rate decreased between 2022 and 2023.

Answer

The manager's statement claims that Partner B 'consistently improved' its rate 'each year'. To verify this, we must check the year-over-year change. From 2021 to 2022, the rate increased (95.5% to 96.2%). However, from 2022 to 2023, the rate decreased (96.2% to 96.0%). Because there was a decrease in one of the periods, the improvement was not consistent each year. Therefore, the statement is not accurate.

GMAT Practice Test

GMAT Practice Test

GMAT - Graduate Management Admission Data Insights: Table Analysis Questions and Answers