PSEE Data Interpretation and Tables 2 — Questions and Answers
Question 1: A table shows employee absences by month. If the total for the year is 360 absences and January had 45, what percentage of annual absences occurred in January?
- 10%
- 12.5% (Correct answer)
- 15%
- 18%
Correct answer: 12.5%
45 / 360 × 100 = 12.5% of annual absences occurred in January.
Question 2: Agency expenditures are: Personnel $2.4M, Operations $1.6M, Equipment $0.8M, Other $0.2M. What fraction of total expenditures goes to personnel?
- 48% (Correct answer)
- 50%
- 52%
- 60%
Correct answer: 48%
Total = $5.0M; Personnel = $2.4M; $2.4M / $5.0M × 100 = 48% of expenditures go to personnel.
Question 3: A line graph shows service delivery times decreasing from 14 days in 2023 to 11 days in 2024 to 8 days in 2025. If the trend continues, what would the delivery time be in 2026?
- 3 days
- 5 days (Correct answer)
- 6 days
- 7 days
Correct answer: 5 days
The delivery time decreases by 3 days each year; 8 − 3 = 5 days projected for 2026.
Question 4: A department has a staff of 80. If 15% are on leave today, how many staff members are present?
- 12
- 56
- 64
- 68 (Correct answer)
Correct answer: 68
15% of 80 = 12 on leave; present staff = 80 − 12 = 68 employees.
Question 5: A table shows four agencies' processing times (in days): Agency A=12, Agency B=9, Agency C=15, Agency D=6. What is the median processing time?
- 9 days
- 10.5 days (Correct answer)
- 11 days
- 12 days
Correct answer: 10.5 days
Arranged in order: 6, 9, 12, 15; median of 4 values = (9 + 12) / 2 = 10.5 days.
Question 6: Government revenue this year is $5.4 billion. If revenue grew by 8% from last year, what was last year's revenue (rounded to the nearest tenth of a billion)?
- $4.9 billion
- $5.0 billion (Correct answer)
- $5.1 billion
- $5.2 billion
Correct answer: $5.0 billion
Last year's revenue = $5.4B ÷ 1.08 = $5.0 billion (rounded to the nearest tenth).
PSEE Data Interpretation and Tables 2
A table shows employee absences by month.
If the total for the year is 360 absences and January had 45, what percentage of annual absences occurred in January?