The aggregation across these subgroups doesn't preserve the original distribution. Is that intentional?
adjusted definition change (edited to fix a unit)
Can you split Q4 out?