Statistical Profile — MERCY HOSPITAL COLUMBUS

🛡️ Public data only — no PHI permitted on this instance.

Beds

$5.8M

Net Revenue

6.5%

Op Margin

5.4%

Occupancy

Outlier Flags

Statistical Outliers (2)

Metrics where this hospital is >2 standard deviations from the national mean. Investigate in diligence — could signal operational issues or data quality problems.

Medicare Day %: +2.2σ above national mean
Net-to-Gross Ratio: +2.0σ above national mean

Statistical Profile — All Variables

Each metric compared to national (n=6,123) and KS (n=152) peers. Z-score shows standard deviations from national mean.

Metric	Hospital	Nat'l Median	KS Median	Z-Score	Nat'l %ile	State %ile
Beds	25	63	25	-0.59σ	P16	P42
Net Patient Revenue	$5.8M	$59.7M	$19.2M	-0.46σ	P3 ▼	P7 ▼
Operating Expenses	$5.5M	$62.7M	$22.5M	-0.46σ	P2 ▼	P2 ▼
Net Income	380,843	$-2.1M	$-3.0M	+0.09σ	P65	P87
Gross Patient Revenue	$7.2M	$186.6M	$37.4M	-0.46σ	P2 ▼	P15
Total Patient Days	492	12,073	2,916	-0.60σ	P3 ▼	P2 ▼
Medicare Day %	78.7%	30.9%	52.4%	+2.24σ	P97 ▲	P80
Operating Margin	6.5%	-4.8%	-17.7%	+0.65σ	P76	P91 ▲
Revenue per Bed	233,888	$1.2M	823,887	-0.65σ	P7 ▼	P6 ▼
Occupancy Rate	5.4%	53.7%	32.6%	-1.83σ	P2 ▼	P1 ▼
Commercial Payer %	21.3%	61.2%	39.6%	-1.84σ	P4 ▼	P21
Net-to-Gross Ratio	80.7%	33.3%	54.2%	+2.02σ	P95 ▲	P77
Expense per Bed	218,655	$1.2M	988,935	-0.56σ	P5 ▼	P1 ▼
Revenue per Patient Day	11,885	7,054	8,637	-0.03σ	P73	P73
Payer Diversity Index	0.336	0.473	0.426	-0.71σ	P17	P29

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%	$5.8M	nan	+nanσ
Operating Margin	2.1%	0.0651	nan	+nanσ
Occupancy Rate	44.3%	0.0539	nan	+nanσ
Revenue Per Bed	2.6%	233,888	nan	+nanσ
Net To Gross Ratio	22.4%	0.8067	nan	+nanσ

Hospital Profile Demand Analysis 3-Year History National Regression KS Market