Statistical Profile — EDWARD W. SPARROW HOSPITAL
CCN 230230 | INGHAM, MI | 0 outlier flags
🛡️ Public data only — no PHI permitted on this instance.
425
Beds
$936.1M
Net Revenue
-24.5%
Op Margin
79.0%
Occupancy
0
Outlier Flags
Statistical Profile — All Variables
Each metric compared to national (n=6,123) and MI (n=163) peers. Z-score shows standard deviations from national mean.
| Metric | Hospital | Nat'l Median | MI Median | Z-Score | Nat'l %ile | State %ile |
|---|---|---|---|---|---|---|
| Beds | 425 | 63 | 55 | +1.60σ | P94 ▲ | P93 ▲ |
| Net Patient Revenue | $936.1M | $59.7M | $69.7M | +1.53σ | P95 ▲ | P96 ▲ |
| Operating Expenses | $1.17B | $62.7M | $72.4M | +1.93σ | P96 ▲ | P97 ▲ |
| Net Income | $-229.7M | $-2.1M | $-2.8M | -1.51σ | P2 ▼ | P1 ▼ |
| Gross Patient Revenue | $3.59B | $186.6M | $225.6M | +1.42σ | P94 ▲ | P97 ▲ |
| Total Patient Days | 133,177 | 12,073 | 11,507 | +1.98σ | P96 ▲ | P94 ▲ |
| Medicare Day % | 17.7% | 30.9% | 28.4% | -0.81σ | P20 | P17 |
| Medicaid Day % | 5.4% | 5.1% | 3.4% | -0.32σ | P52 | P81 |
| Operating Margin | -24.5% | -4.8% | -5.2% | -0.90σ | P16 | P10 ▼ |
| Revenue per Bed | $2.2M | $1.2M | $1.5M | +0.37σ | P81 | P76 |
| Occupancy Rate | 79.0% | 53.7% | 54.2% | +1.07σ | P84 | P83 |
| Commercial Payer % | 76.9% | 61.2% | 67.4% | +0.86σ | P83 | P82 |
| Net-to-Gross Ratio | 26.1% | 33.3% | 34.6% | -0.59σ | P32 | P18 |
| Expense per Bed | $2.7M | $1.2M | $1.5M | +0.49σ | P88 | P87 |
| Revenue per Patient Day | 7,029 | 7,054 | 8,899 | -0.05σ | P50 | P41 |
| Payer Diversity Index | 0.375 | 0.473 | 0.453 | -0.43σ | P22 | P19 |
Multi-Variable Regression Residuals
For each key metric, the national regression model predicts a value. The residual shows how much this hospital over/under-performs after controlling for all other variables.
| Target | Model R² | Actual | Predicted | Residual |
|---|---|---|---|---|
| Net Patient Revenue | 74.0% | $936.1M | $1.01B | -0.29σ |
| Operating Margin | 2.1% | -0.2454 | -0.0397 | -1.08σ |
| Occupancy Rate | 44.3% | 0.7900 | 0.7563 | +0.18σ |
| Revenue Per Bed | 2.6% | $2.2M | $2.0M | +0.11σ |
| Net To Gross Ratio | 22.4% | 0.2608 | 0.3161 | -0.32σ |