Go back to the file GSB 519 Male Survivors found under Content, Week 2 in D2L.

Let x denote age, let l denote the number of people alive at age x in the Male Survivors life table, and P_xj=lx+j/l_x denotes the probability of still being alive j years after age x. Life expectancy LE_x at age x is

LE_x= .5 + P_xl +P_x2 + P_x3 +.....

until the end of the life table. That is, life expectancy LE_x at age is the sum of the probabilities of surviving additional years beyond age x until you reach the end of the life table plus .5 of a year (to center deaths between years at the mid points of years). Expected age at death for a person currently age x is the sum of x and life expectancy at age x. That is, expected age at death for a person currently age x is x+LE_x.

Create an Excel spreadsheet which computes life expectancies at ages x = 0, 20, 40, 60, 80 and the corresponding expected ages at death for these ages. Copy and paste your Excel work into a Word file in the detailed work part of the assignment.

Life Expectancy at age 0 _______ and expected age at death __________

Life Expectancy at age 20 _______ and expected age at death __________

Life Expectancy at age 40 ________ and expected age at death __________

Life Expectancy at age 60 ________ and expected age at death __________

Life Expectancy at age 80 ________ and expected age at death __________

15 17 A 1 A 2 3 Age 4 0 5 1 6 2 7 3 8 4 9 5 10 6 11 7 12 8 13 9 14 10 11 16 12 13 18 14 19 15 20 16 21 17 22 18 23 19 24 20 25 21 26 22 27 23 28 24 29 25 30 26 31 27 32 28 33 29 34 30 31 36 32 37 33 38 34 39 35 40 36 41 37 42 38 43 39 B Number of Survivors 100000 99249 99193 99155 99126 99102 99083 99066 99051 99035 99019 99001 98983 98963 98938 98906 98860 98791 98700 98580 98444 98311 98163 98023 97888 97752 97624 97489 97359 97224 97092 96954 96818 96677 96522 96359 96180 95997 95791 95569 35 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 9 60 61 62 63 54 5 66 67 68 69 70 71 72 73 74 75 76 TT 78 79 80 81 2 83 40 41 47 43 44 5 6 47 48 7 0 31 2 3 54 5 6 7 58 9 60 61 62 63 64 5 66 67 68 8 8 1 72 3 74 S533 98087 94825 94542 S4229 93892 93529 92142 2713 92254 91768 51247 90707 20127 85527 88839 88151 87282 86542 85600 84C54 83582 824-8 81231 79520 7806 76588 7351 73665 71830 65875 57824 CESS2 63335 6080 58335 SSBEE 52874 S0001 47012 43928 4T8ES 76 77 78 9 30 31 4 85 6 87 8 0 91 2 93 94 95 96 7 8 9 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 32 83 34 85 86 37 88 88 0 21 92 3 24 95 96 97 8 9 100 101 102 103 104 105 106 107 103 103 110 111 37558 34457 21192 27375 24820 21768 18852 16113 13.80 11277 218 7412 5857 4546 342 258 1893 1357 953 600 400 200 100 50 30 15 3 1 0 15 17 A 1 A 2 3 Age 4 0 5 1 6 2 7 3 8 4 9 5 10 6 11 7 12 8 13 9 14 10 11 16 12 13 18 14 19 15 20 16 21 17 22 18 23 19 24 20 25 21 26 22 27 23 28 24 29 25 30 26 31 27 32 28 33 29 34 30 31 36 32 37 33 38 34 39 35 40 36 41 37 42 38 43 39 B Number of Survivors 100000 99249 99193 99155 99126 99102 99083 99066 99051 99035 99019 99001 98983 98963 98938 98906 98860 98791 98700 98580 98444 98311 98163 98023 97888 97752 97624 97489 97359 97224 97092 96954 96818 96677 96522 96359 96180 95997 95791 95569 35 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 9 60 61 62 63 54 5 66 67 68 69 70 71 72 73 74 75 76 TT 78 79 80 81 2 83 40 41 47 43 44 5 6 47 48 7 0 31 2 3 54 5 6 7 58 9 60 61 62 63 64 5 66 67 68 8 8 1 72 3 74 S533 98087 94825 94542 S4229 93892 93529 92142 2713 92254 91768 51247 90707 20127 85527 88839 88151 87282 86542 85600 84C54 83582 824-8 81231 79520 7806 76588 7351 73665 71830 65875 57824 CESS2 63335 6080 58335 SSBEE 52874 S0001 47012 43928 4T8ES 76 77 78 9 30 31 4 85 6 87 8 0 91 2 93 94 95 96 7 8 9 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 32 83 34 85 86 37 88 88 0 21 92 3 24 95 96 97 8 9 100 101 102 103 104 105 106 107 103 103 110 111 37558 34457 21192 27375 24820 21768 18852 16113 13.80 11277 218 7412 5857 4546 342 258 1893 1357 953 600 400 200 100 50 30 15 3 1 0