Why is my overall delta percentage of 0.9% (bottom right) less than all 5 of the values that make it up (1.7%, 3.2%, ...)? I know with the difference in magnitude of each row and column that it could skew the percentages, and I know that I'm subtracting percentages, but I'd still expect at least 1 of the values in the right-most column to be lower than 0.9%!
A B B/A C D D/C D/C - B/A 77,629 74,645 96.2% 7,986 7,814 97.8% 1.7% 59,496 55,606 93.5% 9,779 9,448 96.6% 3.2% 48,764 40,484 83.0% 11,413 10,320 90.4% 7.4% 25,685 18,777 73.1% 9,901 7,882 79.6% 6.5% 2,915 1,956 67.1% 1,165 822 70.6% 3.5% 214,489 191,468 89.3% 40,244 36,286 90.2% 0.9% Totals