National staff distribution project using Excel
This project aims to support a medical staffing agency in preparing for the upcoming influenza season in the United States. During flu season, hospitals experience a surge in patients, particularly among vulnerable populations, leading to increased demand for medical staff. The agency provides temporary staff to help hospitals and clinics manage this higher patient volume.
-
Goals
This project involves assisting a medical staffing agency in preparing for the upcoming influenza season by analyzing historical trends to proactively plan staffing needs across the nation. The primary objective is to forecast influenza trends, focusing on mortality rates and their correlation with age, particularly among high-risk age groups. By leveraging data analysis, the goal is to optimize staffing strategies, ensuring that healthcare facilities are adequately equipped to handle increased demand during flu season.
-
Skills & Tools
Excel
Grouping data
Summarizing data
Descriptive analysis
Tableau visualizations
Presenting results with Excel
-
Key Focus Areas
Descriptive Analysis: Conducted an analysis of the distribution of influenza mortality and population demographics.
Correlation Analysis: Investigated the relationships between variables, with a particular emphasis on vulnerable populations (aged 65 and older).
Hypothesis Testing: Evaluated the hypothesis that states with a higher proportion of vulnerable populations experience increased influenza mortality rates.
-
Data Limitations
Encountered issues related to outdated data (from 2009 to 2017), insufficient demographic details, and the presence of potential biases that could affect analysis accuracy.
Further Analysis: Vaccination rates should be investigated and added as an extra layer to the analysis. Risk groups outside of age should also be researched and considered.
-
Challenges
Complex Analysis: Faced challenges in integrating multiple data sources and conducting advanced statistical analyses to derive meaningful insights.
-
Recommendations
Enhance Resources for Vulnerable Groups: Allocate additional resources and care specifically for vulnerable populations, particularly adults aged 65 and older.
Target Staffing to Elderly Populations: Direct staffing resources to regions with significant elderly populations to improve response capacity and provide personalized care for this at-risk demographic.
Staff Allocation Based on Mortality Data: Increase staffing in mid- and high-need states according to previous years' death counts and mortality rates to effectively address anticipated demands.