

FlashChat  Actuarial Discussion  Preliminary Exams  CAS/SOA Exams  Cyberchat  Around the World  Suggestions 
Browse Open Actuarial Jobs 

Thread Tools  Search this Thread  Display Modes 
#1




Testing for differences in mortality tables
Hi all,
So the question is like this: Suppose you have two mortality tables used to value your future CF for some life insurance portfolio. When switching from one table to another (say in this case the switch was from a 2008 to a 2010 m. table) the liabilities increase with 340 mln euros. What i am trying to develop at this moment:  find a statistical test (measure) to say for a x% significance level if the increase/decrease in liabilities due to changes in mortality is significant. In other words, how can i test/come up with a measure that has a known distribution having as input only two mortality tables ( with age, year of projection and prob. of survival as cells) and the known difference in liabilities? I started with some simple formula or means of aggregation for the data as in T = Sum_on_columns (Sum_of_rows (XijYij)^2)) where Xij = cell values for first table Yij = cell values for second table and trying to find the distribution for this statistic. Any clues on how to find this? Thank you a lot for any input. 
#2




I would most likely run a hypothesis tests (KolmogorovSmirnov, AndersonDarling, and ChiSquare Test) on the mortality tables on some wellknown parametric distributions for mortality and see from the results of the statistics which one is the best fit. There are some softwares that could test an overwhelming list of parametric distributions if you want an exhaustive study. Once I have fitted the mortality tables with a parametric distribution, everything will follow smoothly.

#3




Thanks for the idea  haven't thought of using a "brute force" approach.
Do you know any software that does this kind of testing? I was trying to go for a smoother approach in the sense of trying to find the distribution for the test (or a variation of that test) that i wrote before (sum of squared differences). Am I completely wrong when i say that if every data from the mortality table is obtained by using a projection model so basically every data point is actually drawn from a normal distribution with parameters u and sigma to be found out? Still working on this path as i have no clue yet. 
#4




I must confess I don't understand the point of your question. I could understand asking whether the change is MATERIAL (an accounting concept) for your company, but why do you want a statistical test? And what will you do with the answer when you get it?
Quote:
You might do a search of the SOA site on "mortality table construction" although it may just point you to the appropriate text book. There are some complex models that have been used in the past, although NOT for testing statistical significance. Do a search on LeeCarter mortality models, for example.
__________________
Carol Marler, "Just My Opinion" Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as nonactuarial. My latest favorite quotes, updated Nov. 20, 2018. Spoiler: 
#5




The mortality tables are based on historical data indeed, over which a "projection model" is applied (e.g. fitting a LeeCarter or LeeCarterMiller are the most common i believe).
The point of the question is quite simple: is the change in liabilities due to the change in mortality table values a plausible value? And the test i am trying to create is just for my personal curiosity and desire to create something new  the problem could be well solved by comparing some plain graphs in Excel. My first idea was to use some variation of a well known statistical test (as there are for contingency tables), develop that test based on the input data and find it's critical values. I think in the end i will do it the famous DickeyFuller way  Monte Carlo all the way 
#6




Quote:
If I switch from a table that poorly correlates to actual experience, to one that is more closely related, whatever the change that arises is what it is. Knowing that the tables are different or similar doesn't make the change more or less plausible. 
#7




This is exactly what i am trying to develop, not just the significance in the difference of the tables but also the impact on the liabilities.
Think of it as a version of a plain mean hypothetis testing. You have u=350 the change in liabilities and you want to see if this change can be reasonably put on behalf of the change in mortality tables. I am not discussing if the chosen mortality tables are correct or not, are close to reality or not, that is a different discussion. 
Thread Tools  Search this Thread 
Display Modes  

