

FlashChat  Actuarial Discussion  Preliminary Exams  CAS/SOA Exams  Cyberchat  Around the World  Suggestions 
DW Simpson Global Actuarial & Analytics Recruitment 

Thread Tools  Search this Thread  Display Modes 
#71




Quote:
The practical question of "how many scenarios is enough?" also requires that adding more scenarios to your test does not result in repeating scenarios in the original set. Remember that for many applications, you need another random numbers for each year of the projection.
__________________
Carol Marler, "Just My Opinion" Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as nonactuarial. My latest favorite quotes, updated Nov. 20, 2018. Spoiler: 
#72




I assumed this question is answered by the output. If your distributions are smooth high resolution curves, then you're doing well. If not, you need more scenarios. If introducing more scenarios results in the same resolution, then it's time to sue Microsoft....I'm curious what happened with Mag's study.

#73




Quote:
The other thread reminds me: I did end up writing an article about floating point arithmetic (not specific to Excel) https://www.soa.org/NewsandPublica...rithmetic.aspx 
#74




https://medium.freecodecamp.com/abr...s9498737f5b6c
Quote:

#75





#76




__________________
I know I don't talk in my sleep. Someone at work would have told me by now. 
Tags 
data science, excel, predictive analytics, prngs, pseudorandom numbers, rand, random 
Thread Tools  Search this Thread 
Display Modes  

