Skip to content

Team project to perform ETL on Kaggle dataset to analyze and predict life expectancy by state and present findings.

Notifications You must be signed in to change notification settings

abednarz210/State_of_Survival-

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

State of Survival

image

Can Where You Live Determine Your Life Expecatancy?

Data for Analysis

  • Life Expectancy
  • Physical Activity
  • Obesity

Questions

  • What are factors that can impact your longevity?
  • Will exercise bring a change in your lifespan?
  • Are there variations in life expectancy by Region? Gender?
  • Were there any noticeable increases clustered in an area?
  • Did any region experience a decrease of life expectancy?

Data Clean Up

  • Examined data from 2001 -2011 for physical activity and obesity rates, as well as life expectancy from 1985-2010.
  • Sorted states by averages per counties to examine trends for changes in life expectancy to create heat map.
  • Graphics created by regions, state, counties, and gender.

Overall US Life Expectancy

  • Both genders life expectancy increased
  • Increase in males by 5.2 years, females had an increase of 3 years.

Physical Activity and Obesity Prevalence Average in the US

Due to the similar rates of increase in obesity prevalence and physical activity prevalence among the regions, the linear regression indicates there is no strong correlation between the two data points.

Conclusion/ Findings

  • Moving from the southwest to the northeast could add almost 2 years to your life.
  • While both life expectancy and physical activity increased, obesity also increased nationwide.
  • Don’t move to Oklahoma.

Data Limitations

  • Life Expectancy data was from 1985- 2010
  • Physical and Obesity 2001- 2011
  • Modern Medicine most likely contributed to higher life expectancy

Sources (http://www.healthdata.org/) (https://simplemaps.com/data/us-counties)

Final Presentation (https://docs.google.com/presentation/d/1QjBsSOIbkLeH1M9UeD2AW_zI5XcNzgZ_HP-N9yrk7sI/edit?usp=sharing)

Contributing Group Memebers: Amy Bednarz, Taylor Lyons, Matthew Villarreal, and Dillon Carter

About

Team project to perform ETL on Kaggle dataset to analyze and predict life expectancy by state and present findings.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published