Quantitative reasoning

Excel 8 - Population

table with row headers in column A and column headers in rows 3 through 4 (leading dots indicate sub-parts)
Table 3. Percent Distribution of the Projected Population by Selected Age Groups and Sex for the United States: 2015 to 2060
Sex and age	(Percent of total resident population as of July 1)
	2015	2060	Total Change	Percent Change	Percent Change
BOTH SEXES	100.00	100.00	(pp's)	(decimal)	(percentage)
Under 18 years	23.19	21.25
.Under 5 years	6.55	5.89
.5 to 13 years	11.44	10.65
.14 to 17 years	5.20	4.71
18 to 64 years	61.97	56.86
.18 to 24 years	9.64	8.38
.25 to 44 years	26.24	25.29
.45 to 64 years	26.09	23.18
65 years and over	14.84	21.90
.85 years and over	1.96	4.33
.100 years and over	0.02	0.16
.16 years and over	79.40	81.11
.18 years and over	76.81	78.75
.15 to 44 years	39.78	37.21
MALE	100.00	100.00
.Under 18 years	24.05	21.79						2015	2060
.Under 5 years	6.80	6.03					Both Sexes:
.5 to 13 years	11.86	10.92
.14 to 17 years	5.39	4.83
.18 to 64 years	62.66	58.13
.18 to 24 years	10.05	8.64
.25 to 44 years	26.77	26.00
.45 to 64 years	25.85	23.48
.65 years and over	13.29	20.09					Pie Chart Table	Both Sexes
.85 years and over	1.37	3.31					Age Categories	2015	2060
.100 years and over	0.01	0.08					Under 18 years
.16 years and over	78.64	80.63					18 to 64 years
.18 years and over	75.95	78.21					65 years and over
.15 to 44 years	40.86	38.27
FEMALE	100.00	100.00
.Under 18 years	22.35	20.71
.Under 5 years	6.31	5.74
.5 to 13 years	11.04	10.38									Growing?:
.14 to 17 years	5.00	4.58
.18 to 64 years	61.30	55.59
.18 to 24 years	9.25	8.13
.25 to 44 years	25.73	24.59
.45 to 64 years	26.32	22.87
.65 years and over	16.35	23.70
.85 years and over	2.54	5.34
.100 years and over	0.04	0.25
.16 years and over	80.14	81.58
.18 years and over	77.65	79.29
.15 to 44 years	38.73	36.15
Footnotes:
Suggested Citation:
Table 3. Percent Distribution of the Projected Population by Selected Age Groups and Sex for the United States: 2015 to 2060 (NP2012-T3)
Source: U.S. Census Bureau, Population Division
Release Date: December 2012

Using the U. S. Population projections in the worksheet for 2015 and 2060 please complete the following:

a.) In Column D enter a formula which computes the total change in the projected percentages for each age category from 2015 to 2060.

b.) In Column E enter a formula which computes the percent change in the projected percentages for each age category from 2015 to 2060. Format as a decimal to 3 places. Then in Column F copy these decimals and format as percentages to 1 decimal place.

c.) There are 3 separate demographic groupings: Both Sexes, Male, and Female. Each of these is subdivided into various age categories, some of which overlap. Focus just on the Both Sexes data. Determine the three age categories that represent the entire U.S. population and in cells I29:J29 enter a formula that adds the percentages for these three categories.

d.) In the Pie Chart Table below, enter a simple formula in each cell that links to each of the three age categories from part c above and the associated percentages. So if the first age category is in cell A8 then in cell I31 you would enter =A8.

e.) Create 2 pie charts for each year using the data in the pie chart table.

f.) Which demographic group is growing as a proportion of the entire population over this period?