Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Life
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 11-11-2018, 09:18 PM
EK56 EK56 is offline
SOA
 
Join Date: Feb 2013
Posts: 9
Default Conversion of monthly mortality table

Hello,

I have a mortality table where the q's are given in months. I have to convert that mortality table to one where the q's are in years. So, for a given year "aaaa" I took the average of the 12 q's in the year "aaaa" as my yearly q's.

q(aaaa) = [q(January of aaaa) + q(February of aaaa) + + q(December of aaaa)] / 12

Is this correct?


Gracias y Saludos
EK56
Reply With Quote
  #2  
Old 11-11-2018, 09:53 PM
Colymbosathon ecplecticos's Avatar
Colymbosathon ecplecticos Colymbosathon ecplecticos is offline
Member
 
Join Date: Dec 2003
Posts: 6,057
Default

Where do your q values come from? Are they deaths per month? If so, averaging them will get you the average deaths per month, not deaths per year which is what you want.

Try making a life table from the q values that you have and then computing the annual q from the life table (dx/lx).

Remember, you can pick any radix (initial value for l) that you want, so chose an easy one (like 12,000,000)
__________________
"What do you mean I don't have the prerequisites for this class? I've failed it twice before!"


"I think that probably clarifies things pretty good by itself."

"I understand health care now especially very well."
Reply With Quote
  #3  
Old 11-11-2018, 10:00 PM
Gandalf's Avatar
Gandalf Gandalf is offline
Site Supporter
Site Supporter
SOA
 
Join Date: Nov 2001
Location: Middle Earth
Posts: 31,096
Default

It would be easier to answer if I understood why the original table existed and why someone wanted you to convert it. Without that knowledge, I can only suggest that you make sure that the q’s in the table are annual rates applicable during the stated months. If the q’s in the table are monthly rates, it probably makes more sense to just add them up to get an annual death rate rather than to average them.

ETA: ninja’d
Reply With Quote
  #4  
Old 11-12-2018, 09:22 AM
Gandalf's Avatar
Gandalf Gandalf is offline
Site Supporter
Site Supporter
SOA
 
Join Date: Nov 2001
Location: Middle Earth
Posts: 31,096
Default

Quote:
Originally Posted by Colymbosathon ecplecticos View Post
Where do your q values come from? Are they deaths per month? If so, averaging them will get you the average deaths per month, not deaths per year which is what you want.

Try making a life table from the q values that you have and then computing the annual q from the life table (dx/lx).
The life table approach works only (or at least, best) if you can assign the qs in the table to month of age, which is not suggested to me from the limited description. From the description, I think it contains qs by calendar month (of observation? Empirical qs?).
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 04:59 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.14587 seconds with 11 queries