Hi All,
I have some data with an awkward structure that I'm trying to find a good way to visualize, so I was wondering if people could help.
In commercial insurance, we have two key metrics, Loss Ratio (losses / premium) and Retention (how likely the policy is to renew). Also, there are four key lines of insurance: 1) Package (property & liability, but they're always sold together so they're one line of business), 2) Auto, 3) Workers Comp, 4) Umbrella. What we want to illustrate is how much the loss ratio and retention are impacted given that an account has any particular subset of these lines of business. For example, if an account has just an auto policy, will they be worse on either metric than if they have an auto and package?
So there's a natural structure to the data that I'm having a tough time showing graphically. One more key point: it's mostly interesting to compare the performance within a line of business rather than across lines of business. For example, we wouldn't want to compare the loss ratio of just-auto to that of just-workers-comp because they have much different grand means, but we would compare just-auto performance to the performance of auto when it's paired with comp or package.
Anyone have any ideas on how to do this? I've been toying with some network-type graphs in my head but nothing seems to get at it. All we've got today is a big table that has the combo of lines-of-business on the left and performance of each line across the top, but this creates much wasted space (for example, the entry for auto performance on the row for just-package policies is always blank), and doesn't convey the conditional nature of it.
Thanks in advance.
Mike
