Actuarial Outpost > SoA EOM 7 Task 3 Exp Rate formula
 Register Blogs Wiki FAQ Calendar Search Today's Posts Mark Forums Read
 FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

 DW SimpsonActuarial JobsVisit our site for the most up to date jobs for actuaries. Actuarial Salary SurveysProperty & Casualty, Health, Life, Pension and Non-Tradtional Jobs. Actuarial Meeting ScheduleBrowse this year's meetings and which recruiters will attend. Contact DW SimpsonHave a question? Let's talk. You'll be glad you did.

#1
08-19-2015, 03:19 PM
 Etothex Member Join Date: May 2011 College: University of Northern Iowa Posts: 153
EOM 7 Task 3 Exp Rate formula

What is the logic behind the Exp Rate formulas in cells D105: D117.

This is the section where it will combine the industry and the Green Co factors by using the calculated credibility. I understand how the manual rate factors are calculated, but I do not understand the purpose of the formula in column D. It appears to be taking the average Green Co factors and then scaling them by the average industry factors.

Any insight is much appreciated.
#2
08-27-2015, 07:34 PM
 Pippin SOA Join Date: Jan 2012 Posts: 15

just started working on EOM 7 exercise...due to differences in age bands between the data sources the GreenCo data is being split into the correct final age bands by using the industry mortality data as relativities
#3
03-17-2018, 09:39 PM
 unicorngrrrrrrrl Member SOA Join Date: Nov 2015 Posts: 170

Why would this formula multiply the proportion of greenco avg. over industry average. by the industry data mortality rate of .035?

 Tags eom7