Statistical Profile — MERCY HOSPITAL OF VALLEY CITY
CCN 351324 | BARNES, ND | 1 outlier flags
🛡️ Public data only — no PHI permitted on this instance.
25
Beds
$13.2M
Net Revenue
-0.8%
Op Margin
30.3%
Occupancy
1
Outlier Flags
Statistical Outliers (1)
Metrics where this hospital is >2 standard deviations from the national mean. Investigate in diligence — could signal operational issues or data quality problems.
- Commercial Payer %: -2.2σ below national mean
Statistical Profile — All Variables
Each metric compared to national (n=6,123) and ND (n=52) peers. Z-score shows standard deviations from national mean.
| Metric | Hospital | Nat'l Median | ND Median | Z-Score | Nat'l %ile | State %ile |
|---|---|---|---|---|---|---|
| Beds | 25 | 63 | 25 | -0.59σ | P16 | P38 |
| Net Patient Revenue | $13.2M | $59.7M | $15.3M | -0.44σ | P13 | P43 |
| Operating Expenses | $13.3M | $62.7M | $16.6M | -0.44σ | P10 | P29 |
| Net Income | -104,308 | $-2.1M | $-1.7M | +0.09σ | P63 | P85 |
| Gross Patient Revenue | $24.4M | $186.6M | $23.1M | -0.45σ | P11 | P51 |
| Total Patient Days | 2,767 | 12,073 | 2,584 | -0.56σ | P21 | P50 |
| Medicare Day % | 68.7% | 30.9% | 48.6% | +1.74σ | P93 ▲ | P67 |
| Medicaid Day % | 18.1% | 5.1% | 6.8% | +0.68σ | P85 | P70 |
| Operating Margin | -0.8% | -4.8% | -9.3% | +0.28σ | P60 | P82 |
| Revenue per Bed | 528,501 | $1.2M | 642,170 | -0.49σ | P24 | P37 |
| Occupancy Rate | 30.3% | 53.7% | 34.1% | -0.85σ | P24 | P44 |
| Commercial Payer % | 13.2% | 61.2% | 38.3% | -2.24σ | P2 ▼ | P4 ▼ |
| Net-to-Gross Ratio | 54.3% | 33.3% | 71.0% | +0.75σ | P79 | P33 |
| Expense per Bed | 532,674 | $1.2M | 739,987 | -0.43σ | P23 | P31 |
| Revenue per Patient Day | 4,775 | 7,054 | 9,099 | -0.06σ | P30 | P31 |
| Payer Diversity Index | 0.477 | 0.473 | 0.472 | +0.29σ | P52 | P52 |
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% | $13.2M | $32.2M | -0.07σ |
| Operating Margin | 2.1% | -0.0079 | -0.1074 | +0.52σ |
| Occupancy Rate | 44.3% | 0.3032 | 0.3174 | -0.08σ |
| Revenue Per Bed | 2.6% | 528,501 | $1.4M | -0.44σ |
| Net To Gross Ratio | 22.4% | 0.5425 | 0.5838 | -0.24σ |