Study guide
5.3 Multi-Source Data Synthesis & Cross-Referencing
Irish Public Service Numerical Reasoning Test Study Guide Exam
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Test Overview, Structure & Assessment Strategies
1.1 Test Overview, Structure & Administration 1.2 Pacing, Time Management & Exam Strategies 1.3 Assessment Interfaces, Tabbed Layouts & 'Cannot Say' Logic
2 Chapter 2: Core Arithmetic, Fractions & Decimals
2.1 Order of Operations & Mental Arithmetic Techniques 2.2 Fractions & Rational Numbers in Public Administration 2.3 Decimals, Rounding & Unit Conversions
3 Chapter 3: Percentages, Ratios & Proportions
3.1 Percentage Calculation & Base Identification 3.2 Percentage Change, Reverse Percentages & Multipliers 3.3 Ratios, Partitioning & Proportional Allocation 3.4 Rates, Staffing Metrics & Weighted Averages
4 Chapter 4: Statistical Tables & Bar Charts
4.1 Tabular Data Interpretation & Footnote Traps 4.2 Bar Charts, Clustered Bars & Segmented Stacks 4.3 Histograms & Frequency Distributions in Civil Service Reporting
5 Chapter 5: Line Graphs, Pie Charts & Multi-Source Synthesis
5.1 Line Graphs, Time Series & Trend Analysis 5.2 Pie Charts & Proportional Sector Expenditure 5.3 Multi-Source Data Synthesis & Cross-Referencing
6 Chapter 6: Financial Computations & Public Expenditure
6.1 Public Sector Budgeting, Allocation & Variance Analysis 6.2 Unit Costing, Service Delivery & Economies of Scale 6.3 Taxation, VAT & Net-to-Gross Calculations 6.4 Inflation, Indexation & Real vs Nominal Values
7 Chapter 7: Numerical Series, Sequences & Rapid Estimation
7.1 Arithmetic, Geometric & Two-Stage Number Sequences 7.2 Interleaved, Fibonacci & Pattern Recognition Series 7.3 High-Speed Estimation, Rounding & Order-of-Magnitude Filtering 7.4 Distractor Analysis, Unit Verification & Sanity Checking
5.3 Multi-Source Data Synthesis & Cross-Referencing
Key Takeaways Explain This Topic AI
Multi-source psychometric tasks require candidates to identify the common 'pivot' variable linking separate tables, charts, and exhibits.
Check whether every essential input is supplied or derivable. In an information-sufficiency task, choose Cannot Say only when the evidence establishes neither the assertion nor its contradiction.
Intermediate calculations should retain full decimal precision until the final result to prevent rounding drift across multi-step formulas.
Footnotes, asterisks, and date stamps define the boundary conditions of each data exhibit and must be checked before cross-referencing values.
In the worked exercises, check whether an alternative answer stops at an intermediate total instead of the requested cross-source result.
Last updated: October 2026
Multi-Source Reasoning in Modern Psychometric Testing
This section provides hypothetical multi-exhibit practice: one table gives staffing, another gives costs and a third gives outputs. Combine them only because the exercise explicitly requires it. This does not describe Aon’s published numerical statement format, in which each statement relates to one data sheet. Follow your own competition’s source and navigation instructions.
For a multi-source task, identify the target quantity, the linking variables and whether the exhibits use compatible definitions, periods and units. An omitted number may be derivable elsewhere; a genuinely missing essential input limits what can be concluded.
The Linking Variable Architecture (The "Pivot")
Cross-referencing multiple data exhibits relies on locating a linking variable (or pivot). This common metric appears in two or more separate exhibits, providing the bridge necessary to combine independent datasets. [ Tab 1: Staffing ] [ Tab 2: Unit Cost ] [ Tab 3: Outputs ]
- Region -> Staff (FTE) --> FTE -> Cost per FTE --> Region -> Cases Solved
- \________________________/ /
- | /
- Total Regional Budget (€) /
- \___________________________________/
- |
- Cost per Solved Case (€)
- Mathematical Formulation of Multi-Source Synthesis
Suppose an assessment requires calculating the operational cost per successful environmental inspection in a regional office:
Exhibit 1 provides annual-average Staffing ( S S S ) in Full-Time Equivalents (FTE).
Exhibit 2 provides full-year Average Cost per FTE ( C FTE C_{\text{FTE}} C FTE ), covering all operating costs in this exercise.
Exhibit 3 provides Total Inspections Completed ( I I I ) and the compliant fraction ( R R R , expressed as a decimal). There is one initial inspection per distinct facility in this exercise.
The synthesized formula chains these parameters into a unified equation: Cost per Compliant Inspection = Total Operational Cost Compliant Inspections = S × C FTE I × R \text{Cost per Compliant Inspection} = \frac{\text{Total Operational Cost}}{\text{Compliant Inspections}} = \frac{S \times C_{\text{FTE}}}{I \times R} Cost per Compliant Inspection = Compliant Inspections Total Operational Cost = I × R S × C FTE
The denominator I R I R I R must be positive for a cost per compliant inspection. Each input must be supplied or derivable on the stated basis. Do not substitute headcount for FTE without confirming their relationship, or combine partial-year cost with full-year inspections without an appropriate adjustment.
Multi-Step Walkthrough: Environmental Regulatory Authority
To master cross-referencing under exam conditions, examine this three-part administrative case study for a fictional environmental agency. Staffing is annual-average FTE; annual salary and overhead cover the costs attributed to the listed inspections:
Exhibit 1: Regional Workforce Deployment (2024)
- Regional Office Annual-Average FTE Staff Senior-Grade Share of FTE
- Dublin HQ 120 25.0%
- Cork 60 20.0%
- Galway 40 15.0%
- Limerick 30 10.0%
- Exhibit 2: Operational Cost Schedule per FTE (2024)
- Regional Office Base Salary per FTE (€) Operating Overhead per FTE (€) Total Cost per FTE (€)
- Dublin HQ €65,000 €15,000 €80,000
- Cork €60,000 €12,000 €72,000
- Galway €58,000 €10,000 €68,000
- Limerick €55,000 €9,000 €64,000
- Exhibit 3: Inspection Performance & Compliance Audit (2024)
- Regional Office Total Environmental Inspections Compliance Rate (%)
- Dublin HQ 4,800 90.0%
- Cork 2,160 85.0%
- Galway 1,360 75.0%
- Limerick 960 80.0%
Footnote on Exhibit 3: 'Compliance Rate represents the percentage of inspected facilities meeting the exercise’s stated compliance criteria on their single initial inspection. Each inspection covers a distinct facility.'
- Executing Synthesis Scenarios
- Scenario A: Productivity Benchmarking (Inspections per FTE)
Compare staff efficiency between Dublin and Galway:
Dublin productivity: 4,800 inspections 120 FTE = 40.0 inspections per FTE \frac{4{,}800 \text{ inspections}}{120 \text{ FTE}} = 40.0 \text{ inspections per FTE} 120 FTE 4 , 800 inspections = 40.0 inspections per FTE
Galway productivity: 1,360 inspections 40 FTE = 34.0 inspections per FTE \frac{1{,}360 \text{ inspections}}{40 \text{ FTE}} = 34.0 \text{ inspections per FTE} 40 FTE 1 , 360 inspections = 34.0 inspections per FTE
Evaluation: Dublin staff achieved 40.0 − 34.0 = 6.0 40.0 - 34.0 = 6.0 40.0 − 34.0 = 6.0 more inspections per FTE than Galway staff (+17.65% relative productivity advantage).
Scenario B: Total Operational Cost per Inspection
Compare the gross cost per completed inspection between Cork and Dublin:
Dublin: Total cost = 120 × EUR 80,000 = EUR 9,600,000 120 \times \text{EUR }80{,}000 = \text{EUR }9{,}600{,}000 120 × EUR 80 , 000 = EUR 9 , 600 , 000 . Cost per Inspection = EUR 9,600,000 4,800 = EUR 2,000.00 \text{Cost per Inspection} = \frac{\text{EUR }9{,}600{,}000}{4{,}800} = \text{EUR }2{,}000.00 Cost per Inspection = 4 , 800 EUR 9 , 600 , 000 = EUR 2 , 000.00
Cork: Total cost = 60 × EUR 72,000 = EUR 4,320,000 60 \times \text{EUR }72{,}000 = \text{EUR }4{,}320{,}000 60 × EUR 72 , 000 = EUR 4 , 320 , 000 . Cost per Inspection = EUR 4,320,000 2,160 = EUR 2,000.00 \text{Cost per Inspection} = \frac{\text{EUR }4{,}320{,}000}{2{,}160} = \text{EUR }2{,}000.00 Cost per Inspection = 2 , 160 EUR 4 , 320 , 000 = EUR 2 , 000.00
Evaluation: Despite differences in scale, salaries, and total volume, both offices operate at an identical cost of €2,000 per inspection.
Scenario C: Cost per Compliant Facility
Calculate the expenditure in Limerick per compliant outcome achieved:
Limerick total cost: 30 × EUR 64,000 = EUR 1,920,000 30 \times \text{EUR }64{,}000 = \text{EUR }1{,}920{,}000 30 × EUR 64 , 000 = EUR 1 , 920 , 000 .
Limerick compliant inspections: 960 × 0.80 = 768 960 \times 0.80 = 768 960 × 0.80 = 768 .
Unit cost per compliant outcome: EUR 1,920,000 768 = EUR 2,500.00 \frac{\text{EUR }1{,}920{,}000}{768} = \text{EUR }2{,}500.00 768 EUR 1 , 920 , 000 = EUR 2 , 500.00 .
Data Sufficiency & The "Cannot Say" Protocol
In an information-sufficiency exercise, use "Cannot Say" when the available evidence establishes neither the assertion nor its contradiction. A missing input may sometimes be derived or bounded; do not stop at the first blank field.
Sufficiency Checks Before Deciding
Sub-Category Distributions: To calculate expenditure by repair type, check for type counts or enough information to derive them. Distinct costs with an unknown, non-derivable mix leave a positive repair total insufficient to determine exact expenditure; quiz 2 applies this case.
Unaligned Time Horizons: Exhibit 1 reports data for Calendar Year 2024, whereas Exhibit 2 reports data for Fiscal/Tax Year 2024/2025. Without compatible component data or a justified bridging convention, a like-period comparison cannot be made.
Mismatched Population Denominators: Headcount (actual physical persons) versus Full-Time Equivalents (FTEs adjusted for part-time work). Do not multiply headcount by an FTE-calibrated cost unless their relationship supports that substitution.
Unjustified Causal Inference: Assuming that a regional disparity in performance is driven by an unmeasured variable (such as staff experience or IT systems) when no data supports it.
Important
Before calculating, verify that each variable has a consistent definition across exhibits, the periods match and the units combine correctly. Different variables need not have identical units: euros divided by inspections should produce euros per inspection.
Multi-Source Synthesis Framework
Synthesis Challenge Required Exhibits Linking Variable Verification & Sufficiency Check Typical Psychometric Trap
Cross-Tab Unit Cost Staff Table + Cost Schedule FTE Count ( S S S ) Confirm whether cost schedule is per FTE or per Headcount Applying base salary while ignoring operating overheads
Regional Output Efficiency Staff Table + Performance Audit Staff Count ( S S S ) Ensure inspection period aligns with staffing year Comparing raw inspection counts without standardizing per FTE
Quality-Adjusted Cost Cost Schedule + Audit Table Total Regional Spend ( C tot C_{\text{tot}} C tot ) Confirm whether compliance rate applies to all inspections Dividing total cost by raw inspections instead of compliant outcomes
Missing Link Evaluation Demographic Table + Budget Table Missing per-capita rate Check if population and expenditure share an empirical link Forcing a national average onto a heterogeneous local authority
Multi-Period Payroll Shift Headcount Shifts + Salary Revisions Baseline Payroll ( P 0 P_0 P 0 ) Calculate compounding effects on both headcount and pay Adding percentage wage increase to percentage headcount change
Tip
In multi-tab interfaces, read the question first and identify the target variable. Search the tabs specifically for that variable and its immediate linking parent, rather than reading every tab exhaustively from left to right.