5.3 Multi-Source Data Synthesis & Cross-Referencing
Key Takeaways
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.
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 () in Full-Time Equivalents (FTE).
- Exhibit 2 provides full-year Average Cost per FTE (), covering all operating costs in this exercise.
- Exhibit 3 provides Total Inspections Completed () and the compliant fraction (, 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:
The denominator 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:
- Galway productivity:
- Evaluation: Dublin staff achieved 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 = .
- Cork: Total cost = .
- 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: .
- Limerick compliant inspections: .
- Unit cost per compliant outcome: .
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 () | 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 () | 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 () | 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 () | 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.
Using the Environmental Regulatory Authority exhibits, what was the average operational expenditure incurred by the Limerick regional office per compliant inspection achieved in 2024?
€2,000.00
€2,250.00
€2,500.00
€3,125.00
A public sector analyst evaluates a local authority housing repair initiative using three information tabs:
- Tab 1: Total social housing stock managed by each council in 2024.
- Tab 2: Total completed repairs per 100 housing units in 2024.
- Tab 3: Stipulated cost charged for each completed emergency repair (€450) and non-emergency repair (€180), applying exactly to all councils in 2024. A footnote on Tab 2 specifies: 'Completed repairs encompass both emergency and non-emergency works; the proportion of emergency repairs varies significantly across local authorities.' Local Authority B has a positive number of completed repairs. Based strictly on these exhibits, can the total monetary expenditure on housing repairs for Local Authority B be definitively calculated?
Cannot Say, because the specific proportion of emergency versus non-emergency repairs for Local Authority B is not provided.
True, because multiplying housing stock by the repair rate and the simple average of repair costs (€315) yields the exact figure.
False, because national unit cost benchmarks cannot be utilized in public sector accounting under any circumstances.
Cannot Say, because the total number of housing units managed by Local Authority B is omitted from Tab 1.
Referencing the Environmental Regulatory Authority exhibits, which statement correctly compares the Galway regional office to the Dublin HQ regarding staff inspection productivity and operational cost per inspection?
Galway staff achieved 6.0 more inspections per FTE than Dublin, with a €200.00 higher operational cost per inspection.
Galway staff achieved 4.0 fewer inspections per FTE than Dublin, with an identical operational cost of €2,000.00 per inspection.
Galway staff achieved 6.0 fewer inspections per FTE than Dublin, but operated at a €250.00 lower operational cost per inspection.
Galway staff achieved 6.0 fewer inspections per FTE than Dublin, but operated at an identical operational cost of €2,000.00 per inspection.
A regional healthcare directorate's workforce and payroll exhibits report the following across two consecutive years:
- Tab 1 (Annual-Average Staffing Headcount): In 2024, the directorate employed 500 Clinical Staff and 200 Administrative Staff. In 2025, Clinical Staff headcount increased by 10.0%, while Administrative Staff headcount decreased by 5.0%.
- Tab 2 (Remuneration): In 2024, average annual remuneration was €70,000 per Clinical Staff member and €45,000 per Administrative Staff member. In 2025, average annual remuneration in each category increased by 4.0%; these annual-average headcounts and remuneration cover the same full year. For this exercise, each category’s payroll equals its annual-average headcount multiplied by the stated annual remuneration per head. What was the directorate's total payroll expenditure in 2025, and what was the net percentage change in total payroll compared to 2024?
Total 2025 Payroll: €47,520,000; Net Change: +8.00%
Total 2025 Payroll: €48,932,000; Net Change: +11.21%
Total 2025 Payroll: €50,600,000; Net Change: +15.00%
Total 2025 Payroll: €48,932,000; Net Change: +14.40%
Sections you finish are checked off in the contents.