The following links may be executed to download LOTUS files to complete Assignment #1 - Complete the data entry on Exercise 1 Tables 1-8.
Table 1-EST. POP BY AGE AND SEX, US, 1980.
Table 2-LIVE BIRTHS BY AGE OF MOTHER & BY SEX, US, 1980.
Table 3-CEB AND MARST BY AGE, RACE, & RACE AND SPANISH ORIGIN, 1980.
Table 4-MARST, PRESENCE OF SPOUSE, MAR HISTORY, 15+ BY SEX & AGE, 1980.
Table 5-NO. OF MARRIAGES BY AGE & SEX, US, 1980.
Table 6-DEATHS BY AGE & SEX, US, 1979,80,& 81.
Table 7-NUPTIALITY MEASURES.
Table 8-FETAL DEATHS BY AGE OF MOTHER, RACE, BY SEX, US, 1980.
To download Lotus file and learn how to multiple a matrix of multipliers against a vector to disaggregate 5 year interval age groups into single years of age use this link.
Sprague Multiplers to disaggregate 5 year age groups into single years.
The following link may be executed to download LOTUS file to complete Assignment # 3 - Calculate the crude rates.
To complete Assignment #3b this link may be executed to download file that contains the logic of cohort grid and conversion of period data to cohort data.
Logic of Cohort Grid & Steps involved in converting period data to cohort data.
To complete Assignment # 4 - Calculate the fertility measures using the appropriate data from Exercise 1 Tables 1-8 execute the following links.
To complete Assignment # 5 - Complete the worksheets on migration measures. use the following links.
Balancing Equation
LTSR Net Migration
Selected measures
Average of Forward and Reverse LTSR Methods for Net Migration
To complete Assignment # 6 - This exercise on direct and indirect standardization is useful for comparing population statistics from different geographic units use the following links.
Indirect Standardization
Direct Standardization
To complete Assignment # 7 - Calculate the standard measures on nuptiality crude marriage rate, general marriage rate, and singulate mean age at marriage using the appropriate data for Exercise 1 Table 7. use the following link.
To complete Assignment # 8 - With the use of the appropriate information from Tables in Exercise 1 complete the life table for US females 1980 with the Reed Merrell method.
Calculations for life table 1
Reed Merrell
Use the following link to complete Assignment # 11 - Examine interpolation formulas for TN county data.
Linear interpolation for 95 Counties of TN.Total Population. 1990-2010.
Loglinear interpolation for 95 Counties of TN.Total Population. 1990-2010.