LIFE EXPECTANCY CALCULATIONS DOCUMENTATION

Description:

The project aims to calculate life expectancy using various life tables and data manipulation techniques, initially focusing on Indiana, and extending to all U.S. states. Key goals include accurately determining average lifespan for different demographics, validating results against existing data, and expanding calculations to cover all counties in Indiana and eventually all states. The team has made significant progress, achieving milestones such as analyzing death rate trends, collecting data from CDC Wonder API, and successfully calculating life expectancy for Allen County in Indiana.

Aim:

The project aims to calculate life expectancy for all counties in Indiana initially, using data manipulation techniques and programming languages like R or Python. It involves comparing calculated results with existing data for accuracy. Long-term goals include extending calculations to cover all U.S. states, providing insights into population health and demographic trends.

Dataset:

https://indiana-my.sharepoint.com/:x:/g/personal/ryennam_iu_edu/EfU8EIuJHIFOqyYMXa54Vt0BeI2GxLQo42Cn5p-HnYoq9g?email=jdoddaka%40iu.edu&wdOrigin=TEAMS-MAGLEV.p2p_ns.rwc&wdExp=TEAMS-TREATMENT&wdhostclicktime=1712182855994&web=1

Key Findings:

Using the data set the team was able to visualize it using tableau. But as asked by prof skip the team is working on visualizing the data in ArcGis. Below is the visualization done using tableau.

https://indiana-my.sharepoint.com/:u:/r/personal/nyithant_iu_edu/Documents/Microsoft%20Teams%20Chat%20Files/life%20exp%20vis%20proj%201.twb?csf=1&web=1&e=znE03x

Workflow:

The team recently found source for free licenses for ArcGIS Pro and is now aiming to replicate the visualization previously created in Tableau using ArcGIS, while using existing code. Hasaranga provided suggestions for improvements to the visualization, including implementing region-based selection functionality. However, the current implementation of region-based selection is encountering issues, and the team is actively working to identify and resolve the problem. Previously, the team’s visualization only taken selection based on counties, but now they are working on selection based on regions. Despite encountering difficulties, the team is working on resolving the issue to ensure the successful implementation of region-based selection in the ArcGIS visualization.