combining the mortality rate with other percentages

[rashed3030]

Hello all
I have a simple example attached with 5 persons, given his/ her age, attrition rate, mortality tables

want to calculate the probability of not dying combined with the probability of not leaving work for every year until the age of 60

sheet range

Attrition rate assumption for each age band					retirement age in 60
From Age	To	Percentage of leave			num	Gender	age
18	25	20%			1	Male	32.92
26	35	10%			2	Male	39.17
36	45	10%			3	Male	42.17
46	55	5%			4	Male	48.92
56	60	0.05			5	Female	49.67

mortality

Permanent Assurances, females, combined - AFC00 two years select: values of q[x-t]+t
Age x	Duration 0	Duration 1	Durations 2+
17	0.000055	0.000111	0.000179
18	0.000056	0.000114	0.000184
19	0.000057	0.000117	0.000188
20	0.000059	0.000120	0.000194
21	0.000061	0.000123	0.000199
22	0.000063	0.000128	0.000206
23	0.000065	0.000132	0.000213
24	0.000067	0.000137	0.000221
25	0.000070	0.000143	0.000230
26	0.000073	0.000150	0.000241
27	0.000077	0.000156	0.000252
28	0.000081	0.000164	0.000265
29	0.000085	0.000174	0.000279
30	0.000092	0.000185	0.000295
31	0.000100	0.000199	0.000313
32	0.000110	0.000215	0.000333
33	0.000122	0.000234	0.000355
34	0.000135	0.000255	0.000380
35	0.000150	0.000278	0.000408
36	0.000166	0.000305	0.000439
37	0.000184	0.000333	0.000473
38	0.000205	0.000367	0.000512
39	0.000228	0.000404	0.000556
40	0.000254	0.000445	0.000604
41	0.000284	0.000492	0.000659
42	0.000317	0.000544	0.000720
43	0.000354	0.000603	0.000788
44	0.000396	0.000669	0.000864
45	0.000442	0.000742	0.000949
46	0.000495	0.000825	0.001044
47	0.000554	0.000917	0.001150
48	0.000620	0.001021	0.001269
49	0.000694	0.001136	0.001401
50	0.000777	0.001267	0.001550
51	0.000870	0.001412	0.001716
52	0.000975	0.001575	0.001901
53	0.001092	0.001758	0.002109
54	0.001223	0.001962	0.002341
55	0.001370	0.002191	0.002600
56	0.001534	0.002446	0.002890
57	0.001717	0.002731	0.003213
58	0.001922	0.003052	0.003576
59	0.002151	0.003408	0.003980
60	0.002408	0.003808	0.004433

 

[Macropod]

Cross-posted at:

combining the mortality rate with other percentages

Hello all I have a simple example attached with 5 persons, given his/ her age, attrition rate, mortality tables want to calculate the probability of not dying combined with the probability of not leaving work for every year until the age of 60

www.excelforum.com

compaining mortality rate with other percentage

Hello all I have a simple example attached with 5 persons, given his/ her age, attrition rate, mortality tables want to calculate the probability of not dying combined with the probability of not leaving work for every year until the age of 60

chandoo.org

Please read Mr Excel's policy on Cross-Posting in rule 13: Message Board Rules

 

[rashed3030]

Thanks, Macropod, I'm new and wasn't aware of that, I'm sorry for that but I can't delete the posts
what should I do?

 

[Macropod]

There is no need to delete anything - simply conform to the rules. So, if there are any other forums you've cross-posted on, you should provide the relevant links on all affected forums.