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.

A B Age 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Number of Survivors 100,000 99,249 99,193 99,155 99,126 99,102 99,083 99,066 99,051 99,035 99,019 99,001 98,983 98,963 98,938 98,906 98,860 98,791 98,700 98,580 98,444 98,311 98,163 98,023 97,888 97,752 97,624 97,489 97,359 97,224 97,092 96,954 96,818 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 96,954 96,818 96,677 96.522 96.359 96,180 95,997 95,791 95,569 95,337 95,087 94,825 94.542 94.229 93,892 93,529 93.142 92,713 92.254 91,768 91.247 90.707 90.127 89,527 88,839 88.161 87.382 86.542 85,600 84,654 83.582 182,458 81,231 79.920 78,506 76,988 75,391 73,665 71,830 69.875 67,824 65,652 63,335 60,880 58.335 55,655 52.874 50.001 47,012 43,928 40.856 37,568 34,457 31,192 27.975 24,820 21.766 18,852 60 61 62 63 64 65 66 667 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 4 85 86 87 88 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 27,975 24,820 21,766 18,852 16.113 13,580 11,277 9,218 7.412 5,857 4,546 3,462 2,586 1,893 1.357 953 600 400 200 100 50 30 15 7 3 100 101 102 103 104 105 106 107 108 109 110 1 111 A B Age 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Number of Survivors 100,000 99,249 99,193 99,155 99,126 99,102 99,083 99,066 99,051 99,035 99,019 99,001 98,983 98,963 98,938 98,906 98,860 98,791 98,700 98,580 98,444 98,311 98,163 98,023 97,888 97,752 97,624 97,489 97,359 97,224 97,092 96,954 96,818 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 96,954 96,818 96,677 96.522 96.359 96,180 95,997 95,791 95,569 95,337 95,087 94,825 94.542 94.229 93,892 93,529 93.142 92,713 92.254 91,768 91.247 90.707 90.127 89,527 88,839 88.161 87.382 86.542 85,600 84,654 83.582 182,458 81,231 79.920 78,506 76,988 75,391 73,665 71,830 69.875 67,824 65,652 63,335 60,880 58.335 55,655 52.874 50.001 47,012 43,928 40.856 37,568 34,457 31,192 27.975 24,820 21.766 18,852 60 61 62 63 64 65 66 667 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 4 85 86 87 88 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 27,975 24,820 21,766 18,852 16.113 13,580 11,277 9,218 7.412 5,857 4,546 3,462 2,586 1,893 1.357 953 600 400 200 100 50 30 15 7 3 100 101 102 103 104 105 106 107 108 109 110 1 111