Actuarial Outpost Calculating Trends
 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

 Entry LevelActuarial Jobs Casualty, HealthPensionsLife, Investments DW Simpson & Co.ActuarialRecruitmentWorldwide Casualty Jobs& Property -- Worldwide Reinsurance,Insurance, Bureaus & Consulting Salary SurveysLife & Health PensionProperty & Casualty

#1
09-17-2005, 10:10 AM
 tope Member Join Date: Oct 2003 Posts: 578
Calculating Trends

DATA - Assuming you have incurred claims each month from January 2004 to Present with Paid claims through to Present

QUESTION - How do you calculate annual trends as of current date

PSSIBLE SOLUTION - Do you calculate the PMPM for 2004 and 2005 (current) and then use completing factors to bring them to date?

OR

NEED HELP HERE- Is there another method

Basically I want to calculate annual trends as of current day lets say August 2005 because that when we have our most recent data

Any help would do

Thanks
#2
09-19-2005, 12:01 AM
 hopper Member Join Date: Dec 2001 Posts: 313

If you did this (completed present month PMPM)/(present month-12 PMPM)-1 , you may as well as the evaluation actuary what trend he/she uses in setting the IBNR and use it as the trend.
#3
09-19-2005, 12:25 AM
 Soccerboy Member Join Date: Apr 2003 Posts: 422

Interesting..my company used that method above (hopper) for IBNR..wonder if there are other more interesting methods out there
#4
09-19-2005, 09:38 AM
 Polly Nomial Member Join Date: Dec 2001 Location: Flatland Favorite beer: That would be flat beer, of course! Posts: 5,150

There are many ways to calculate trend and it's best not to rely on any one. I would start with 2 years of data and take pmpm2/pmpm1. For refinements, I'd look to 3, 6 or 12 month rolling averages and fit exponential curves. I suspect that you do not have claims for a large number of lives so any month by itself would not be reliable. The real trick is to look at the calculations and decide which makes sense and which doesn't.
__________________
I'm not a complete idiot!

......................Some parts may be missing.
#5
09-19-2005, 11:08 AM
 Dr T Non-Fan Member Join Date: Sep 2001 Location: Just outside of Nowhere Posts: 59,112

I suggest year-over-year 3-month rolling averages.

And do note that past trends are not correlated to future trends.

Also check for changes to exposure during trend periods.
__________________
DTNF's Basic Philosophy Regarding Posting: There's no emoticon for what I'm feeling! -- Jeff Albertson (CBG)
DTNF's Trademarked Standard Career Advice: "pass some exams and get back to us."
DTNF's Major advice: "Doesn't matter. Choose major that helps you with goal of Career Advice."
DTNF's Résumé Advice: Have a good and interesting answer to every item on it for the interviews.
DTNF's Law of Job Offers: You not only have to qualify for the position, but you also have to be the best candidate available for the offer.
DTNF's Work Philosophy: I am actuary. Please insert data. -- Actuary Actuarying Rodriguez.
#6
09-19-2005, 11:23 PM
 tope Member Join Date: Oct 2003 Posts: 578

Quote:
 Originally Posted by Polly Nomial There are many ways to calculate trend and it's best not to rely on any one. I would start with 2 years of data and take pmpm2/pmpm1. For refinements, I'd look to 3, 6 or 12 month rolling averages and fit exponential curves. I suspect that you do not have claims for a large number of lives so any month by itself would not be reliable. The real trick is to look at the calculations and decide which makes sense and which doesn't.
Sounds like a good idea,

conceptually (mathematically) how do you fit that, do you just plot your rollling averages against the prospective trends then find a pattern?
#7
09-20-2005, 01:29 AM
 hopper Member Join Date: Dec 2001 Posts: 313

Do searhes in Excel for the following functions: Logest and Index. The combination of these 2 functions, when applied to your monthly or 3 month moving or 6 month moving or whatever moving, will give you the trend assuming exponential trend. Just do not forget to exponentiate your result to get to the annual trend. Of course, you can always take the log of the PMPMs and do a linear regression on them.
#8
09-20-2005, 09:17 AM
 Polly Nomial Member Join Date: Dec 2001 Location: Flatland Favorite beer: That would be flat beer, of course! Posts: 5,150

I use the GROWTH function in Excel. The y values are the PMPM's for each 3/6/12 months. The x values are just linear, ie, month 1,2,3.... When you get the fitted curve - which is nice to graph along side your data points - the trend is [(point n)/(point n-1)]^12
__________________
I'm not a complete idiot!

......................Some parts may be missing.
#9
09-20-2005, 12:56 PM
 hopper Member Join Date: Dec 2001 Posts: 313

Do not use the Trend or Growth, because they all assume claims are increasing linearly.
#10
09-20-2005, 01:26 PM
 Dr T Non-Fan Member Join Date: Sep 2001 Location: Just outside of Nowhere Posts: 59,112

Do not use past trend as future trend. There isn't much alternative, though.
__________________
DTNF's Basic Philosophy Regarding Posting: There's no emoticon for what I'm feeling! -- Jeff Albertson (CBG)
DTNF's Trademarked Standard Career Advice: "pass some exams and get back to us."
DTNF's Major advice: "Doesn't matter. Choose major that helps you with goal of Career Advice."
DTNF's Résumé Advice: Have a good and interesting answer to every item on it for the interviews.
DTNF's Law of Job Offers: You not only have to qualify for the position, but you also have to be the best candidate available for the offer.
DTNF's Work Philosophy: I am actuary. Please insert data. -- Actuary Actuarying Rodriguez.

 Thread Tools Display Modes Linear Mode

 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 03:14 AM.

 -- Default Style - Fluid Width ---- Default Style - Fixed Width ---- Old Default Style ---- Easy on the eyes ---- Smooth Darkness ---- Chestnut ---- Apple-ish Style ---- If Apples were blue ---- If Apples were green ---- If Apples were purple ---- Halloween 2007 ---- B&W ---- Halloween ---- AO Christmas Theme ---- Turkey Day Theme ---- AO 2007 beta ---- 4th Of July Contact Us - Actuarial Outpost - Archive - Privacy Statement - Top