• 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.
• Uploadbothyourexcelandworddocument