Team Number _________

Access the Math server, and copy the Excel worksheets "LifeTable(US, M, 95)", "LifeTable(US, F, 95)", and "LifeTable(80+)" to your floppy. Each of these worksheets can be used to construct a new Life Table by simply replacing the data in columns 3 & 4 by the new data. Excel will redo all the calculations immediately. In this exercise, you will construct two new Life Tables. The first new Life Table you will construct, should be for the total US population (both sexes) in 1995. You can use an auxiliary Excel sheet to compute the new contents of columns 3 and 4 for this population and paste them as the new contents of columns 3 & 4.

For the second part of this exercise, you will construct the Life Table for one of your two countries, for the latest year for which the age-specific data is available. Census Bureau’s "IDB Data Access - Spreadsheets" Web page can be used to get this information. Table 94 (Midyear Population by Age & Sex), and Table 11 (Number of Deaths by Age & Sex) may provide you with further information you may need. For some countries, you may have to obtain the age-specific death data from other sources.

Pay close attention to the age groups. If the information you have obtained does not have separate categories for ages 0 and 1 - 4, then you need to do some additional calculations. You may use the mid-year population and the CBR to get the total infant population for that year, and then use the IMR to get the number of deaths for infants. The corresponding numbers for the age group 1 - 4 can then be obtained by subtraction.

For some countries the age-specific data may end with the (80+) category instead of (85+). If that is the case for your country, you should use the file "LifeTable(80+)" worksheet.

Make sure to specify which country, which sex, and which year this life table is constructed for. Also explain the details of how you obtained the contents of columns 3 and 4 for the first two age-groups.