Patient Healthcare Report
About This Project
An analysis of survey results of patients’ perspectives on hospital care performed and presented on Excel, detailing hospital scores, linear regression trend lines and areas of progress. The report evaluates if patient reported experiences have improved over time.
To view the full report in Excel online please click here
Project Description
The dataset contains national and state-level results from 2013 to 2022 for the Hospital Consumer Assessment of Healthcare Providers and Systems (HCAHPS) survey. The survey contains 19 core questions about critical aspects of patients’ hospital experiences (communication with nurses and doctors, the responsiveness of hospital staff, the cleanliness and quietness of the hospital environment, communication about medicines, discharge information, overall rating of hospital, and would they recommend the hospital). Patients’ answers were grouped into three categories, Top-box (Satisfied), Middle-box (Neutral), and Bottom-box (Dissatisfied).
The objective of the report is to evaluate whether the HCAHPS survey has been successful at incentivizing hospitals to improve their quality of care. I took the position that if hospitals were improving their quality of care, then the percentage of patients giving a top-box answer should increase over time.
To identify trends or patterns in data points, I used time plot series with linear regression trendlines for all measures. These trendlines indicated that Covid was a clear change point. Before Covid, the trend was positive. I then calculated the correlation coefficients between time and survey results for each measure for two periods: overall (2014–2022) and pre-Covid (2014–2020). Based on these correlation coefficients, I tested whether there was a significant moderate to strong positive correlation between time and top-box survey results for both time periods. The analysis concluded that with a 99% confidence level, the quality of care was improving over time before Covid. However, Covid was a change point that reversed this positive trend.
The next question was how significant those improvements were before Covid. By setting the positive change statistically significance threshold to greater than 5%, I calculated the rate of change of the linear regression trendline of time and national top-box percentage results. The conclusion of this analysis was that the positive trend before Covid was not significant.
The survey results measuring the quality of care were improving over time before Covid; however, these increases were not significant. Once Covid became a factor, these improvements were reversed. Therefore, it can be concluded that the survey has not resulted in significant improvement in patients’ reported quality of care.
When analyzing state-level survey results, the goal was to identify states that had performed significantly better than the national average and could be studied for effective strategies and best practices. Three categories were highlighted:
- States that recorded an increase in their trendline pre-Covid of greater than 5%.
- States with the highest overall hospital rating top-box scores.
- States that reversed a negative Covid trend.
The report presents insights and visualizations in a concise one-page format. It also provides detailed analysis at both the national and state levels, along with an explanation of the data source.
ETL and Data Modelling
The data was extracted from Excel CSV files, transformed, and loaded into Power Query. The data model was also created in Power Query. Power Pivot Tables and charts were used to explore, analysis and gain insights.
File Types: CSV || Data Structure: Multiple Table || # of Records: 57,889 || # of Fields: 23
Source: Centers for Medicare & Medicaid Services (CMS) || License: Public Domain
Insights
HCAHPS Survey Results over the past nine years reveals a nationwide trend of patient reported hospital experiences not improving
Select states demonstrated significant pre-pandemic improvements in overall hospital ratings, that could offer valuable insights.
Recommendations
- Benchmarking and Knowledge Sharing: Encourage hospitals to benchmark against high-performing states and facilitate knowledge sharing to implement successful strategies.
- Targeted Improvement Initiatives: Focus resources on measures with satisfaction ratings below 70%, striving for more balanced performance.
- Adaptation and Resilience: Establish adaptable systems to maintain patient satisfaction, even in challenging circumstances. Investigate strategies used by states that improved hospital ratings during the pandemic for actionable insights.