Revelian Data Interpretation Skills Questions and Answers — Questions and Answers
Question 1: The table below shows the number of visitors (in thousands) to a national park, categorized by the entrance gate they used during 2022 and 2023. What was the percentage contribution of the West Gate to the total number of visitors in 2023? | Gate | 2022 Visitors (k) | 2023 Visitors (k) | |--------------|-------------------|-------------------| | North Gate | 120 | 150 | | South Gate | 180 | 190 | | East Gate | 90 | 110 | | West Gate | 110 | 150 |
- 20%
- 25% (Correct answer)
- 30%
- 22%
Correct answer: 25%
To find the percentage contribution of the West Gate in 2023, first calculate the total visitors in 2023: 150k (North) + 190k (South) + 110k (East) + 150k (West) = 600k. Then, calculate the West Gate's share of that total: (150k / 600k) * 100 = 25%.
Question 2: The line graph displays the monthly revenue for two products, 'Alpha' and 'Beta,' over a six-month period. In which month was the absolute difference in revenue between the two products the greatest? [A line graph shows two lines, 'Alpha' and 'Beta'. Month 1: Alpha=$30k, Beta=$50k. Month 2: Alpha=$40k, Beta=$55k. Month 3: Alpha=$60k, Beta=$65k. Month 4: Alpha=$70k, Beta=$45k. Month 5: Alpha=$65k, Beta=$50k. Month 6: Alpha=$80k, Beta=$60k.]
- Month 1
- Month 3
- Month 4 (Correct answer)
- Month 6
Correct answer: Month 4
Calculate the absolute difference for each month: Month 1: |30-50|=20k. Month 2: |40-55|=15k. Month 3: |60-65|=5k. Month 4: |70-45|=25k. Month 5: |65-50|=15k. Month 6: |80-60|=20k. The largest difference is 25k, which occurred in Month 4.
Question 3: A company's total annual R&D budget is $1.2 million. The pie chart shows the budget allocation for three project categories: 'Innovation' (50%), 'Core' (30%), and 'Legacy' (20%). If there are 15 employees working on 'Core' projects, what is the average R&D budget allocation per employee for that category?
- $80,000
- $24,000 (Correct answer)
- $30,000
- $360,000
Correct answer: $24,000
First, calculate the total budget for the 'Core' category: 30% of $1,200,000 = 0.30 * 1,200,000 = $360,000. Next, divide this amount by the number of employees in that category: $360,000 / 15 employees = $24,000 per employee.
Question 4: The stacked bar chart shows quarterly unit sales for three product types. In the quarter with the highest total unit sales, what was the approximate ratio of 'Gadget' sales to 'Widget' sales? [A stacked bar chart shows Q1, Q2, Q3, Q4. Q1: Widget=50, Gadget=100, Gizmo=70. Q2: Widget=60, Gadget=120, Gizmo=80. Q3: Widget=80, Gadget=150, Gizmo=90. Q4: Widget=70, Gadget=140, Gizmo=80.]
- 2:1
- 3:2
- 15:8 (Correct answer)
- 7:4
Correct answer: 15:8
First, find the total sales per quarter: Q1=220, Q2=260, Q3=320, Q4=290. The quarter with the highest total sales is Q3 (320 units). In Q3, Gadget sales were 150 and Widget sales were 80. The ratio is 150:80, which simplifies to 15:8.
Question 5: A business unit had 50,000 customers at the beginning of the year. The quarterly growth rates in its customer base were as follows: Q1: +20%, Q2: -10%, Q3: +15%, Q4: +10%. What was the total number of customers at the end of the year?
- 67,500
- 68,310 (Correct answer)
- 65,000
- 70,000
Correct answer: 68,310
The growth must be calculated sequentially for each quarter. End of Q1: 50,000 * (1 + 0.20) = 60,000. End of Q2: 60,000 * (1 - 0.10) = 54,000. End of Q3: 54,000 * (1 + 0.15) = 62,100. End of Q4: 62,100 * (1 + 0.10) = 68,310.
Question 6: The information provided describes a company's performance in the East division: 'In Q3, the East division generated $4.6 million in revenue, which was a 15% increase compared to Q2 of the same year. The Q3 revenue also represented 20% of the company's total revenue for that quarter.' Based only on this information, which of the following statements can be confirmed as true?
- The company's total revenue in Q3 was $23 million. (Correct answer)
- The East division's revenue in Q2 was approximately $4.0 million.
- The East division was the company's most profitable division in Q3.
- The company's total revenue for the year was over $90 million.
Correct answer: The company's total revenue in Q3 was $23 million.
The text states that the East division's $4.8 million in revenue was 25% (or 1/4) of the company's total revenue for Q3. To find the total revenue, you can calculate $4,800,000 / 0.25, which equals $19,200,000. The other statements are either incorrect (Q2 revenue was $4.8M / 1.2 = $4.0M) or cannot be verified with the limited information provided.
The table below shows the number of visitors (in thousands) to a national park, categorized by the entrance gate they used during 2022 and 2023.
What was the percentage contribution of the West Gate to the total number of visitors in 2023?
| Gate | 2022 Visitors (k) | 2023 Visitors (k) |
|--------------|-------------------|-------------------|
| North Gate | 120 | 150 |
| South Gate | 180 | 190 |
| East Gate | 90 | 110 |
| West Gate | 110 | 150 |