US State Visualization

Historical Context of Covid-19 in the United States

The Covid-19 pandemic has had a profound impact on health, economies, and daily life across the globe. In the United States, the virus has triggered widespread changes in how healthcare resources are allocated and has highlighted the critical need for timely and effective medical responses. This section provides a visual exploration of Covid-19's spread and its effects across different states over time.

Below is an interactive map that illustrates the progression of Covid-19 cases and deaths across the United States. The map uses color gradients to depict the severity of the outbreak in each state at various points throughout the pandemic. Users can interact with the map to view specific data points and trends, offering insights into how different regions have been affected over time.

Introduction

During the Covid-19 pandemic, discussions often centered on the weaknesses of the US medical system, particularly the shortage of hospital beds, physicians, and healthcare expenditures. This analysis aims to explore the relationship between the death rate and the availability of beds, physicians, and health expenditures across different states. Understanding these relationships can help identify areas for improvement and ensure better preparedness for future healthcare crises.

This section provides an exploratory analysis of the data to investigate whether a significant relationship exists between the death rate per 100,000 residents and the three variables: beds per 1,000 residents, physicians per 1,000 residents, and health expenditure per capita. Scatter plots are used to visually inspect these relationships before performing a detailed regression analysis.

Data Overview

Death per 100000 vs. Physicians per 1000

Death per 100000 vs. Health Expenditure per Capita

The scatter plots above show the relationships between the death rate per 100,000 residents and each of the three variables. From these plots, it is evident that no clear trend can be observed, indicating that a single-variable regression might not be sufficient. Therefore, a multilinear regression analysis will be conducted using all three variables.

Multilinear Regression Analysis

Regression Results for All Three Variables

Analysis:

Beds per 1000: The coefficient is not statistically significant, suggesting that the number of beds per 1000 residents does not have a significant impact on the death rate.
Health expenditure per capita: The coefficient is also not statistically significant, indicating that health expenditure per capita does not have a significant impact on the death rate.
Physicians per 1000: The coefficient is statistically significant, indicating that an increase in the number of physicians per 1000 residents is associated with a decrease in the death rate.

Based on these results, the variable 'beds per 1000' will be excluded for a more streamlined analysis.

Regression Results for Two Variables

Analysis:

Health expenditure per capita: The coefficient is not statistically significant, suggesting that health expenditure per capita does not have a significant impact on the death rate.
Physicians per 1000: The coefficient remains statistically significant, indicating that an increase in the number of physicians per 1000 residents is associated with a decrease in the death rate.

Final Equation

The final regression equation is given by:

death per 100000 = 76.5784 + 0.0019 * health expenditure per capita - 0.6299 * physicians per 1000

Interpretation:

Constant (76.5784): The baseline death rate per 100,000 residents when the other variables are zero.
Health expenditure per capita (0.0019): An increase of $1 in health expenditure per capita is associated with an increase of 0.0019 in the death rate per 100,000 residents, though this relationship is not statistically significant.
Physicians per 1000 (-0.6299): An increase of one physician per 1,000 residents is associated with a decrease of 0.6299 in the death rate per 100,000 residents.

3D Scatter Plot with Regression Plane

The 3D scatter plot above visually demonstrates the relationship between the death rate per 100,000 residents and the two significant variables: physicians per 1,000 residents and health expenditure per capita. The regression plane highlights the trend identified in the data. Specifically, we can observe that:

As the number of physicians per 1,000 residents increases, the death rate tends to decrease, which is consistent with the negative coefficient found in the regression analysis.
The effect of health expenditure per capita is less clear, as the coefficient was not statistically significant in our regression model. This indicates that variations in health expenditure per capita do not consistently correlate with changes in the death rate across different states.

Overall, this analysis underscores the importance of increasing the availability of physicians to potentially reduce the death rate in future healthcare crises. Policymakers should consider strategies to increase the number of practicing physicians, especially in underserved areas, as part of their efforts to strengthen the healthcare system's resilience.

What if Analysis

In The third tab, the user can input changes to the two explanatory variables in our model to see the potential change in death rates across the four states, which is demonstrated by a histogram here. This educate them about how a change to the availability in medical resources could help saving many lives.

Change in physicians per 1000:

Change in health expenditure per capita:

Takeaway

Our project meticulously tracks the journey of medical resource allocation and its critical impact on death rates during the COVID-19 pandemic. We start with a detailed and intuitive mapping of data that reveals, in real-time, how disparities in healthcare resources are linked to varying survival rates across the United States. This visualization not only underscores the fundamental relationship between healthcare accessibility and outcomes but does so through a lens that is both personal and urgent.

While our data initially suggests that higher health expenditure per capita might directly correlate with better outcomes, our deeper analysis reveals a more nuanced truth. The presence of physicians, rather than financial expenditure alone, emerges as the decisive factor in mitigating mortality rates. This surprising twist challenges the prevailing assumption that monetary investment in healthcare is the sole driver of better patient outcomes, highlighting a critical gap in resource allocation strategies.

Our interactive models in the third tab bring this data to life, allowing users to manipulate variables like physician availability and health expenditure. This not only personalizes the experience but also emotionally engages the user by demonstrating the potential real-world impact of these changes. It's a powerful demonstration of how even small increases in medical staffing could save countless lives, making the abstract data strikingly concrete and relatable.

Ultimately, the one thing that everyone should learn from our project is the transformative power of accessible medical care. Our project succeeds in explaining this by employing rigorous mathematical and statistical analyses, combined with dynamic visualizations that illustrate the stark differences in outcomes. We go beyond merely presenting data; we tell a story that resonates on a personal level, emphasizing that behind every data point is a human life that could be dramatically affected by policy decisions. This narrative not only informs but also inspires action, demonstrating that improving physician accessibility is not just a medical imperative but a moral one as well.

Interesting YouTube Video

Here’s our presentation video we think you'll find insightful ：）

How Does Medical Resources Per Capita Affect Death Rate of Covid-19