How do I know when I'm going too deep

The fact that different age groups had different preferences CAN explain the paradox. Maybe it is so that the national average which favors the lower selling can is so high because kids like it. Kids also don't buy canned food much. Therefore different age groups and their liking different can might explain the paradox. So if you dig deep enough, B also could resolve the discrepancy.