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 group19502075 Under 1029.353.3 10-1921.853.2 20-2924.051.2 30-3922.850.5 40-4919.347.5 50-5915.544.8 60-6911.040.7 70-795.530.9 80-891.621.7 90-990.18.8 100-109—1.1 Total151.1403.7