Hi, bit of a general question here but the figures i have used are from sept 2020 question 8 part iii-> part iv
Completely understand the theory of this - when t increases the probability of ruin will also increase.
However i just wanted to test this on excel for increasing values of t - for September 2020 question 8 part iii)
in this example,
E(S)=2500
Var(S)=1654167
U=2000
c=10
no. policies=500
so for t=1, x=2000+500*10*1=7000
using 1-norm.dist(x, mean, sd, true) i get the correct answer for part iii which is 0.0002337
however i then tested calculating the prob of ruin for increased values of t
for example i used t=1.25
now x=2000+500*10*1.25=8250
using 1-norm.dist(x, mean, sd, true) i get 0.0000039
so the prob of ruin i have found for t=1.25 is actually less than what i found for t=1 which isnt right.
Does anyone know what has happened here? am i doing something wrong?
thank you!
Completely understand the theory of this - when t increases the probability of ruin will also increase.
However i just wanted to test this on excel for increasing values of t - for September 2020 question 8 part iii)
in this example,
E(S)=2500
Var(S)=1654167
U=2000
c=10
no. policies=500
so for t=1, x=2000+500*10*1=7000
using 1-norm.dist(x, mean, sd, true) i get the correct answer for part iii which is 0.0002337
however i then tested calculating the prob of ruin for increased values of t
for example i used t=1.25
now x=2000+500*10*1.25=8250
using 1-norm.dist(x, mean, sd, true) i get 0.0000039
so the prob of ruin i have found for t=1.25 is actually less than what i found for t=1 which isnt right.
Does anyone know what has happened here? am i doing something wrong?
thank you!