This problem is a substitute for
those who do not attend the Computational
Science Seminar series on Sept. 9, 2000.
Below is a table of census data (population in millions) for Canada.
We want to repeat for this country the modeling effort that we
performed in class for the U. S.
Year
|
Population
|
Year
|
Population
|
Year
|
Population
|
1861
|
3.23
|
1911
|
7.21
|
1961
|
18.24
|
1871
|
3.69
|
1921
|
8.79
|
1971
|
21.57
|
1881
|
4.33
|
1931
|
10.38
|
1981
|
24.82
|
1891
|
4.83
|
1941
|
11.51
|
1991
|
28.03
|
1901
|
5.37
|
1951
|
13.65
|
|
|
Year
|
Population
|
Year
|
Population
|
Year
|
Population
|
1901
|
238
|
1941
|
319
|
1981
|
683
|
1911
|
252
|
1951
|
361
|
1991
|
846
|
1921
|
251
|
1961
|
439
|
|
|
1931
|
279
|
1971
|
548
|
|
|
The steps below are to be repeated for both the data for Canada and
India. (You are supposed to compare these to the work on the
webpage for the
analysis of the U.S. census data.)
a. Find the growth rate for each decade with the data above by dividing the population from one decade by the population of the previous decade and subtracting 1 from this ratio. Associate each growth rate with the earlier of the two census dates. Determine the average (mean) growth rate, r, from the data above. Associate t with the earlier of the dates in the growth ratio, and use EXCEL's trendline to find the best straight line