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

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer