How wrong could it be?

We have written previously about the importance of the independence assumption when modelling mortality for annuities and pensions. In a recent presentation to the Royal Statistical Society I showed the audience how life insurers deduplicate their annuity data and how they use postcodes to identify socio-economic status.

When I pointed out the strong link between income, status and multiple policies, a member of the audience asked about the impact of failing to deduplicate. This is an interesting question, since getting mortality assumptions correct for annuity pricing is particularly important due to the great sensitivity of profitability on reserve levels.

We therefore fitted a simple Perks model of mortality with age, gender and Mosaic group to an annuity portfolio. We fitted the same model once with deduplication (the correct method) and once without deduplication (the wrong method). How wrong could the non-deduplicated parameters be? Table 1 shows the percentage errors in the parameter estimates from not deduplicating.

Table 1. Percentage errors in parameter values from not deduplicating an annuity portfolio.

Parameter name Error from not
deduplicating
Age 2%
Gender.M 0%
Intercept (baseline) 1%
B - Happy Families -14%
C - Suburban Comfort -14%
D - Ties of Community -2%
E - Urban Intelligence -12%
F - Welfare Borderline -6%
G - Municipal Dependency 0%
H - Blue Collar Enterprise -2%
I - Twilight Subsistence -7%
J - Grey Perspectives -27%
K - Rural Isolation 19%

Table 1 shows a few Mosaic groups where the failure to deduplicate has made little difference: D, G and H, for example. However, there are numerous other Mosaic groups where the error is too large to be acceptable: B, C, E, J and K for this portfolio. Deduplication is clearly essential not just for the independence assumption, but also to avoid serious parameter bias.

In fact, the errors from not deduplicating properly are even worse than they seem. The Mosaic groups with the biggest errors from not deduplicating are also the groups where pensions are larger than average, as shown in Richards and Currie (2009). Thus, failure to deduplicate has an even bigger financial impact than Table 1 suggests.

Deduplication in Longevitas

Longevitas users can control all aspects of deduplication — including switching it off — in the Deduplication tab in the Configuration area.  There are ten different deduplication schemes that you can choose to apply, depending on what data you have available. 

Previous posts

Playing with scales

Mortality rates increase exponentially with age.  This can make comparisons difficult, as shown in Figure 1 below, which shows the period mortality rates for males in England and Wales at ten-year intervals. 
Tags: Filter information matrix by tag: mortality, Filter information matrix by tag: scale

Sweating your data assets

In recent years insurers have looked to making better use of the data they already have. The appeal is simple: if you have already collected the data, then it is like leaving money on the table if it is not being exploited to the full.
Tags: Filter information matrix by tag: postcodes, Filter information matrix by tag: geodemographics, Filter information matrix by tag: smoking, Filter information matrix by tag: missing data, Filter information matrix by tag: P-squared

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.