Explain an aggregate trend using segments and weights
Learn the reasoning. Try the task. Compare your answer.
Prepared for DataCareerHub · Curriculum version 2026-10-15.4
By the end of this lesson
- Reconcile channel summaries to monthly totals.
- Calculate weighted means from counts and component values.
- Distinguish descriptive composition from a causal explanation.
April–May teaching extract · Order values in EUR · Delivery blanks remain missing · Use a local spreadsheet; Python is optional.
Understand the method
An aggregate can move in the opposite direction from each of its components when the weights change. Northstar’s completed-order average rises from €145 in April to €171 in May. A quick headline might call that broad improvement. Before accepting it, calculate the average separately for web and store and inspect how many orders each group contributes. Keep population, period and value definitions identical in all tables.
Reconcile the component calculations
April has 18 web orders totalling €1,800, for a €100 average. It has two store orders totalling €1,100, for a €550 average. May has two web orders totalling €180, for a €90 average, and 18 store orders totalling €3,240, for a €180 average. Both channel averages fall. Channel counts sum to 20 in each month and channel values sum to €2,900 and €3,420. These reconciliations make the component table comparable to the headline.
Use the actual weights
Overall AOV is total value divided by total orders. It is also a weighted average of channel AOVs, with order shares as weights. April is 90% web and 10% store: 0.9 × 100 + 0.1 × 550 = 145. May is 10% web and 90% store: 0.1 × 90 + 0.9 × 180 = 171. Averaging two channel averages with equal weights would instead answer a hypothetical equal-mix question.
The overall increase is €26 per completed order, or about 17.9%. Web’s AOV falls by 10%; store’s falls by about 67.3%. May assigns much more weight to the channel with the higher AOV in each month. This is a concrete composition example: the aggregate alone does not establish broad improvement within groups. It does not prove that an initiative caused the change in channel mix or any order value.
Make a fixed-mix comparison explicit
For a teaching scenario, assign 50% weight to each channel in both months. April becomes 0.5 × 100 + 0.5 × 550 = €325. May becomes 0.5 × 90 + 0.5 × 180 = €135. These are standardised equal-mix summaries, not observed AOVs. Label the weights and retain actual totals beside them. Equal weights are chosen here to expose the arithmetic; they are not an official business target or a uniquely correct adjustment.
Inspect the fragile segment
April’s store average rests on only two orders, including the verified €1,000 A020 order. This gives a sparse and influential baseline. There is no evidence here that a €550 store average is stable or repeatable. Show group counts, a distribution or the individual values, and the earlier sensitivity analysis. A large percentage movement from a small group may be arithmetically correct while being unsuitable for a confident forecast.
Recommend the next investigation
A proportionate next step is to check additional periods, comparable channel populations and the source of the mix shift before scaling spend. No advertising cost, margin or experiment allocation is supplied. An observed channel association cannot identify incrementality or return on investment. Your contribution is to replace an overconfident headline with an auditable description and a focused question for further evidence.
Practical exercise
Build a month-by-channel table with completed-order count, total value, AOV and order share. Reconcile each monthly count and value to your baseline. Reconstruct overall AOV from channel weights, then calculate an explicitly hypothetical 50/50 fixed-mix average for each month.
Deliverable: a reconciled table, two weighted-average equations and a short explanation of how overall AOV can rise while both channel AOVs fall. Include April store’s sample size and high-value order. Explain why the scenario is neither a new actual total nor evidence of a causal marketing effect.
Open the worked solution
| Month / channel | Orders | Value EUR | AOV EUR | Order share |
|---|---|---|---|---|
| April / web | 18 | 1800 | 100 | 90% |
| April / store | 2 | 1100 | 550 | 10% |
| May / web | 2 | 180 | 90 | 10% |
| May / store | 18 | 3240 | 180 | 90% |
April actual AOV = (18 × 100 + 2 × 550) / 20 = 145 EUR
May actual AOV = (2 × 90 + 18 × 180) / 20 = 171 EUR
April equal-mix = 0.5 × 100 + 0.5 × 550 = 325 EUR
May equal-mix = 0.5 × 90 + 0.5 × 180 = 135 EURThe overall mean is weighted by orders, not by channel count or share of monetary value. AOV rises by (171 − 145) / 145 = 17.93%, while web falls by 10% and store by 67.27%. Store’s share rises from 10% to 90%, an 80 percentage-point change. Report the large store-baseline uncertainty: April store has n=2 and includes A020 at €1,000.
The equal-mix results are scenarios. They help reveal sensitivity to composition but do not replace the observed AOVs or justify reallocating a budget. A defensible interpretation is that the supplied extract shows a higher aggregate value associated with a different channel composition, with sparse, outlier-sensitive segment baselines. It does not establish the initiative’s causal effect.
One more question.
Method references: NIST exploratory data analysis and box plots and IQR fences. The case and exercises are authored for DataCareerHub; the quartile convention is stated in the dictionary.
How these learning materials are prepared and maintained · Report a correction: support@datacareerhub.io
Read and practice without an account. Sign in with an existing account to save lesson completion.
Next lesson →Fictional training data. Portfolio practice is not a claim of client work or an accredited qualification. Explore practical lessons, worked examples and projects. Follow a published path, practise the method and build work you can explain.