Jinwoo Chung Portfolio

HOME

ABOUT ME

PROJECTS

CONTACT

Influenza Season

November 7, 2023

Geo & Demographical population Analysis

Overview

This project aims to assist a medical staffing agency in planning for the upcoming influenza season by analyzing trends in influenza occurrences and determining staffing needs across the United States, particularly in states with large vulnerable populations.

Context

The project addresses the need for additional staff in hospitals and clinics during the influenza season when vulnerable populations are at risk of serious complications. The objective is to support the agency in proactively planning staffing needs by analyzing influenza trends and identifying high-need states.

Project Object

Determine the timing and spatial distribution of medical personnel during the influenza season.
Analyze influenza seasonality and occurrence across states.
Prioritize states with large vulnerable populations.
Assess data limitations for informed decision-making.

Data

Data Set

Influenza deaths by geography (Source: CDC)
Population data by geography, time, age, and gender (Source: US Census Bureau)

‍

Process

Data Mapping, cleaning, integration, and merging by Excel

=INDEX('census re- cleaning'!$B$2:$L$470, MATCH('Integrated Data'!B2, 'census re-cleaning'!$A$2:$A$470), MATCH(F2, 'census re-cleaning'!$B$1:$L$1))

Hypothesis setting and verification to find ways to effectively respond to flu season
Statistical analysis (T-test, Correlation Coefficient)
Geographic data visualization and forecasting with Tableau & Excel

Key Analysis

The vulnerable population (over 65 age) takes 7% of the total population in all states, But 91% of influenza deaths occur in people over 65 years of age. The influenza Mortality rate in over 65 years is 6 times higher than in others.

The strong correlation between population and flu death in the 65+ age group

Tableau's Geographic function identifies which of the 50 states has the highest rate of influenza deaths among people aged 65 and older.

Seasonal Deaths Changes(2009-2017) & Forecasting in 2018 - Similar pattern will be expected in 2018

The vulnerable population (over 65 age) takes 7% of the total population in all states, But 91% of influenza deaths occur in people over 65 years of age. The influenza Mortality rate in over 65 years is 6 times higher than in others.

The strong correlation between population and flu death in the 65+ age group

Tableau's Geographic function identifies which of the 50 states has the highest rate of influenza deaths among people aged 65 and older.

Seasonal Deaths Changes(2009-2017) & Forecasting in 2018 - Similar pattern will be expected in 2018

The vulnerable population (over 65 age) takes 7% of the total population in all states, But 91% of influenza deaths occur in people over 65 years of age. The influenza Mortality rate in over 65 years is 6 times higher than in others.

The strong correlation between population and flu death in the 65+ age group

Tableau's Geographic function identifies which of the 50 states has the highest rate of influenza deaths among people aged 65 and older.

Seasonal Deaths Changes(2009-2017) & Forecasting in 2018 - Similar pattern will be expected in 2018

Recommendations

To effectively manage influenza deaths, we need to focus especially on the population over 65 years of age, as this is the most vulnerable population with the highest mortality rates
States with more people aged 65 or older also have more influenza deaths. Therefore, a staffing plan must be prepared to take into account the population composition of each state
A seasonal staffing plan is required. It is predicted that more than half of influenza deaths will occur from December to March.

Reports