Mettl Data Interpretation 5 — Questions and Answers
Question 1: A table shows 4 salespeople's quarterly revenue: Alice=$180K, Bob=$220K, Carol=$195K, Dave=$205K. The team target is $850K. By how much did the team exceed or miss the target?
- Missed by $50K
- Exceeded by $50K (Correct answer)
- Exactly met the target
- Missed by $100K
Correct answer: Exceeded by $50K
Total = $180K+$220K+$195K+$205K = $800K; $800K vs $850K target = missed by $50K.
Question 2: An area chart shows cumulative revenue over 12 months ending at $1.2M. The chart shows that 50% of annual revenue was reached by month 8. What was average monthly revenue in months 1-8?
- $60K
- $70K
- $75K (Correct answer)
- $80K
Correct answer: $75K
50% of $1.2M = $600K over 8 months; $600K / 8 = $75K per month.
Question 3: A table compares two products on 5 criteria (each scored 1-10): Product A scores: 8,7,6,9,5 and Product B scores: 6,8,7,8,9. Which product has the higher total score?
- Product A with 35
- Product B with 38 (Correct answer)
- Both score 37
- Product A with 38
Correct answer: Product B with 38
A = 8+7+6+9+5 = 35; B = 6+8+7+8+9 = 38; Product B scores higher.
Question 4: A bar chart shows inventory turnover ratios by product category: Electronics=8x, Clothing=12x, Food=52x, Furniture=4x. Which category holds inventory for the longest average period?
- Electronics
- Clothing
- Food
- Furniture (Correct answer)
Correct answer: Furniture
A lower turnover ratio means inventory sits longer; Furniture at 4x turns over least frequently.
Question 5: A data table shows that Customer Acquisition Cost (CAC) rose from $120 to $150 while Customer Lifetime Value (LTV) rose from $480 to $525. Which metric improved most in percentage terms?
- CAC improved more
- LTV improved more
- Both improved by the same percentage
- CAC worsened while LTV improved (Correct answer)
Correct answer: CAC worsened while LTV improved
CAC rose 25% (unfavorable increase in cost); LTV rose 9.375% (favorable) — CAC worsened, LTV improved.
Question 6: A table shows 5 test scores: 72, 85, 91, 68, 79. After removing the lowest score, what happens to the average?
- The average decreases
- The average stays the same
- The average increases (Correct answer)
- Cannot be determined
Correct answer: The average increases
Removing 68 (below the mean of 79) raises the average of the remaining four values.
Question 7: A Gantt chart shows 3 tasks: Task A runs weeks 1-4, Task B runs weeks 3-7, Task C runs weeks 6-9. What is the total project duration assuming they must complete sequentially?
- 9 weeks (Correct answer)
- 10 weeks
- 11 weeks
- 12 weeks
Correct answer: 9 weeks
If tasks overlap on a Gantt chart, the project ends when the last task ends — week 9.
A table shows 4 salespeople's quarterly revenue: Alice=$180K, Bob=$220K, Carol=$195K, Dave=$205K.
The team target is $850K.
By how much did the team exceed or miss the target?