Statistical Profile — ASPIRUS MERRILL HOSPITAL
CCN 521339 | LINCOLN, WI | 0 outlier flags
🛡️ Public data only — no PHI permitted on this instance.
12
Beds
$26.7M
Net Revenue
13.1%
Op Margin
51.4%
Occupancy
0
Outlier Flags
Statistical Profile — All Variables
Each metric compared to national (n=6,123) and WI (n=150) peers. Z-score shows standard deviations from national mean.
| Metric | Hospital | Nat'l Median | WI Median | Z-Score | Nat'l %ile | State %ile |
|---|---|---|---|---|---|---|
| Beds | 12 | 63 | 36 | -0.66σ | P3 ▼ | P1 ▼ |
| Net Patient Revenue | $26.7M | $59.7M | $79.3M | -0.41σ | P31 | P19 |
| Operating Expenses | $23.2M | $62.7M | $77.8M | -0.42σ | P24 | P14 |
| Net Income | $3.5M | $-2.1M | 98,676 | +0.11σ | P77 | P64 |
| Gross Patient Revenue | $59.6M | $186.6M | $186.6M | -0.43σ | P28 | P20 |
| Total Patient Days | 2,252 | 12,073 | 5,437 | -0.57σ | P18 | P17 |
| Medicare Day % | 39.9% | 30.9% | 33.4% | +0.30σ | P67 | P64 |
| Medicaid Day % | 0.5% | 5.1% | 4.9% | -0.70σ | P8 ▼ | P4 ▼ |
| Operating Margin | 13.1% | -4.8% | 0.4% | +0.97σ | P86 | P81 |
| Revenue per Bed | $2.2M | $1.2M | $1.9M | +0.38σ | P82 | P61 |
| Occupancy Rate | 51.4% | 53.7% | 45.7% | -0.02σ | P47 | P61 |
| Commercial Payer % | 59.6% | 61.2% | 59.8% | +0.02σ | P47 | P48 |
| Net-to-Gross Ratio | 44.9% | 33.3% | 39.0% | +0.30σ | P69 | P62 |
| Expense per Bed | $1.9M | $1.2M | $1.8M | +0.15σ | P74 | P54 |
| Revenue per Patient Day | 11,873 | 7,054 | 12,920 | -0.03σ | P73 | P44 |
| Payer Diversity Index | 0.486 | 0.473 | 0.492 | +0.34σ | P56 | P47 |
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% | $26.7M | $3.0M | +0.09σ |
| Operating Margin | 2.1% | 0.1306 | -0.0512 | +0.96σ |
| Occupancy Rate | 44.3% | 0.5142 | 0.4822 | +0.18σ |
| Revenue Per Bed | 2.6% | $2.2M | $1.6M | +0.30σ |
| Net To Gross Ratio | 22.4% | 0.4487 | 0.3990 | +0.29σ |