Wonder

Log in

US Adult Population 1960 - Today

Delivered March 9th, 2018. Contributors: Tara D., james O., Shannon L., Justin B., Sarah F. and

Part
01
of six
Part
01

Part 1 of 6 - US Adult Population - 1960s

The 1960s tab of the Adult Population Data spreadsheet has been completed. Below I present an overview of my findings.

OVERVIEW OF FINDINGS

1960 — The total adult population was calculated to be 110,317,759. The largest adult age group for 1960 was 35-39, recorded to have a population of 12,481,109.

1961 — The total adult population was calculated to be 111,797,000. The largest adult age group for 1961 was 35-39, recorded to have a population of 12,481,000. 

1962 — The total adult population was calculated to be 113,037,000. The largest adult age group for 1962 was 35-39, with a recorded population of 12,413,000. 

1963 — The total adult population was calculated to be 114,611,000. The largest adult age group for 1963 was 20-24, with a recorded population of 12,397,000. 

1964 — The total adult population was calculated to be 116,039,000. The largest adult age group for 1964 was 20-24, with a recorded population of 12,941,000.  

1965 — The total adult population was calculated to be 117,354,000. The largest adult age group for 1965 was 20-24, with a recorded population of 13,404,000. 

1966 — The total adult population was calculated to be 118,506,000. The largest adult age group for 1966 was 20-24, with a recorded population of 13,615,000. 

1967 — The total adult population was calculated to be 120,608,000. The largest adult age group for 1967 was 20-24, with a recorded population of 14,566,000. 

1968 — The total adult population was calculated to be 122,524,000. The largest adult age group for 1968 was 20-24, with a recorded population of 15,054,000. 

1969 — The total adult population was calculated to be 124,504,000. The largest adult age group for 1969 was 20-24, with a recorded population of 15,767,000.  

Conclusion

The 1960s section of the Adult Population Data spreadsheet has been completed and is attached below.
Part
02
of six
Part
02

Part 2 of 6 - US Adult Population - 1970s

The 1970s tab of the Adult Population Data spreadsheet has been completed. Below I present an overview of my findings.

FINDINGS

As requested, we used data from the CDC website to compile the adult population in the United States for the period 1970 to 1979.
1970 — The total adult population was calculated to be 126,241,526. The largest adult age group for 1970 was 20-24, recorded to have a population of 16,371,021.
1971 — The total adult population was calculated to be 129,375,000. The largest adult age group for 1971 was 20-24, recorded to have a population of 17,703,000. 
1972 — The total adult population was calculated to be 132,012,000. The largest adult age group for 1972 was 20-24, with a recorded population of 17,865,000. 
1973 — The total adult population was calculated to be 134,553,000. The largest adult age group for 1973 was 20-24, with a recorded population of 18,273,000. 
1974 — The total adult population was calculated to be 137,159,000. The largest adult age group for 1974 was 20-24, with a recorded population of 18,758,000.  
1975 — The total adult population was calculated to be 139,881,000. The largest adult age group for 1975 was 20-24, with a recorded population of 19,317,000. 
1976 — The total adult population was calculated to be 142,708,000. The largest adult age group for 1976 was 20-24, with a recorded population of 19,794,000.
1977 — The total adult population was calculated to be 145,686,000. The largest adult age group for 1977 was 20-24, with a recorded population of 20,311,000. 
1978 — The total adult population was calculated to be 148,705,000. The largest adult age group for 1978 was 20-24, with a recorded population of 20,748,000. 
1979 — The total adult population was calculated to be 151,766,000. The largest adult age group for 1979 was 20-24, with a recorded population of 21,096,000.  

CONCLUSION

The 1970s section of the Adult Population Data spreadsheet has been completed and is attached below.
Part
03
of six
Part
03

Part 3 of 6 - US Adult Population - 1980s

Using the single source from the CDC as directed, I have entered all adult population numbers for 1980-1989 on the "1980s" tab of the attached spreadsheet. 

Calculations

Although I used Google Sheet's formulas to perform the calculations for accuracy, the following sample calculations for age band 20-24 were made for each age band to calculate the decade average:

21,318,704 + 21,663,000 + 21,682,000 + 21,632,000 + 21,529,000 + 21,265,000 + 20,744,000 + 20,192,000 + 19,655,000 + 19,258,000 = 208,938,704

208,938,704 / 10 (number of years in the decade) = 20,893,870

I also used Google Sheet's formulas to perform the total adult population for each year for accuracy. The following sample calculations for 1980 were made for each year to calculate the total adult population:

21,318,704 + 19,520,919 + 17,560,920 + 13,965,302 + 11,669,408 + 11,089,755 + 11,710,032 + 11,615,254 + 10,087,621 + 8,782,481 + 6,798,124 + 4,793,722 + 2,935,033 + 2,240,067 = 154,087,342.

All calculations, while actually performed by Google Sheet formulas, were completed using the same pattern as the above samples.

Conclusion

The adult population numbers for the 1980s have been entered for each year on the "1980s" tab of the attached spreadsheet and have been averaged and totaled where requested.
Part
04
of six
Part
04

Part 4 of 6 - US Adult Population - 1990s

The data for the 1990s have been entered on the “1990s” tab of the attached spreadsheet. The data provided were obtained from the US Census Bureau. Please note that the data for 1990 were obtained from the figures listed under “July 1, 1990.” The data in rows 4 to 14 were obtained from the figures listed under “Five-Year Age Groups” and data in row 17 (85+) were obtained from the figures listed under “Special Age Categories (85 years and over).” The formula “SUM” was utilized to calculate the total adult population for each year, while the formula “AVERAGE” was utilized to calculate the decade average from rows 4 to 18.
The total adult population had increased each year from 1990 to 1999. The total adult population went from 177,589,000 adults in 1990 to 194,505,000 adults in 1999. The average for the decade is 186,223,800. The age group with the highest decade average is the 35-39 age group (21,783,800).

Part
05
of six
Part
05

Part 5 of 6 - US Adult Population -2000s

The total adult population went from 201,587,615 adults in 2000 to 223,491,138 adults in 2009. The adult age bracket of 60-64 saw a huge increase between 2000 and 2009 starting at 10,863,129 and ending at 16,124,997. The average total spanning over ten years for the 60-64 age bracket is 13,126,491. The adult population data for 2000 to 2009 has been added to the attached spreadsheet.

CALCULATIONS

The adult population data was available on the US Census website.
The adult population is defined as men and women 20 years or older. The Census Bureau provides a spreadsheet spanning over ten years. The age bracket on their spreadsheet was broken down into additional brackets including, 85 to 89 years, 90 to 94 years, 95 to 99 years, and 100 years and over. In order to fill in the 85+ row, these brackets needed to be added together, the total number was placed in the 85+ row for each year.

TOTAL Adults:

To find the total number of adults for each year, we add each age range as follows:
20-24 + 25-29 + 30-34 + 35-39 + 40-44 + 45-49 + 50-54 +
55-59 + 60-64 + 65-69 + 70-74 + 75-79 + 80-84 + 85+ = Total

EXAMPLE FOR 2000:

19,116,667 + 19,280,263 + 20,524,234 + 22,650,852 + 22,517,991 +
20,219,527 + 17,779,447 + 13,565,937 + 10,863,129 + 9,523,909 +
8,860,028 + 7,438,619 + 4,984,540 + 4,262,472 = 201,587,615

AVERAGE adults:

To find the average number of adults for each age range we have to add all of the entries in the specific age range than divide them by the number of year as follows:

2000+ 2001 + 2002 + 2003 + 2004 + 2005 + 2006 + 2007 + 2008 + 2009 = Total Adults
The years of 2000 to 2009 span 10 years, which is used to calculate the average as follows:
Total Adults / 10 = Decade Average

EXAMPLE FOR 20-24:

19,116,667 + 19,757,286 + 20,243,765 + 20,591,688 + 20,845,560 + 20,959,955 + 21,036,135 + 21,077,999 + 21,180,612 + 21,384,122 = 206,193,789

206,193,789 / 10 = 20,619,379

These calculations are done automatically by the spreadsheet using the SUM and Average functions and selecting the appropriate cells as can be seen on the spreadsheet.

CONCLUSION

The spreadsheet has been updated with the adult populations for the years of 2000 to 2009 broken down by age range. The total number of adults by year and the average number of adults by age range have also been calculated on the spreadsheet.
Part
06
of six
Part
06

Part 6 of 6 - US Adult Population -2010s

The total adult population went from 221,081,000 adults in 2010 to 241,899,584 adults in 2017. The adult population is defined as men and women 20 years or older. The adult population data for 2010 to 2017 has been added to the attached spreadsheet.

Methodology

I used the Census data for 2010 to 2014. For 2015 and 2016, I used the US Census's Fact Finder tool but 2017 data was not available yet by age on the US Census website. In order to find population data for 2017, I used the United Nations World Population tool. The total population by year and the average total age by age range has also been calculated using the spreadsheet functions of SUM and Average.

CALCULATIONS

Totals:

To find the total number of adults for each year, we add each age range as follows:

20-24 + 25-29 + 30-34 + 35-39 + 40-44 + 45-49 + 50-54 +
55-59 + 60-64 + 65-69 + 70-74 + 75-79 + 80-84 + 85+ = Total

Example for 2010:

22,381,028 + 22,890,884 + 21,786,359 + 20,773,905 + 19,696,251 +
20,947,623 + 21,839,056 + 21,980,108 + 19,483,036 + 16,820,083 +
11,810,247 + 8,367,895 + 5,865,639 + 6,380,331 = 241,022,445

Averages:

To find the average number of adults for each age range we have to add all of the entries in the specific age range than divide them by the number of year as follows:

2010 + 2011 + 2012 + 2013 + 2014 + 2015 + 2016 + 2017 = Total

The years of 2010 to 2017 span 8 years, which is used to calculate the average as follows:

Total Adults / 8 = Decade Average

Example for 20-24:

21,154,000 + 21,525,000 + 21,878,000 + 22,153,000 + 22,278,000 + 22,693,026 + 22,381,028 + 22,750,706 = 176,812,760

176,812,760 / 8 = 22,101,595

These calculations are done automatically by the spreadsheet using the SUM and Average functions and selecting the appropriate cells as can be seen on the spreadsheet.

CONCLUSION

The spreadsheet has been updated with the adult populations for the years of 2010 to 2017 broken down by age range. The total number of adults by year and the average number of adults by age range have also been calculated on the spreadsheet.
Sources
Sources
From Part 01

US Adult Population Data 1960-2018

docs.google.com
c

CDC

cdc.gov
From Part 02
c

Population by age groups, race, and sex for 1960-97

cdc.gov

ryC8QHC_f_US Adult Population Data 1960-2018.xlsx

docs.google.com
From Part 03

SPREADSHEET - ryC8QHC_f_US Adult Population Data 1960-2018.xlsx

docs.google.com
c

Resident population of the United States by 5 year age groups, race, and sex for 1980

cdc.gov
From Part 04

ryC8QHC_f_US Adult Population Data 1960-2018.xlsx

docs.google.com
c

Resident Population Estimates of the United States by Age and Sex: April 1, 1990 to July 1, 1999, with Short-Term Projection to November 1, 2000.

census.gov
From Part 05
w

Total Population by Age, Race and Hispanic or Latino Origin for the United States: 2000

www2.census.gov
w

Intercensal Estimates of the Resident Population by Sex and Age for the United States: April 1, 2000 to July 1, 2010

www2.census.gov

Population

census.gov

Adult Population Data 1960-2018.xlsx

docs.google.com
From Part 06

Age and Sex Composition in the United States: 2011

census.gov

Age and Sex Composition in the United States: 2010

census.gov

Age and Sex Composition in the United States: 2012

census.gov

Age and Sex Composition in the United States: 2013

census.gov

Age and Sex Composition in the United States: 2014

census.gov

American FactFinder - Results

factfinder.census.gov

World Population Prospects - Population Division - United Nations

esa.un.org

Adult Population Data 1960-2018.xlsx

docs.google.com