A B

Number of

Age Survivors

0 100000

1 99249

2 99193

3 99155

4 99126

5 99102

6 99083

7 99066

8 99051

9 99035

10 99019

11 99001

12 98983

13 98963

14 98938

15 98906

16 98860

17 98791

18 98700

19 98580

20 98444

21 98311

22 98163

23 98023

24 97888

25 97752

26 97624

27 97489

28 97359

29 97224

30 97092

31 96954

32 96818

33 96677

34 96522

35 96359

36 96180

37 95997

38 95791

39 95569

40 95337

41 95087

42 94825

43 94542

44 94229

45 93892

46 93529

47 93142

48 92713

49 92254

50 91768

51 91247

52 90707

53 90127

54 89527

55 88839

56 88161

57 87382

58 86542

59 85600

60 84654

61 83582

62 82458

63 81231

64 79920

65 78506

66 76988

67 75391

68 73665

69 71830

70 69875

71 67824

72 65652

73 63335

74 60880

75 58335

76 55655

77 52874

78 50001

79 47012

80 43928

81 40856

82 37568

83 34457

84 31192

85 27975

86 24820

87 21766

88 18852

89 16113

90 13580

91 11277

92 9218

93 7412

94 5857

95 4546

96 3462

Look at the le GSB 519 Male Survivors uploaded above: Let x denote age, let lx denote the number of people alive at age x in the Male 1 x+j Survivors life table, and pg. = denotes the probability of still being alive j years I after age x. Life expectancy LExat age x is LE1: ='5+pxl +px2 +px3 +U. until the end of the life table. That is, life expectancyLEx 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 + LEI . 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 le in the detailed work part of the assignment