Actuarial Outpost
Go Back   Actuarial Outpost > Exams - Please Limit Discussion to Exam-Related Topics > SoA > Modules 6-8
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

DW Simpson
Actuarial Jobs

Visit our site for the most up to date jobs for actuaries.

Actuarial Salary Surveys
Property & Casualty, Health, Life, Pension and Non-Tradtional Jobs.

Actuarial Meeting Schedule
Browse this year's meetings and which recruiters will attend.

Contact DW Simpson
Have a question?
Let's talk.
You'll be glad you did.

Thread Tools Search this Thread Display Modes
Old 08-19-2015, 03:19 PM
Etothex Etothex is offline
Join Date: May 2011
College: University of Northern Iowa
Posts: 153
Default 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.
Reply With Quote
Old 08-27-2015, 07:34 PM
Pippin's Avatar
Pippin Pippin is offline
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
Reply With Quote
Old 03-17-2018, 09:39 PM
unicorngrrrrrrrl's Avatar
unicorngrrrrrrrl unicorngrrrrrrrl is offline
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?
Reply With Quote


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 02:18 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.14270 seconds with 9 queries