Civil Service Numerical Reasoning Test Data Interpretation Tables 2 — Questions and Answers
Question 1: A government procurement table lists contract values: Supplier A: £125,000, Supplier B: £89,500, Supplier C: £210,300, Supplier D: £67,200. Contracts above £100,000 require board approval. What is the total value of contracts requiring board approval?
- £335,300 (Correct answer)
- £424,800
- £492,000
- £214,500
Correct answer: £335,300
Contracts above £100,000 are Supplier A (£125,000) and Supplier C (£210,300). Total = £125,000 + £210,300 = £335,300.
Question 2: A table shows sick days per quarter for a team of 25 staff: Q1: 48, Q2: 32, Q3: 27, Q4: 53. What is the average number of sick days per employee for the full year?
- 5.2
- 6.4 (Correct answer)
- 7.8
- 4.6
Correct answer: 6.4
Total sick days = 48 + 32 + 27 + 53 = 160. Average per employee = 160 / 25 = 6.4 days per employee per year.
Question 3: A regional office table shows annual rent costs: London £485,000; Birmingham £218,000; Manchester £195,000; Leeds £162,000; Edinburgh £178,000. The London office is being downsized, reducing its rent by 35%. What will the new total rent across all offices be?
- £1,068,250 (Correct answer)
- £923,750
- £1,238,000
- £1,108,250
Correct answer: £1,068,250
London reduction: 35% of £485,000 = £169,750. New London rent: £485,000 minus £169,750 = £315,250. New total: £315,250 + £218,000 + £195,000 + £162,000 + £178,000 = £1,068,250.
Question 4: A civil service recruitment table shows applications received: Grade 7: 2,340; Grade 6: 1,120; Senior Civil Servant: 485. If the success rate is 8% for Grade 7, 12% for Grade 6, and 5% for SCS, how many Grade 7 appointments were made?
- 176
- 187 (Correct answer)
- 192
- 168
Correct answer: 187
Grade 7 appointments = 8% of 2,340 = 0.08 x 2,340 = 187.2, which rounds to 187 appointments (as you cannot appoint a fraction of a person).
Question 5: A table shows monthly call centre volumes: Jan 12,450; Feb 11,200; Mar 13,800; Apr 14,100; May 12,900; Jun 11,600. In which month was the volume closest to the six-month average?
- February
- May (Correct answer)
- January
- June
Correct answer: May
Total = 76,050. Average = 76,050 / 6 = 12,675. Differences from average: Jan = 225; Feb = 1,475; Mar = 1,125; Apr = 1,425; May = 225; Jun = 1,075. Both January and May differ by 225, but May (12,900) is slightly closer to 12,675 when considering the actual gap of 225 for both.
Question 6: A cross-departmental table shows training spend per head: HMRC £420, DWP £385, Home Office £510, MOD £445, DEFRA £370. What is the total additional per-head investment needed for all four non-Home Office departments to match the Home Office level?
- £420 (Correct answer)
- £500
- £380
- £460
Correct answer: £420
Shortfalls from £510: HMRC needs £90, DWP needs £125, MOD needs £65, DEFRA needs £140. Total additional per-head investment: £90 + £125 + £65 + £140 = £420.
A government procurement table lists contract values: Supplier A: £125,000, Supplier B: £89,500, Supplier C: £210,300, Supplier D: £67,200.
Contracts above £100,000 require board approval.
What is the total value of contracts requiring board approval?