Data Analysis

This document presents an analysis from

HealthStat on Elective Hip Replacement Surgical Inpatient Stays in New York State. The analysis covers various metrics, including Length of Stay (LOS), cost, and hospital profiles.

Key Statewide Metrics

The overall metrics across New York State for this procedure are:

Total Discharges: 26K

Total Hospitals: 151

Average LOS (AVG-LOS) days: 2.65 days

Average Cost per Discharge: $21K

Total Surgeons (Serguons): 627

Length of Stay (LOS) Extremes

The hospitals with the highest and lowest average lengths of stay are:

Top 3 Highest AVG-LOS days:

Kings Co...: 12.0 days

Interfait...: 9.3 days

Memori...: 9.1 days

Lowest 3 AVG-LOS days:

Norther...: 1.4 days

St Elizab...: 1.6 days

Alice Hy...: 1.7 days

Cost Extremes and Influencers

The highest and lowest average costs per discharge are:

Top 3 Highest AVG Cost Discharges:

NYU Lut...: $85K

Olean G...: $81K

Memori...: $64K

Lowest 3 AVG Cost Discharges:

Newark-...: $7.7K

St. Mary'...: $8.5K

United....: $8.9K

Factors that significantly increase the average cost per discharge are:

APR severity of illness description is Extreme: increases cost by $37.3K.

APR risk of mortality is Extreme: increases cost by $24.25K.

health_service_area is New York City: increases cost by $15.04K.

University Hospital Profile Example

A specific profile for University Hospital shows:

AVG-LOS days: 2.56 days (below the state average of 2.65 days )

AVG cost per Discharge: $17K (below the state average of $21K )

The most common patient disposition is

Home or Self... (89.14% of discharges).

The highest volume of cases falls under the

Major category for APR severity of illness description.

The highest volume of cases falls under the

Minor category for APR risk of mortality.