Actuarial Outpost
 
Go Back   Actuarial Outpost > Exams - Please Limit Discussion to Exam-Related Topics > CAS > CAS Exams > Exam 7 - Estimation of Policy Liability & ERM
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

DW Simpson International Actuarial Jobs
Canada  Asia  Australia  Bermuda  Latin America  Europe


Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 01-10-2019, 01:41 AM
AbedNadir's Avatar
AbedNadir AbedNadir is offline
Member
CAS SOA
 
Join Date: Mar 2014
Studying for FCAS
Posts: 2,583
Default Calculating the hetero adjustment

I am trying to replicate the Milliman example for ODP bootstrapping given by Shapland from the original paid triangle in R

Let's say I want to find the hetero adjustment factor for periods 1-3 and the other factors are 4-7 and 8-10. I have confirmed that my standardized residuals are correct using the H matrix. I have found the standard deviation of all the standardized residuals in periods 1-3, and I have found the standard deviation of all of the standardized residuals across all periods, excluding the null points on each end of the triangle that do not have a residual.

I then divide h for all values by h for periods 1-3, but I get 1.546.

Here are the values I found standard deviations for:

Just the periods 1-3

[1] 183.60702 133.82127 -131.24915 -43.39100 -64.92590 -57.36316 -148.73570 92.42188 -55.11517 -102.84746 244.50883 -223.31533
[13] 204.07214 -189.73109 148.75836 79.40858 72.84334 -97.06667 88.67449 -164.26735 138.44964 -190.01584 -140.95863 284.34219
[25] -27.97642 27.97642

and all periods

[1] 183.60702 133.82127 -131.24915 -371.06810 193.89249 591.28897 -272.45711 -117.94646 -118.19503 -43.39100 -64.92590 -57.36316
[13] 160.13799 -208.95238 -159.80436 306.65820 32.42232 118.19503 -148.73570 92.42188 -55.11517 -26.64048 272.21870 -476.41522
[25] 252.07613 75.73922 -102.84746 244.50883 -223.31533 658.09028 -460.58857 -84.67212 -318.35358 204.07214 -189.73109 148.75836
[37] -215.74333 -24.18163 206.31529 79.40858 72.84334 -97.06667 -231.49620 256.12390 88.67449 -164.26735 138.44964 -37.66763
[49] -190.01584 -140.95863 284.34219 -27.97642 27.97642

How do I get the right value?

Thanks
__________________

Last edited by AbedNadir; 01-10-2019 at 02:51 AM..
Reply With Quote
  #2  
Old 01-10-2019, 01:39 PM
DamSon's Avatar
DamSon DamSon is online now
Member
CAS
 
Join Date: Sep 2018
Location: NYC
Studying for 8
Favorite beer: Alcoholic
Posts: 199
Default

Quote:
Originally Posted by AbedNadir View Post
I am trying to replicate the Milliman example for ODP bootstrapping given by Shapland from the original paid triangle in R

Let's say I want to find the hetero adjustment factor for periods 1-3 and the other factors are 4-7 and 8-10. I have confirmed that my standardized residuals are correct using the H matrix. I have found the standard deviation of all the standardized residuals in periods 1-3, and I have found the standard deviation of all of the standardized residuals across all periods, excluding the null points on each end of the triangle that do not have a residual.

I then divide h for all values by h for periods 1-3, but I get 1.546.

Here are the values I found standard deviations for:

Just the periods 1-3

[1] 183.60702 133.82127 -131.24915 -43.39100 -64.92590 -57.36316 -148.73570 92.42188 -55.11517 -102.84746 244.50883 -223.31533
[13] 204.07214 -189.73109 148.75836 79.40858 72.84334 -97.06667 88.67449 -164.26735 138.44964 -190.01584 -140.95863 284.34219
[25] -27.97642 27.97642

and all periods

[1] 183.60702 133.82127 -131.24915 -371.06810 193.89249 591.28897 -272.45711 -117.94646 -118.19503 -43.39100 -64.92590 -57.36316
[13] 160.13799 -208.95238 -159.80436 306.65820 32.42232 118.19503 -148.73570 92.42188 -55.11517 -26.64048 272.21870 -476.41522
[25] 252.07613 75.73922 -102.84746 244.50883 -223.31533 658.09028 -460.58857 -84.67212 -318.35358 204.07214 -189.73109 148.75836
[37] -215.74333 -24.18163 206.31529 79.40858 72.84334 -97.06667 -231.49620 256.12390 88.67449 -164.26735 138.44964 -37.66763
[49] -190.01584 -140.95863 284.34219 -27.97642 27.97642

How do I get the right value?

Thanks
By right value do you mean the 1.547 from the Shapland file?
Reply With Quote
  #3  
Old 01-10-2019, 06:47 PM
AbedNadir's Avatar
AbedNadir AbedNadir is offline
Member
CAS SOA
 
Join Date: Mar 2014
Studying for FCAS
Posts: 2,583
Default

Quote:
Originally Posted by DamSon View Post
By right value do you mean the 1.547 from the Shapland file?
Hi, yes, I see 1.585 in cell C142 on the bootstrap sheet. That is the value I should be looking at, no?
__________________
Reply With Quote
  #4  
Old 01-11-2019, 10:21 AM
DamSon's Avatar
DamSon DamSon is online now
Member
CAS
 
Join Date: Sep 2018
Location: NYC
Studying for 8
Favorite beer: Alcoholic
Posts: 199
Default

Quote:
Originally Posted by AbedNadir View Post
Hi, yes, I see 1.585 in cell C142 on the bootstrap sheet. That is the value I should be looking at, no?
I'm pretty sure you're using the scale parameter hetero adjustment then. I believe that's the default on the file. If you go to the inputs sheet, cell C39, change to StdDev and recalculate you should get 1.547.

I compared some of your residuals to the ones in the Residuals sheet they look very similar. Seems like you're doing the calculations correctly.
Reply With Quote
  #5  
Old 01-11-2019, 08:53 PM
AbedNadir's Avatar
AbedNadir AbedNadir is offline
Member
CAS SOA
 
Join Date: Mar 2014
Studying for FCAS
Posts: 2,583
Default

Quote:
Originally Posted by DamSon View Post
I'm pretty sure you're using the scale parameter hetero adjustment then. I believe that's the default on the file. If you go to the inputs sheet, cell C39, change to StdDev and recalculate you should get 1.547.

I compared some of your residuals to the ones in the Residuals sheet they look very similar. Seems like you're doing the calculations correctly.
damn son, you're right

thanks
__________________
Reply With Quote
  #6  
Old 01-11-2019, 09:32 PM
redearedslider's Avatar
redearedslider redearedslider is offline
Member
CAS
 
Join Date: Oct 2015
Posts: 13,964
Default

I see what you did there
__________________
Quote:
Originally Posted by Abraham Weishaus View Post
ASM does not have a discussion of stimulation, but considering how boring the manual is, maybe it would be a good idea.
Reply With Quote
  #7  
Old 01-11-2019, 11:41 PM
Colonel Smoothie's Avatar
Colonel Smoothie Colonel Smoothie is online now
Member
CAS
 
Join Date: Sep 2010
College: Jamba Juice University
Favorite beer: AO Amber Ale
Posts: 49,182
Default

Quote:
Originally Posted by redearedslider View Post
I see what you did there
plz
__________________
Recommended Readings for the EL Actuary || Recommended Readings for the EB Actuary

Quote:
Originally Posted by Wigmeister General View Post
Don't you even think about sending me your resume. I'll turn it into an origami boulder and return it to you.
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 12:27 PM.


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.38680 seconds with 11 queries