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


Fill in a brief DW Simpson Registration Form
to be contacted when new jobs meet your criteria.


General Actuarial Non-Specific Actuarial Topics - Before posting a thread, please browse over our other sections to see if there is a better fit, such as Careers - Employment, Actuarial Science Universities Forum or any of our other 100+ forums.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 05-16-2019, 11:16 AM
n27 n27 is offline
Member
SOA
 
Join Date: Oct 2015
Studying for QFI Core Exam
Posts: 294
Default Modelling for dummies

In my role I have been responsible for designing models that mainly I use.

My work has been gaining more visibility. This has made me realize that I have little understanding about the background theory of model maintenance and development. I know how to make a computer calculate things but I do not know how to control quality, minimize human error, prevent deterioration, etc. I have some basic idea but there are many gaps in my knowledge.

Does anyone have any suggestions as to how I can gain solid background knowledge.

Thank you all!
(Hopefully I am posting this in the right location on this forum)
__________________
ASA FinMod Module QFI QF
Reply With Quote
  #2  
Old 05-16-2019, 12:03 PM
Vorian Atreides's Avatar
Vorian Atreides Vorian Atreides is online now
Wiki/Note Contributor
CAS
 
Join Date: Apr 2005
Location: As far as 3 cups of sugar will take you
Studying for ACAS
College: Hard Knocks
Favorite beer: Most German dark lagers
Posts: 66,404
Default

Is it safe to assume that you're on the SOA side of the fence?


Because there's a CSPA designation for the CAS side. Not sure if it would be directly applicable for L/H applications, though.
__________________
I find your lack of faith disturbing

Why should I worry about dying? Itís not going to happen in my lifetime!


Freedom of speech is not a license to discourtesy

#BLACKMATTERLIVES
Reply With Quote
  #3  
Old 05-16-2019, 12:33 PM
Kenny's Avatar
Kenny Kenny is offline
Member
Non-Actuary
 
Join Date: Jan 2003
Posts: 8,191
Default

How do you know your spreadsheet is right?
__________________
Play Free Games and Win Real Money
I am a scientist. I am sorry to disappoint you but I have never seen an elf or a troll. But who am I to exclude their existence? - Arni Bjoernsson
You are stupid and evil and do not know you are stupid and evil. ... Dumb students are educated stupid. - timecube.com
Usually while I'm reading, I'm actually thinking about...midgets riding toy horses - Roto


Reply With Quote
  #4  
Old 05-16-2019, 12:49 PM
n27 n27 is offline
Member
SOA
 
Join Date: Oct 2015
Studying for QFI Core Exam
Posts: 294
Default

Quote:
Originally Posted by Vorian Atreides View Post
Is it safe to assume that you're on the SOA side of the fence?


Because there's a CSPA designation for the CAS side. Not sure if it would be directly applicable for L/H applications, though.
Yes sir. I am on the SOA side!
__________________
ASA FinMod Module QFI QF
Reply With Quote
  #5  
Old 05-16-2019, 01:36 PM
Vorian Atreides's Avatar
Vorian Atreides Vorian Atreides is online now
Wiki/Note Contributor
CAS
 
Join Date: Apr 2005
Location: As far as 3 cups of sugar will take you
Studying for ACAS
College: Hard Knocks
Favorite beer: Most German dark lagers
Posts: 66,404
Default

Quote:
Originally Posted by n27 View Post
Yes sir. I am on the SOA side!
Not knowing your Exam history; but I wonder if any of the material on Exam PA would be beneficial.
__________________
I find your lack of faith disturbing

Why should I worry about dying? Itís not going to happen in my lifetime!


Freedom of speech is not a license to discourtesy

#BLACKMATTERLIVES
Reply With Quote
  #6  
Old 05-16-2019, 03:02 PM
n27 n27 is offline
Member
SOA
 
Join Date: Oct 2015
Studying for QFI Core Exam
Posts: 294
Default

Quote:
Originally Posted by Vorian Atreides View Post
Not knowing your Exam history; but I wonder if any of the material on Exam PA would be beneficial.
I didn't need PA when I got my ASA.
__________________
ASA FinMod Module QFI QF
Reply With Quote
  #7  
Old 05-16-2019, 03:12 PM
Vorian Atreides's Avatar
Vorian Atreides Vorian Atreides is online now
Wiki/Note Contributor
CAS
 
Join Date: Apr 2005
Location: As far as 3 cups of sugar will take you
Studying for ACAS
College: Hard Knocks
Favorite beer: Most German dark lagers
Posts: 66,404
Default

Quote:
Originally Posted by n27 View Post
I didn't need PA when I got my ASA.
Thought as much. You might start by looking at that Exam's syllabus for some good resources.
__________________
I find your lack of faith disturbing

Why should I worry about dying? Itís not going to happen in my lifetime!


Freedom of speech is not a license to discourtesy

#BLACKMATTERLIVES
Reply With Quote
  #8  
Old 05-16-2019, 05:11 PM
jraven's Avatar
jraven jraven is online now
Member
 
Join Date: Aug 2007
Location: New Hampshire
Studying for nothing!
College: Penn State
Posts: 1,311
Default

"Modeling" doesn't just mean "predictive modeling" (even on the CAS side).

n27, what kind of models (generally speaking) are you talking about? There are certain generalities that can be applied to all modeling exercises but having more details might let folks give more specific recommendations.
__________________
The Poisson distribution wasn't named after a fish -- it was named after a man ... who was named after a fish.
Reply With Quote
  #9  
Old 05-17-2019, 02:13 AM
Bro's Avatar
Bro Bro is offline
Member
Non-Actuary
 
Join Date: Jan 2015
College: School of Life
Posts: 2,008
Default

Spreadsheet Standards Review Board (international) has guidance on how to set up your models. http://www.ssrb.org/

I checked it out once as I was building a new Excel model. Didn’t get to the point of implementation of all of their recommendations, but I did build that next model with much more rigor, documentation, and, in my opinion, usability because of having some standards in mind.
__________________
Quote:
Originally Posted by George Frankly View Post
Go for it! You'll probably want to wear some latex gloves, some of this stuff can be a little nasty. After you get things all lined out, you're gonna want to smell the glove.
Reply With Quote
  #10  
Old 05-17-2019, 09:10 AM
n27 n27 is offline
Member
SOA
 
Join Date: Oct 2015
Studying for QFI Core Exam
Posts: 294
Default

Quote:
Originally Posted by jraven View Post
"Modeling" doesn't just mean "predictive modeling" (even on the CAS side).

n27, what kind of models (generally speaking) are you talking about? There are certain generalities that can be applied to all modeling exercises but having more details might let folks give more specific recommendations.
Currently all of the models we use are in Excel. Some have SQL embedded in them to access the database directly some are offline.

Most of the models are pertinent to life pricing & modelling shadow accounts.
__________________
ASA FinMod Module QFI QF
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 11:59 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.20409 seconds with 7 queries