![]() |
|
|
FlashChat | Actuarial Discussion | Preliminary Exams | CAS/SOA Exams | Cyberchat | Around the World | Suggestions |
|
![]() |
|
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 non-actuarial. 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/News-and-Publica...rithmetic.aspx |
#74
|
||||
|
||||
![]() https://medium.freecodecamp.com/a-br...s-9498737f5b6c
Quote:
|
#75
|
||||
|
||||
![]() |
#76
|
||||
|
||||
![]()
__________________
I know I don't talk in my sleep. Someone at work would have told me by now. |
#79
|
||||
|
||||
![]() https://arxiv.org/abs/1503.08376
Quote:
|
![]() |
Tags |
data science, excel, predictive analytics, prngs, pseudorandom numbers, rand, random |
Thread Tools | Search this Thread |
Display Modes | |
|
|