Question: The distribution of the ages of a nation's population has a strong influence on economic and social conditions. The following table shows the age distribution of U.S. residents in 1950 and the projected distribution in 2075, in millions of people.
• Because the total population in 2075 is much larger than the 1950 population, comparing percent in each age group is clearer then comparing counts. Make a table of the percent of the total population in each age group for both 1950 and 2075. Use excel to enter the original data and to compute the percentages.
• Using excel create two histograms with a vertical scale in percents for the 1950 and 2075 population data.
• Insert the histograms into a word document and discuss the main features of each histogram and compare and contrast them.
• Upload both your excel and word document
|
Age group
|
1950
|
2075
|
|
Under 10
|
29.3
|
53.3
|
|
10-19
|
21.8
|
53.2
|
|
20-29
|
24.0
|
51.2
|
|
30-39
|
22.8
|
50.5
|
|
40-49
|
19.3
|
47.5
|
|
50-59
|
15.5
|
44.8
|
|
60-69
|
11.0
|
40.7
|
|
70-79
|
5.5
|
30.9
|
|
80-89
|
1.6
|
21.7
|
|
90-99
|
0.1
|
8.8
|
|
100-109
|
--
|
1.1
|
|
Total
|
151.1
|
403.7
|