The distribution of the ages of a nation’s population has a strong

Question 2: 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