Study guide
6.2 Weighted Averages & Composite Group Statistics
Civil Service Numerical Test CSNT
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Test Structure, Platform & Scoring Strategy
1.1 CSNT Test Architecture, Adaptive Engine & Percentile Scoring 1.2 Core Numerical Strategy & Mental Estimation
2 Chapter 2: Data Interpretation — Tables, Charts & Visual Data
2.1 Reading & Interpreting Complex Tables 2.2 Bar Charts, Grouped Bars & Component/Stacked Graphs 2.3 Line Graphs, Time-Series & Trend Analysis 2.4 Pie Charts & Proportional Representation
3 Chapter 3: Advanced Data Interpretation & Variance Analysis
3.1 Multi-Source & Composite Data Synthesis 3.2 Budget Variance, Performance Metrics & Dashboards 3.3 Index Numbers & Relative Performance Measures
4 Chapter 4: Percentages, Percentage Changes & Financial Applications
4.1 Fundamentals of Percentages & Fractional Equivalents 4.2 Percentage Increase, Decrease & Successive Changes 4.3 Percentage Points vs. Percentage Change 4.4 Reverse Percentages, VAT & Financial Calculations
5 Chapter 5: Ratios, Proportions & Scaling
5.1 Ratio Simplification & Equivalent Ratios 5.2 Sharing Amounts in Ratios & Allocation Problems 5.3 Direct & Inverse Proportion and Scale Conversions
6 Chapter 6: Averages, Rates & Productivity
6.1 Measures of Central Tendency & Spread 6.2 Weighted Averages & Composite Group Statistics 6.3 Speed, Distance, Time & Travel Rates 6.4 Work Rates & Operational Productivity
7 Chapter 7: Sequences, Currency & Practical Arithmetic
7.1 Number Sequences & Pattern Recognition 7.2 Currency Conversions & Exchange Rates 7.3 Word Problems, Linear Equations & Public-Sector Constraints
6.2 Weighted Averages & Composite Group Statistics
Key Takeaways Explain This Topic AI
The weighted average formula scales each group's metric by its proportional size or significance, preventing larger cohorts from being underrepresented.
Calculating the simple arithmetic mean of group averages when group sizes or weights differ is a severe mathematical fallacy that leads to invalid conclusions.
In grouped frequency distributions where raw values are aggregated into intervals, the overall mean must be estimated using the midpoint of each class interval multiplied by its frequency.
Composite performance frameworks in central government apply uneven percentage weightings across strategic pillars (such as service delivery, budget control, and digital reform) to align scores with ministerial priorities.
When weights are expressed as percentages summing to 100%, the denominator is 100 (or 1.0), simplifying the calculation to the sum of each weight multiplied by its respective score.
Last updated: September 2026
- Section 6.2: Weighted Averages & Composite Group Statistics
- The Weighted Mean Formula and Rationale
In Civil Service governance, executive agencies, regional directorates, and operational divisions vary dramatically in scale. A frontline operational directorate in HM Revenue & Customs (HMRC) may employ 15,000 caseworkers, while an internal policy advisory unit in HM Treasury may comprise only 75 specialists. When consolidating performance indicators—such as staff engagement, operational compliance, or processing accuracy—evaluating departments on equal footing is statistically invalid.
To compute an accurate overall metric across disparate groups, each group's average must be multiplied by a factor representing its size, volume, or relative importance. This calculation is the weighted mean (denoted x ˉ w \bar{x}_w x ˉ w ): x ˉ w = ∑ ( w i ⋅ x i ) ∑ w i \bar{x}_w = \frac{\sum (w_i \cdot x_i)}{\sum w_i} x ˉ w = ∑ w i ∑ ( w i ⋅ x i )
Where:
x i x_i x i is the value or average of subgroup i i i .
w i w_i w i is the weight (headcount, budget, transaction volume, or percentage importance) assigned to subgroup i i i .
∑ ( w i ⋅ x i ) \sum (w_i \cdot x_i) ∑ ( w i ⋅ x i ) is the sum of the weighted values across all subgroups.
∑ w i \sum w_i ∑ w i is the total sum of all weights.
If the weights are expressed as proportions or percentages that sum to 100% (or 1.00 1.00 1.00 ), the formula simplifies directly to: x ˉ w = ∑ ( W i ⋅ x i ) where ∑ W i = 1.00 \bar{x}_w = \sum (W_i \cdot x_i) \quad \text{where } \sum W_i = 1.00 x ˉ w = ∑ ( W i ⋅ x i ) where ∑ W i = 1.00
The Fatal Mistake: The Fallacy of Averaging Averages
The single most pervasive error encountered on the CSNT is the unweighted averaging of averages . Candidates frequently calculate the simple arithmetic mean of two or more group percentages, completely ignoring the relative sizes of the cohorts.
Realistic Government Scenario
Consider two executive agencies within a ministerial department reporting their annual staff satisfaction survey scores:
Agency A : Has 1,000 staff and reports an 80.0% satisfaction score.
Agency B : Has 200 staff and reports a 50.0% satisfaction score.
What is the department's true overall staff satisfaction level?
The Erroneous Approach (Averaging Averages): Unweighted Average = 80.0 % + 50.0 % 2 = 130.0 % 2 = 65.0 % [FATAL ERROR] \text{Unweighted Average} = \frac{80.0\% + 50.0\%}{2} = \frac{130.0\%}{2} = 65.0\% \quad \text{[FATAL ERROR]} Unweighted Average = 2 80.0% + 50.0% = 2 130.0% = 65.0% [FATAL ERROR]
The Correct Approach (Weighted Mean):
To find the true percentage of satisfied staff across the entire department, we must calculate the absolute count of satisfied personnel:
Satisfied staff in Agency A: 1 , 000 × 0.80 = 800 employees 1,000 \times 0.80 = 800\text{ employees} 1 , 000 × 0.80 = 800 employees
Satisfied staff in Agency B: 200 × 0.50 = 100 employees 200 \times 0.50 = 100\text{ employees} 200 × 0.50 = 100 employees
Total satisfied staff: 800 + 100 = 900 employees 800 + 100 = 900\text{ employees} 800 + 100 = 900 employees
Total staff across both agencies: 1 , 000 + 200 = 1 , 200 employees 1,000 + 200 = 1,200\text{ employees} 1 , 000 + 200 = 1 , 200 employees
Applying the weighted mean formula: x ˉ w = ( 1 , 000 × 80.0 ) + ( 200 × 50.0 ) 1 , 000 + 200 = 80 , 000 + 10 , 000 1 , 200 = 90 , 000 1 , 200 = 75.0 % [CORRECT] \bar{x}_w = \frac{(1,000 \times 80.0) + (200 \times 50.0)}{1,000 + 200} = \frac{80,000 + 10,000}{1,200} = \frac{90,000}{1,200} = 75.0\% \quad \text{[CORRECT]} x ˉ w = 1 , 000 + 200 ( 1 , 000 × 80.0 ) + ( 200 × 50.0 ) = 1 , 200 80 , 000 + 10 , 000 = 1 , 200 90 , 000 = 75.0% [CORRECT]
Why This Matters
Agency A is five times larger than Agency B ( 1 , 000 : 200 = 5 : 1 1,000 : 200 = 5 : 1 1 , 000 : 200 = 5 : 1 ). Therefore, Agency A represents 5 6 \frac{5}{6} 6 5 (approx. 83.3%) of the department's workforce, while Agency B represents only 1 6 \frac{1}{6} 6 1 (approx. 16.7%). The department-wide satisfaction score must be anchored much closer to Agency A's 80.0% than to Agency B's 50.0%. The naive calculation of 65.0% understates departmental satisfaction by 10 full percentage points .
Agency Headcount ( w i w_i w i ) Satisfaction ( x i x_i x i ) Weighted Contribution ( w i ⋅ x i w_i \cdot x_i w i ⋅ x i ) Cohort Proportion ( w i / ∑ w w_i / \sum w w i / ∑ w )
- Agency A 1,000 80.0% 80,000 1 , 000 / 1 , 200 = 83.33 % 1,000 / 1,200 = 83.33\% 1 , 000/1 , 200 = 83.33%
- Agency B 200 50.0% 10,000 200 / 1 , 200 = 16.67 % 200 / 1,200 = 16.67\% 200/1 , 200 = 16.67%
Total / Result ∑ w = 1 , 200 \sum w = 1,200 ∑ w = 1 , 200 Simple Mean = 65.0% ∑ ( w i x i ) = 90 , 000 \sum (w_i x_i) = 90,000 ∑ ( w i x i ) = 90 , 000 Weighted Mean = 75.0%
Warning
CSNT Rule of Thumb : You may ONLY take the simple arithmetic mean of subgroup averages if all subgroups contain the exact same number of observations ( w 1 = w 2 = ⋯ = w k w_1 = w_2 = \dots = w_k w 1 = w 2 = ⋯ = w k ). In every other instance, you must compute the weighted mean.
Multi-Department Composite Performance Scoring
Central government frameworks frequently evaluate public bodies using composite indexes , where multiple performance criteria are combined into a single score based on predefined policy weights.
Structure of a Performance Index
Consider the Civil Service Operational Capability Framework, which rates departmental executive agencies on a 0–100 scale across four core operational pillars:
- Service Level Agreement (SLA) Clearance : Weight = 40% ( 0.40 0.40 0.40 )
- Budgetary Discipline & Value for Money : Weight = 30% ( 0.30 0.30 0.30 )
- Public Transparency & Governance : Weight = 20% ( 0.20 0.20 0.20 )
Digital Transformation Progress : Weight = 10% ( 0.10 0.10 0.10 ) Composite Score = ( 0.40 ⋅ S SLA ) + ( 0.30 ⋅ S Budget ) + ( 0.20 ⋅ S Gov ) + ( 0.10 ⋅ S Digital ) \text{Composite Score} = (0.40 \cdot S_{\text{SLA}}) + (0.30 \cdot S_{\text{Budget}}) + (0.20 \cdot S_{\text{Gov}}) + (0.10 \cdot S_{\text{Digital}}) Composite Score = ( 0.40 ⋅ S SLA ) + ( 0.30 ⋅ S Budget ) + ( 0.20 ⋅ S Gov ) + ( 0.10 ⋅ S Digital )
Worked Example 1: Comparing Departmental Composite Scores
Two executive agencies within the Home Office achieve the following audited scores across the four pillars:
- Operational Pillar Pillar Weight Agency Alpha Score Agency Beta Score
- SLA Clearance 40% (0.40) 85.0 65.0
- Budgetary Discipline 30% (0.30) 70.0 90.0
- Public Transparency 20% (0.20) 60.0 80.0
- Digital Transformation 10% (0.10) 90.0 70.0
- Simple Unweighted Mean — 76.25 76.25
Notice that if we calculate the simple arithmetic mean of each agency's scores:
Agency Alpha: 85 + 70 + 60 + 90 4 = 305 4 = 76.25 \frac{85 + 70 + 60 + 90}{4} = \frac{305}{4} = 76.25 4 85 + 70 + 60 + 90 = 4 305 = 76.25
Agency Beta: 65 + 90 + 80 + 70 4 = 305 4 = 76.25 \frac{65 + 90 + 80 + 70}{4} = \frac{305}{4} = 76.25 4 65 + 90 + 80 + 70 = 4 305 = 76.25
Both agencies appear to have identical overall performance under a naive unweighted evaluation. However, when we apply the ministerial weights:
Agency Alpha Composite Score: Score Alpha = ( 0.40 × 85.0 ) + ( 0.30 × 70.0 ) + ( 0.20 × 60.0 ) + ( 0.10 × 90.0 ) \text{Score}_{\text{Alpha}} = (0.40 \times 85.0) + (0.30 \times 70.0) + (0.20 \times 60.0) + (0.10 \times 90.0) Score Alpha = ( 0.40 × 85.0 ) + ( 0.30 × 70.0 ) + ( 0.20 × 60.0 ) + ( 0.10 × 90.0 ) Score Alpha = 34.0 + 21.0 + 12.0 + 9.0 = 76.0 \text{Score}_{\text{Alpha}} = 34.0 + 21.0 + 12.0 + 9.0 = 76.0 Score Alpha = 34.0 + 21.0 + 12.0 + 9.0 = 76.0
Agency Beta Composite Score: Score Beta = ( 0.40 × 65.0 ) + ( 0.30 × 90.0 ) + ( 0.20 × 80.0 ) + ( 0.10 × 70.0 ) \text{Score}_{\text{Beta}} = (0.40 \times 65.0) + (0.30 \times 90.0) + (0.20 \times 80.0) + (0.10 \times 70.0) Score Beta = ( 0.40 × 65.0 ) + ( 0.30 × 90.0 ) + ( 0.20 × 80.0 ) + ( 0.10 × 70.0 ) Score Beta = 26.0 + 27.0 + 16.0 + 7.0 = 76.0 \text{Score}_{\text{Beta}} = 26.0 + 27.0 + 16.0 + 7.0 = 76.0 Score Beta = 26.0 + 27.0 + 16.0 + 7.0 = 76.0
Now, suppose the Permanent Secretary issues an emergency directive restructuring the weights to prioritize frontline delivery during a crisis: SLA Clearance is elevated to 50% , Budgetary Discipline is reduced to 20% , Public Transparency remains 20% , and Digital Transformation is 10% .
Let us recalculate the updated composite scores:
Agency Alpha : ( 0.50 × 85 ) + ( 0.20 × 70 ) + ( 0.20 × 60 ) + ( 0.10 × 90 ) = 42.5 + 14.0 + 12.0 + 9.0 = 77.5 (0.50 \times 85) + (0.20 \times 70) + (0.20 \times 60) + (0.10 \times 90) = 42.5 + 14.0 + 12.0 + 9.0 = 77.5 ( 0.50 × 85 ) + ( 0.20 × 70 ) + ( 0.20 × 60 ) + ( 0.10 × 90 ) = 42.5 + 14.0 + 12.0 + 9.0 = 77.5
Agency Beta : ( 0.50 × 65 ) + ( 0.20 × 90 ) + ( 0.20 × 80 ) + ( 0.10 × 70 ) = 32.5 + 18.0 + 16.0 + 7.0 = 73.5 (0.50 \times 65) + (0.20 \times 90) + (0.20 \times 80) + (0.10 \times 70) = 32.5 + 18.0 + 16.0 + 7.0 = 73.5 ( 0.50 × 65 ) + ( 0.20 × 90 ) + ( 0.20 × 80 ) + ( 0.10 × 70 ) = 32.5 + 18.0 + 16.0 + 7.0 = 73.5
Under the revised priority framework, Agency Alpha outscores Agency Beta by 4.0 points (77.5 vs 73.5) because Agency Alpha excelled in the highest-weighted priority (SLA Clearance).
Grouped Frequency Distributions and Class Midpoint Estimation
When government databases aggregate large volumes of continuous numerical records—such as telephone wait times at the Department for Work and Pensions (DWP) or passport application processing days—the data is frequently published in grouped frequency tables (class intervals) rather than raw individual lists.
Because the exact individual values inside each interval are hidden, you cannot calculate the precise mean. Instead, you must calculate an estimated mean using the midpoint of each class interval.
The Midpoint Method Steps:
Identify the Class Midpoint ( m i m_i m i ) : Calculate the average of the lower and upper boundaries of each interval: m i = Lower Bound + Upper Bound 2 m_i = \frac{\text{Lower Bound} + \text{Upper Bound}}{2} m i = 2 Lower Bound + Upper Bound
Multiply Midpoint by Class Frequency ( f i ⋅ m i f_i \cdot m_i f i ⋅ m i ) : Treat all observations in that class as if they sit exactly at the midpoint.
Sum the Products and Divide by Total Frequency ( N N N ) : Estimated Mean x ˉ = ∑ ( f i ⋅ m i ) ∑ f i = ∑ ( f i ⋅ m i ) N \text{Estimated Mean } \bar{x} = \frac{\sum (f_i \cdot m_i)}{\sum f_i} = \frac{\sum (f_i \cdot m_i)}{N} Estimated Mean x ˉ = ∑ f i ∑ ( f i ⋅ m i ) = N ∑ ( f i ⋅ m i )
Worked Example 2: DWP Contact Centre Telephone Wait Times
A management information report logs the telephone wait times (in minutes) for 240 citizens contacting a disability benefits helpline:
Wait Time Interval (Minutes) Frequency ( f i f_i f i ) Class Midpoint ( m i m_i m i ) Product ( f i ⋅ m i f_i \cdot m_i f i ⋅ m i )
0 to under 4 mins 50 0 + 4 2 = 2.0 \frac{0 + 4}{2} = 2.0 2 0 + 4 = 2.0 50 × 2.0 = 100.0 50 \times 2.0 = 100.0 50 × 2.0 = 100.0
4 to under 8 mins 90 4 + 8 2 = 6.0 \frac{4 + 8}{2} = 6.0 2 4 + 8 = 6.0 90 × 6.0 = 540.0 90 \times 6.0 = 540.0 90 × 6.0 = 540.0
8 to under 12 mins 70 8 + 12 2 = 10.0 \frac{8 + 12}{2} = 10.0 2 8 + 12 = 10.0 70 × 10.0 = 700.0 70 \times 10.0 = 700.0 70 × 10.0 = 700.0
12 to under 16 mins 30 12 + 16 2 = 14.0 \frac{12 + 16}{2} = 14.0 2 12 + 16 = 14.0 30 × 14.0 = 420.0 30 \times 14.0 = 420.0 30 × 14.0 = 420.0
Total N = 240 N = 240 N = 240 — ∑ ( f i ⋅ m i ) = 1 , 760.0 \sum (f_i \cdot m_i) = 1,760.0 ∑ ( f i ⋅ m i ) = 1 , 760.0
Calculating the Estimated Mean: Estimated Mean Wait Time = 1 , 760.0 240 = 7.33 minutes ( 7 minutes 20 seconds ) \text{Estimated Mean Wait Time} = \frac{1,760.0}{240} = 7.33\text{ minutes} \quad (7\text{ minutes } 20\text{ seconds}) Estimated Mean Wait Time = 240 1 , 760.0 = 7.33 minutes ( 7 minutes 20 seconds )
Assumption Note : This estimation assumes that the individual wait times within each interval are evenly distributed around the midpoint. If the distribution within an interval is heavily skewed towards one boundary, the estimated mean will carry a slight estimation error.