An analysis of food insecurity statistics for the United States of America from 2010-2021.
For completion of the Final Project requirement of the Entity Academy, Southern Careers Institute, and Woz-U Data Science curriculum.
A collaborative project by A. Nicole Mosley, Ivette Sierra, and Natalin Williams Sipes
The datasets were collected from various sources including Feeding America, the U.S. Census Bureau, the U.S. Department of Agriculture-Economic Research Service (USDA-ERS), the Bureau of Economic Analysis (BEA), and the Bureau of Labor Statistics (BLS) and wrangled via programs such as Microsoft Excel, RStudio, and Python.
2009-2011
2010-2012
2011-2013
2012-2014
2013-2015
2014-2016
2015-2017
2016-2018
2017-2019
2018-2020
2019-2021
Map the Meal Gap Overview
Percent of People by Ratio of Income to Poverty Level: 1970 to 2020
Trends in prevalence rates of food insecurity and very low food security in U.S. households, 1995-2020
Percentage of households reporting indicators of adult food insecurity, by food security status, 2020
Prevalence of very low food security by selected household characteristics, 2020
Regional Price Parities: 2008-2020
State Unemployment 2009
State Unemployment 2010
State Unemployment 2011
State Unemployment 2012
State Unemployment 2013
State Unemployment 2014
State Unemployment 2015
State Unemployment 2016
State Unemployment 2017
State Unemployment 2018
State Unemployment 2019
State Unemployment 2020
State Unemployment 2021
Data was cleaned and recoded for analysis using RStudio, Python, and Microsoft Excel.
Regional Price Parities in R
State Unemployment in R
Food Insecurity in Jupyter Notebook - Pt 1
Food Insecurity in Jupyter Notebook - Pt 2
- Percentage of Population in Poverty
- Cost Per Meal and Regional Price Parities (Cost of Living Index)
- State and Regional Level
- Food Insecurity
- Child Food Insecurity
- Unemployment
- Inflation
Annual Unemployment Rates by State
State_Data_Multiple_Years
RPP Breakdown
RPP All
RPP Goods
RPP Housing
RPP Utilities
Exploratory analyses included visualizations and the standardization of audio feature variables, as well as the calculation and plotting of correlation analyses.
Income-Poverty Ratio Notebook
Regional Price Parities Notebook
State Unemployment Rates: 2009-2021 Notebook
State Unemployment Rates: 2017-2021 (selected years) Notebook
State Data Multiple Years Notebook
Dependent t-tests and histograms were used to study variables and observe correlations between them. The best use of our time was to create new spreadsheets in Microsoft Excel, RStudio, and Google Sheets. Once the spreadsheets had been created, we imported the data into RStudio or Python for analysis. We also continued to work with datasets and notebooks analyzing regional price parities and state unemployment rates.
Dependent t-Test on Unemployment Values
General Data Analysis in RStudio
Genearl Data Analysis in RStudio
Visualizations were created in Python, Tableau, and RStudio for analysis. Among the many visuals provided in this Github, several highlighted examples are listed below.
2010 Food Insecurity
2016 Food Insecurity
2017 Food Insecurity
2018 Food Insecurity
2019 Food Insecurity
Cost Per Meal 2013-2015 Line Graph
Cost Per Meal 2016-2018 Line Graph
Cost Per Meal 2009-2019 Line Graph
Trends in Prevalance Rates of Food Insecurity and Very Low Food Insecurity, U.S. Households: 1995-2020
Food Insecurity Bar Graph: 2010-2021
Inflation in the Last 5 Years
Inflation in the Last 25 Years
Food Insecurity, Poverty, and Unemployment: 2000-2017
Farms, land in farms, and average acres per fram, 1850-2020
The Global Decline of Manufacturing: 1980-2019
Top 5 Most Expensive States for All Items: 2010
Top 5 Most Expensive States for All Items: 2020
Boxplot of Regional Housing Values, United States - WEST :2008-2020
Boxplot of Regional Utility Values, United States - SOUTHEAST :2008-2020
Regional Price Parities for States, 2019
Feeding America - Food Security Continuum
The Barbecue Lab - Who is Hungry in America?
2009 Descriptive Statistics on Unemployment Rates
2021 Descriptive Statistics on Unemployment Rates
Unemployment in the Last 5 Years
Unemployment in the Last 25 Years
Project was presented via Zoom to Woz U faculty and students for internal review on March 25, 2022.
View the project presentation video and slides on Google Docs:
Food Insecurity in the United States of America
Food Insecurity in the United States of America