GMAT - Graduate Management Admission Data Insights: Table Analysis Questions and Answers 1 — 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 |
- Software
- Hardware
- Services (Correct answer)
- Cloud
Correct answer: Services
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 |
- 79,333
- 85,000 (Correct answer)
- 82,000
- 86,000
Correct answer: 85,000
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 |
- 4:1
- 1:1 (Correct answer)
- 2:3
- 3:2
Correct answer: 1:1
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 |
- 85
- 82 (Correct answer)
- 81.3
- 72
Correct answer: 82
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% |
- Yes, because its rate in 2024 was higher than in 2021.
- Yes, because its average rate of improvement is positive.
- No, because the rate decreased between 2022 and 2023. (Correct answer)
- No, because Partner D had a higher overall rate of improvement.
Correct answer: No, because the rate decreased between 2022 and 2023.
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.
Question 6: The table shows features for several streaming service plans. A customer needs a plan that allows for at least 3 simultaneous screens and offers content in 4K resolution. What is the minimum monthly cost for a plan that meets these criteria? | Plan Name | Monthly Cost ($) | Max Screens | Max Resolution | Offline Downloads | |---|---|---|---|---| | Basic | 9.99 | 1 | HD | Yes | | Standard | 14.99 | 2 | HD | Yes | | Family | 18.99 | 4 | HD | Yes | | Plus | 22.99 | 3 | 4K | Yes | | Premium | 27.99 | 5 | 4K | Yes |
- 14.99
- 18.99
- 22.99 (Correct answer)
- 27.99
Correct answer: 22.99
The customer has two requirements: at least 3 simultaneous screens and 4K resolution. We must filter the table to find plans that meet both conditions. 1. **Screens >= 3**: This eliminates 'Basic' (1 screen) and 'Standard' (2 screens). The remaining plans are 'Family', 'Plus', and 'Premium'. 2. **Resolution = 4K**: From the remaining plans, we filter for 4K resolution. This eliminates 'Family' (HD). The plans that meet both criteria are 'Plus' and 'Premium'. Finally, the question asks for the minimum monthly cost among these valid options. The cost for 'Plus' is $22.99 and for 'Premium' is $27.99. The minimum cost is $22.99.
GMAT - Graduate Management Admission Data Insights: Table Analysis Questions and Answers 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 |