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



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, 10:16 AM
n27 n27 is offline
Member
SOA
 
Join Date: Oct 2015
Studying for QFI Core Exam
Posts: 290
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, 11:03 AM
Vorian Atreides's Avatar
Vorian Atreides Vorian Atreides is offline
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,166
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, 11:49 AM
n27 n27 is offline
Member
SOA
 
Join Date: Oct 2015
Studying for QFI Core Exam
Posts: 290
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
  #4  
Old 05-16-2019, 12:36 PM
Vorian Atreides's Avatar
Vorian Atreides Vorian Atreides is offline
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,166
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
  #5  
Old 05-16-2019, 02:02 PM
n27 n27 is offline
Member
SOA
 
Join Date: Oct 2015
Studying for QFI Core Exam
Posts: 290
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
  #6  
Old 05-16-2019, 02:12 PM
Vorian Atreides's Avatar
Vorian Atreides Vorian Atreides is offline
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,166
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
  #7  
Old 05-16-2019, 11:33 AM
Kenny's Avatar
Kenny Kenny is offline
Member
Non-Actuary
 
Join Date: Jan 2003
Posts: 8,178
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
  #8  
Old 05-17-2019, 01:13 AM
Bro's Avatar
Bro Bro is offline
Member
Non-Actuary
 
Join Date: Jan 2015
College: School of Life
Posts: 1,997
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
  #9  
Old 05-17-2019, 10:02 AM
PAC PAC is offline
Member
CAS AAA
 
Join Date: Jan 2003
Posts: 252
Default

You may find SR 11-7: Guidance on Model Risk Management to be of interest.
Reply With Quote
  #10  
Old 05-17-2019, 12:54 PM
exponentc exponentc is offline
Member
CAS
 
Join Date: Oct 2018
College: JHU
Posts: 58
Default

There's an ASOP(draft) about modeling:http://www.actuarialstandardsboard.o...xposure-draft/
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 10:28 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.19629 seconds with 9 queries