Team Number _________

Use the file "World (CDR, LE)2001" you had copied to your floppy disk earlier [or get it from the Math server if you don't have it on your disk, or get it from the Course Web Site]. Have Excel draw a scatter diagram for Life Expectancy vs. The Crude Death Rate for the world. Also, have Excel draw the Regression Line (or the Trend Line) for the Life Expectancy on CDR and produce the equation of the regression line and the r-squared value. If you compare this r-squared value to the one obtained in In-Class Exercise 4 between IMR and LE, you will note that this value is considerably smaller, indicating a weaker correlation between LE and CDR compared to the correlation between LE and IMR. Can you give a good reason why this is the case?

For the second part of this exercise, have Excel compute 1000/LE for each country and store them in a new column. Name this column "SSI". The acronym SSI stands for Shryock / Siegel Index. According to Shryock / Siegel, countries with a stationary population are characterized as those for which CDR and SSI are very close to each other.

Now have Excel construct a fourth column by subtracting the numbers on the first column from the those on the 3^rd [i.e., SSI - CDR]. Inspect this column, looking closely for small numbers (for example, between -2 and 2). What can you conclude about these countries, if Shryock / Siegel's claim were true. Please elaborate!