PracticeVideosBlogFlashcards

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.

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:

  1. Exhibit 1 provides annual-average Staffing (SS) in Full-Time Equivalents (FTE).
  2. Exhibit 2 provides full-year Average Cost per FTE (CFTEC_{\text{FTE}}), covering all operating costs in this exercise.
  3. Exhibit 3 provides Total Inspections Completed (II) and the compliant fraction (RR, 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 CostCompliant Inspections=S×CFTEI×R\text{Cost per Compliant Inspection} = \frac{\text{Total Operational Cost}}{\text{Compliant Inspections}} = \frac{S \times C_{\text{FTE}}}{I \times R}

The denominator IRI 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 OfficeAnnual-Average FTE StaffSenior-Grade Share of FTE
Dublin HQ12025.0%
Cork6020.0%
Galway4015.0%
Limerick3010.0%

Exhibit 2: Operational Cost Schedule per FTE (2024)

Regional OfficeBase 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 OfficeTotal Environmental InspectionsCompliance Rate (%)
Dublin HQ4,80090.0%
Cork2,16085.0%
Galway1,36075.0%
Limerick96080.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 inspections120 FTE=40.0 inspections per FTE\frac{4{,}800 \text{ inspections}}{120 \text{ FTE}} = 40.0 \text{ inspections per FTE}
  • Galway productivity: 1,360 inspections40 FTE=34.0 inspections per FTE\frac{1{,}360 \text{ inspections}}{40 \text{ FTE}} = 34.0 \text{ inspections per FTE}
  • Evaluation: Dublin staff achieved 40.0−34.0=6.040.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,000120 \times \text{EUR }80{,}000 = \text{EUR }9{,}600{,}000. Cost per Inspection=EUR 9,600,0004,800=EUR 2,000.00\text{Cost per Inspection} = \frac{\text{EUR }9{,}600{,}000}{4{,}800} = \text{EUR }2{,}000.00
  • Cork: Total cost = 60×EUR 72,000=EUR 4,320,00060 \times \text{EUR }72{,}000 = \text{EUR }4{,}320{,}000. Cost per Inspection=EUR 4,320,0002,160=EUR 2,000.00\text{Cost per Inspection} = \frac{\text{EUR }4{,}320{,}000}{2{,}160} = \text{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,00030 \times \text{EUR }64{,}000 = \text{EUR }1{,}920{,}000.
  • Limerick compliant inspections: 960×0.80=768960 \times 0.80 = 768.
  • Unit cost per compliant outcome: EUR 1,920,000768=EUR 2,500.00\frac{\text{EUR }1{,}920{,}000}{768} = \text{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

  1. 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.
  2. 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.
  3. 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.
  4. 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 ChallengeRequired ExhibitsLinking VariableVerification & Sufficiency CheckTypical Psychometric Trap
Cross-Tab Unit CostStaff Table + Cost ScheduleFTE Count (SS)Confirm whether cost schedule is per FTE or per HeadcountApplying base salary while ignoring operating overheads
Regional Output EfficiencyStaff Table + Performance AuditStaff Count (SS)Ensure inspection period aligns with staffing yearComparing raw inspection counts without standardizing per FTE
Quality-Adjusted CostCost Schedule + Audit TableTotal Regional Spend (CtotC_{\text{tot}})Confirm whether compliance rate applies to all inspectionsDividing total cost by raw inspections instead of compliant outcomes
Missing Link EvaluationDemographic Table + Budget TableMissing per-capita rateCheck if population and expenditure share an empirical linkForcing a national average onto a heterogeneous local authority
Multi-Period Payroll ShiftHeadcount Shifts + Salary RevisionsBaseline Payroll (P0P_0)Calculate compounding effects on both headcount and payAdding 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.

Test Your Knowledge

Using the Environmental Regulatory Authority exhibits, what was the average operational expenditure incurred by the Limerick regional office per compliant inspection achieved in 2024?

A

€2,000.00

B

€2,250.00

C

€2,500.00

D

€3,125.00

Test Your Knowledge

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?
A

Cannot Say, because the specific proportion of emergency versus non-emergency repairs for Local Authority B is not provided.

B

True, because multiplying housing stock by the repair rate and the simple average of repair costs (€315) yields the exact figure.

C

False, because national unit cost benchmarks cannot be utilized in public sector accounting under any circumstances.

D

Cannot Say, because the total number of housing units managed by Local Authority B is omitted from Tab 1.

Test Your Knowledge

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?

A

Galway staff achieved 6.0 more inspections per FTE than Dublin, with a €200.00 higher operational cost per inspection.

B

Galway staff achieved 4.0 fewer inspections per FTE than Dublin, with an identical operational cost of €2,000.00 per inspection.

C

Galway staff achieved 6.0 fewer inspections per FTE than Dublin, but operated at a €250.00 lower operational cost per inspection.

D

Galway staff achieved 6.0 fewer inspections per FTE than Dublin, but operated at an identical operational cost of €2,000.00 per inspection.

Test Your Knowledge

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?
A

Total 2025 Payroll: €47,520,000; Net Change: +8.00%

B

Total 2025 Payroll: €48,932,000; Net Change: +11.21%

C

Total 2025 Payroll: €50,600,000; Net Change: +15.00%

D

Total 2025 Payroll: €48,932,000; Net Change: +14.40%

Sections you finish are checked off in the contents.