Reference no: EM13987649

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