Tutorials › Exam PA - Predictive Analytics › Average Performance Across Business Segments

Exam PA · Success Criteria and Metric Choice · Tutorial 88 of 966

Average Performance Across Business Segments

Learn to calculate pooled and segment-level performance correctly, identify when an overall metric conceals a problem, and decide how segment results should affect model suitability.

Beginner 10 min read

What You'll Learn

  • Calculate an overall MAE from segment-level MAEs and segment sizes.
  • Combine segment RMSE values through their mean squared errors, not by averaging RMSE directly.
  • Aggregate classification sensitivity using the number of positive cases in each segment.
  • Distinguish a portfolio-wide target from segment-specific suitability requirements.
  • Report segment results without confusing small samples, unequal segment sizes, or different metric definitions.

Why an Overall Metric May Not Be Enough

A model can meet an overall performance target and still produce predictions that are consistently less useful for one part of a business. For example, a numeric prediction model may have low average error across all customers while having much larger errors for a small customer segment. Similarly, a classification model may identify most positive cases overall while missing a much larger share in a particular segment.

An overall metric answers a portfolio-wide question: how well did the model perform across the evaluated observations, under the chosen metric and weighting? It does not, by itself, answer whether the model performs acceptably for every segment. The evaluation plan should therefore specify both the overall criterion and any segment-level requirements that matter for the intended use. This topic is aligned with the SOA Exam PA (Predictive Analytics) syllabus.

Definition: A business segment is a defined subgroup of the observations, such as a product type, customer channel, or region. A segment-level metric is a performance measure calculated for observations in one such subgroup. An overall metric is calculated across the combined evaluation population. The two can differ because segments may have different performance and different numbers of observations.

A segment should be defined in a way that is relevant to the decision being evaluated and can be identified at the time the model is used. Segment results are meaningful only when the metric has the same definition in each group. For example, comparing average absolute errors is not informative if one segment's errors are measured in dollars and another's in thousands of dollars.

Combining Segment Results for Numeric Predictions

For a numeric prediction, let \(y_i\) be the observed value and \(\hat{y}_i\) the prediction for observation \(i\). Its prediction error is \(e_i=y_i-\hat{y}_i\). The mean absolute error (MAE) is the average of \(|e_i|\), and the root mean squared error (RMSE) is the square root of the average of \(e_i^2\). These definitions apply to the same evaluation observations and use equal weight per observation. If the evaluation instead assigns observation weights, those weights must be used consistently in both the overall and segment calculations.

Suppose the evaluation population is partitioned into segments indexed by \(g\), with \(n_g\) observations in segment \(g\). Let \(\operatorname{MAE}_g\) be that segment's MAE. When each observation has equal weight, the overall MAE is the observation-count-weighted average of segment MAEs:

$$ \operatorname{MAE}_{\mathrm{overall}} = \frac{\sum_g n_g\operatorname{MAE}_g}{\sum_g n_g}. $$

This identity holds because the sum of absolute errors in segment \(g\) is \(n_g\operatorname{MAE}_g\). Adding those segment sums gives the total absolute error; dividing by the total number of observations gives the overall MAE. Thus, averaging segment MAEs equally is generally wrong when segment sizes differ.

Result: Overall RMSE is not generally the observation-count-weighted average of segment RMSEs. First combine segment mean squared errors, then take the square root:
$$ \operatorname{RMSE}_{\mathrm{overall}} = \sqrt{ \frac{\sum_g n_g\operatorname{RMSE}_g^2}{\sum_g n_g} }. $$

The reason is that squared errors, rather than their square roots, add across observations. The formula uses the fact that \(\operatorname{RMSE}_g^2\) is the mean squared error in segment \(g\). It assumes the same squared-error definition and equal observation weights throughout. With unequal weights, combine each segment's weighted mean squared error using its total evaluation weight, then take the square root.

Worked Example: A Small Segment with Much Larger Absolute Errors

A hypothetical service team evaluates a monthly-cost prediction model on two customer segments. Segment North contains 80 customers and has an MAE of $12. Segment South contains 20 customers and has an MAE of $32. The business sets an overall MAE target of at most $18 and also wants to know whether either segment exceeds $25. Calculate the overall MAE and assess the two requirements.

Method. Use the observation-count-weighted MAE formula. This calculation avoids treating the two segments as equally large.

North contributes \(80(12)=\$960\) of total absolute error. South contributes \(20(32)=\$640\). The combined absolute error is \(\$960+\$640=\$1{,}600\), and the total number of customers is \(80+20=100\). Therefore,

$$ \operatorname{MAE}_{\mathrm{overall}} = \frac{80(12)+20(32)}{100} = \frac{1{,}600}{100} = \$16. $$

The overall target is met because \(\$16\leq \$18\). North's MAE is \(\$12\), below the segment limit of \(\$25\), but South's MAE is \(\$32\), above it. The overall result therefore does not establish that performance is acceptable in both segments. Common mistake avoided: reporting that the model meets the overall target and stopping there would miss the South-segment requirement.

Worked Example: Combining RMSE Across Unequal Segment Sizes

A hypothetical maintenance-planning model is assessed on 90 inspections in Segment A and 10 inspections in Segment B. Their RMSE values are 4 and 12 cost units, respectively. Calculate the overall RMSE and compare it with the unweighted average of the two segment RMSEs.

Method. Square the segment RMSEs to recover their mean squared errors, weight those by segment sizes, and take one square root at the end.

Segment A's mean squared error is \(4^2=16\), and its total squared error is \(90(16)=1{,}440\). Segment B's mean squared error is \(12^2=144\), and its total squared error is \(10(144)=1{,}440\). The total squared error is \(1{,}440+1{,}440=2{,}880\), across \(90+10=100\) inspections. Thus,

$$ \operatorname{RMSE}_{\mathrm{overall}} = \sqrt{\frac{2{,}880}{100}} = \sqrt{28.8} \approx 5.37. $$

The unweighted average of segment RMSEs is \((4+12)/2=8\), which is not the overall RMSE. It gives the small segment the same influence as the large one and also averages after taking the square root. In this example, the two segments contribute equal total squared error despite their very different sizes. Common mistake avoided: averaging RMSE values directly does not reproduce the RMSE calculated on all observations. The reported overall RMSE is 5.37 cost units, rounded to two decimals.

Combining Classification Results Carefully

Classification metrics also have different denominators. For example, sensitivity in a segment is the number of positive cases correctly classified as positive divided by the total number of actual positive cases in that segment. Consequently, overall sensitivity is weighted by the segment's number of actual positive cases, not necessarily by its total number of observations.

Definition: If segment \(g\) has \(P_g\) actual positive cases and sensitivity \(\operatorname{Sens}_g\), then, provided each case is evaluated under the same positive-class definition and classification rule, overall sensitivity is:
$$ \operatorname{Sens}_{\mathrm{overall}} = \frac{\sum_g P_g\operatorname{Sens}_g}{\sum_g P_g}. $$

This follows because \(P_g\operatorname{Sens}_g\) is the number of true positives in segment \(g\). Adding the true positives across segments and dividing by all actual positive cases gives the pooled sensitivity. The analogous weighting principle applies to other rates: identify the denominator that defines the metric, then weight by that denominator. A segment's total size is not automatically the correct weight.

Worked Example: Pooled Sensitivity Hides a Segment Gap

A hypothetical review model flags cases for further investigation. In Segment Urban, there are 100 actual positive cases, of which 90 are flagged. In Segment Rural, there are 20 actual positive cases, of which 10 are flagged. Calculate each segment's sensitivity and the overall sensitivity. The organization wants to see whether each segment reaches a sensitivity of 0.70.

Method. Divide true positives by actual positives within each segment, then pool the true positives and actual positives. This avoids weighting sensitivity by all records, including actual negatives.

Urban sensitivity is \(90/100=0.90\). Rural sensitivity is \(10/20=0.50\). Across both segments there are \(90+10=100\) true positives and \(100+20=120\) actual positives. Therefore, overall sensitivity is \(100/120=0.8333\), to four decimal places.

The overall sensitivity of 0.8333 exceeds 0.70, and Urban also exceeds 0.70. Rural does not, because \(0.50<0.70\). The overall value is the positive-count-weighted average \(\{100(0.90)+20(0.50)\}/120=0.8333\), not the equal average \((0.90+0.50)/2=0.70\). Common mistake avoided: a strong overall result does not imply that each segment meets the requirement.

Deciding What Segment Results Mean

Segment analysis is not a search for a single universally correct summary. It is a way to check whether the chosen overall success criterion is appropriate for the actual use of the predictions. A pooled metric is useful when the intended decision genuinely values performance across the combined population under its chosen weights. Segment-level requirements matter when the business has a reason to require acceptable performance in each specified group.

The evaluation plan should make that distinction explicit. A practical sequence is:

1
Define the evaluation population and segments.
State which observations are included, how group membership is assigned, and whether the groups partition the population or overlap.
2
Choose a metric and its denominator.
Use the same error definition, units, classification rule, and weighting convention for the overall result and the relevant segment results.
3
Set overall and segment criteria before interpreting results.
Specify whether the requirement concerns a portfolio-wide target, a minimum or maximum for every segment, or both.
4
Report the segment sizes with their metrics.
Readers need the denominators to understand how much each segment contributes to the pooled result and how much evidence supports its own estimate.
5
Explain suitability in context.
State whether the overall criterion is met, identify any segment that misses a pre-established requirement, and describe the practical implication without claiming more than the evaluation shows.

A small segment deserves attention, but its metric may be less stable because it is based on fewer observations. Report its size and interpret its result cautiously; do not silently remove it or treat a noisy estimate as definitive. Likewise, an observed gap is a reason to investigate suitability, not proof of its cause. Differences can reflect the model, the data, the evaluation sample, or a combination of factors.

Avoid creating many arbitrary segments after looking at the results and then presenting only the most favorable or unfavorable comparisons. Define important segments in advance where possible, based on intended use. If exploratory segment checks are also shown, label them as such. This keeps the overall success criterion interpretable and makes the evaluation more transparent.

QuestionWhat to checkWhy it matters
Does the model meet the portfolio-wide target?The correctly pooled overall metric and its weighting.Shows performance for the evaluated population under that aggregation rule.
Does a particular group have a required performance level?The group's metric, denominator, and pre-established threshold.A satisfactory overall value can coexist with a segment-level failure.
Are the segment figures comparable?Consistent definitions, units, prediction rules, and evaluation periods.Different measurement rules can create misleading apparent gaps.
How much evidence supports the segment result?The segment count and the relevant metric denominator.A rate from a small denominator may be more variable than one from a large denominator.

Common Traps

  • Averaging segments equally when their sizes differ. For observation-level MAE, weight by observation counts. For sensitivity, weight by actual positive counts.
  • Averaging RMSE values directly. Combine mean squared errors first, then take the square root.
  • Assuming a good overall result guarantees good subgroup results. Check any segment-level limits that matter to the intended use.
  • Comparing unlike metrics. Ensure units, denominators, and rules are consistent before interpreting a gap.
  • Ignoring segment sizes. Report them so readers can interpret both the contribution to the overall metric and the evidence behind each segment result.
Key takeaway: An overall metric is an aggregation, not a guarantee of uniform performance. Pool segment results using the metric's correct denominator, report segment sizes, and judge model suitability against both the overall criterion and any relevant segment-specific requirements.

Check Your Understanding

For each problem, calculate the requested pooled value and interpret it against the stated criterion.

  1. A hypothetical forecast has MAE 6 for 60 accounts in Segment A and MAE 15 for 40 accounts in Segment B. The overall target is MAE at most 10, and Segment B must also have MAE at most 12. Does the model meet each requirement? (Answer: Overall MAE \(=(60(6)+40(15))/100=9.6\), so the overall target is met; Segment B fails its limit because \(15>12\).)
  2. A repair-cost model has RMSE 3 for 75 inspections in Segment East and RMSE 9 for 25 inspections in Segment West. Calculate overall RMSE, rounded to two decimals. (Answer: \(\sqrt{\{75(3^2)+25(9^2)\}/100}=\sqrt{27}\approx 5.20\).)
  3. A screening rule has sensitivity 0.80 among 50 actual positive cases in Segment C and sensitivity 0.60 among 150 actual positive cases in Segment D. Calculate overall sensitivity to four decimal places. (Answer: \(\{50(0.80)+150(0.60)\}/200=0.6500\).)
  4. A hypothetical prediction model has MAE 4 for 30 records in one segment and MAE 10 for 70 records in another. Calculate the pooled MAE and the unweighted average of the segment MAEs. Which is the overall record-level MAE? (Answer: Pooled MAE \(=\{30(4)+70(10)\}/100=8.2\); the unweighted segment average is 7. The pooled value, 8.2, is the overall record-level MAE.)
  5. Two segments have equal numbers of records. Segment A has 40 actual positive cases and sensitivity 0.90; Segment B has 10 actual positive cases and sensitivity 0.50. Calculate overall sensitivity and explain why the equal segment average is not the pooled value. (Answer: Overall sensitivity \(=\{40(0.90)+10(0.50)\}/50=0.8200\). The equal segment average is 0.70, but pooled sensitivity weights by positive cases, not by total segment sizes.)
Clinical Biostats