Using statistical data on the website of official publications of Rosstat (gks.ru → Publications → «Russian Statistical Yearbook - 2009".), On the basis of data on the demographic situation of the aggregate of the Russian Federation for the period:
№ p / n subject of the Russian Federation Total population, people from the general population - population aged
younger than the able-bodied working-age able-bodied
1. Calculate for each subject of the Russian Federation the rate of substitution of the working population (the calculations represented in tabular form), excluded from the study population outliers.
2. Make the group to calculate the indicator to determine in each group and the overall average:
a) the population below working age;
b) the working-age population;
c) the population of working age.
The results represented in the table, and to draw conclusions.
3. Using electronic package EXCEL, characterized closeness of the relationship between the coefficient of substitution of the working population and the degree of demographic burden on the working population.
4. To draw conclusions.