presentation stat

Assumptions

Variable Name	Description	Definition
HAC_Rate	Hospital-acquired condition rate	Number of hospital-acquired conditions (HAC) per 1,000 discharges; measures extent of hospital errors
Nursing_HPPD	Nursing hours per patient day	Number of nursing staff hours per patient day (HPPD); measures nurse staffing level
Skill_Mix	Nursing skill mix	Percentage of nursing staff hours provided by Registered Nurses (RN); measures skill mix of nursing staff
ALOS	Average length of stay	Number of inpatient days per hospital discharge; measures hospital efficiency
Financial Assumptions:
Hospital discharges	10,000
Nursing cost per year	$72,000	Average of RN and LPN nursing cost; cost includes salary, benefits, and overhead
RN cost per year	$85,000
LPN cost per year	$52,000
Hospital cost per inpatient day	$2,600
Hospital penalty per HAC	$5,700

Data

HAC_Rate	Nursing_HPPD	Skill_Mix	ALOS
108	5.017	60.22	4.017
106	5.057	60.68	4.057
112	4.184	59.99	4.184
116	4.202	58.82	5.202
107	6.249	62.53	4.249
119	3.315	58.92	4.315
109	5.401	60.69	4.401
116	4.418	59.8	5.418
115	3.532	58.94	4.532
119	3.626	59.24	5.626
114	4.629	61.15	4.629
113	4.662	60.67	4.662
119	3.681	59.74	5.681
114	4.703	59.77	4.703
106	6.719	60.26	4.719
115	4.812	60.6	5.812
107	5.824	62.25	4.824
111	4.857	60.45	4.857
117	4.062	59.5	7.062
114	4.153	58.74	5.153
115	4.204	60.08	5.204
111	5.311	60.88	5.311
116	4.361	60.43	5.361
120	3.733	60.3	5.733
120	2.77	61.3	5.77
120	3.802	58.34	5.802
120	2.812	61.12	5.812
113	3.933	58.86	5.933
107	4.955	60.39	5.955
116	4.006	60.47	6.006
118	4.006	60.27	6.006
118	4.024	61.48	6.024
122	2.1	59.16	6.1
118	4.104	59.63	6.104
119	3.176	59.05	6.176
125	2.18	58.95	6.18
115	4.216	60.51	6.216
119	2.275	58.16	6.275
110	5.282	60.12	6.282
120	4.304	59.79	6.304
119	4.367	59.26	6.367
121	2.456	59.43	6.456
123	4.504	60.54	6.504
119	3.509	59.81	6.509
114	4.545	59.61	6.545
123	2.565	59.31	6.565
122	2.62	59.88	6.62
123	4.64	61.38	6.64
123	2.682	58.62	6.682
122	3.741	58.67	6.741
121	3.878	60.01	6.878
121	3.881	58.31	6.881
119	2.891	58.27	6.891
121	3.909	59.48	6.909
122	2.971	60.31	6.971
120	3.99	59.76	6.99
107	5.013	60.11	7.013
117	3.154	60.01	7.154
120	4.22	60.7	7.22
121	4.223	60.57	7.223
120	4.249	60.26	7.249
120	3.287	58.41	7.287
121	2.308	59.26	7.308
122	2.321	58.59	7.321
118	3.341	58.68	7.341
118	4.343	60.1	7.343
120	3.344	60.26	7.344
118	4.383	61.81	7.383
118	4.415	59.3	7.415
122	2.466	59.88	7.466
120	3.485	60.29	7.485
115	3.576	58.95	7.576
118	4.616	59.95	7.616
112	4.635	59.69	7.635
118	3.644	60.56	7.644
110	5.654	61.09	7.654
119	3.724	59.06	7.724
119	3.774	60.15	7.774
118	3.187	60.33	8.187
125	2.212	58.99	8.212
126	2.212	60.81	8.212
120	3.454	58.07	8.454
115	4.533	59.88	8.533
112	3.614	58.62	8.614
113	4.714	58.67	8.714
109	5.731	62.29	6.731
119	3.817	60.48	8.817
116	4.836	60.65	8.836
124	3.924	61.72	8.924
117	4.043	60.51	8.043
119	4.489	59.18	9.489
125	2.541	58.87	9.541
126	1.628	60.95	9.628
111	4.768	60.84	8.768
110	4.918	59.9	8.918

Correlations

HAC_Rate	Nursing_HPPD	Skill_Mix	ALOS
HAC_Rate	1
Nursing_HPPD	-0.7994001015	1
Skill_Mix	-0.304808429	0.4617178002	1
ALOS	0.4171629872	-0.3124349713	-0.1333761694	1

Descriptive Statistics

HAC_Rate	Nursing_HPPD	Skill_Mix	ALOS
Mean	117.1578947368	Mean	3.9431789474	Mean	59.9298947368	Mean	6.6694947368
Standard Error	0.5020263061	Standard Error	0.1009275193	Standard Error	0.0996706216	Standard Error	0.1387045115
Median	118	Median	4.006	Median	59.99	Median	6.682
Mode	119	Mode	4.006	Mode	60.26	Mode	5.812
Standard Deviation	4.8931471609	Standard Deviation	0.9837197748	Standard Deviation	0.9714690507	Standard Deviation	1.3519243485
Sample Variance	23.9428891377	Sample Variance	0.9677045953	Sample Variance	0.9437521165	Sample Variance	1.8276994441
Kurtosis	-0.3055585102	Kurtosis	0.0648079717	Kurtosis	-0.1368188299	Kurtosis	-0.4909637565
Skewness	-0.5678101766	Skewness	-0.0051498755	Skewness	0.2679148903	Skewness	0.0346983946
Range	20	Range	5.091	Range	4.46	Range	5.611
Minimum	106	Minimum	1.628	Minimum	58.07	Minimum	4.017
Maximum	126	Maximum	6.719	Maximum	62.53	Maximum	9.628
Sum	11130	Sum	374.602	Sum	5693.34	Sum	633.602
Count	95	Count	95	Count	95	Count	95
Confidence Level(95.0%)	0.9967849991	Confidence Level(95.0%)	0.2003939556	Confidence Level(95.0%)	0.1978983556	Confidence Level(95.0%)	0.2754010591

Histogram HAC_Rates

Bin	Frequency
106	2
108.2222222222	5
110.4444444444	5
112.6666666667	6
114.8888888889	7
117.1111111111	14
119.3333333333	22
121.5555555556	18
123.7777777778	10
More	6

Histogram of HAC_Rate

Frequency 106 108.2222222 110.4444444 112.6666667 114.8888889 117.1111111 119.3333333 121.5555556 123.7777778 More 2 5 5 6 7 14 22 18 10 6

Bin

Frequency

Regression 1

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.802678891
R Square	0.644293402
Adjusted R Square	0.6365606499
Standard Error	2.949879331
Observations	95
ANOVA
df	SS	MS	F	Significance F
Regression	2	1450.0670767355	725.0335383678	83.3200639618	2.23989862534873E-21
Residual	92	800.5645022118	8.7017880675
Total	94	2250.6315789474
Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	108.913104554	20.5637205276	5.2963715592	0.0000008014	68.0717805885	149.7544285195	68.0717805885	149.7544285195
Nursing_HPPD	-4.163970655	0.3486841011	-11.9419573259	2.10040323342678E-20	-4.8564873771	-3.471453933	-4.8564873771	-3.471453933
Skill_Mix	0.4115487223	0.3530811868	1.1655923275	0.246792365	-0.2897009916	1.1127984362	-0.2897009916	1.1127984362
Dependent variable: HAC_Rate

Regression 2

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.4171629872
R Square	0.1740249579
Adjusted R Square	0.1651435058
Standard Error	1.2352597906
Observations	95
ANOVA
df	SS	MS	F	Significance F
Regression	1	29.8981399683	29.8981399683	19.5942011072	0.0000260411
Residual	93	141.905607779	1.5258667503
Total	94	171.8037477474
Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	-6.8338526449	3.0531780402	-2.2382751857	0.0275893689	-12.8968591367	-0.770846153	-12.8968591367	-0.770846153
HAC_Rate	0.1152576821	0.0260379087	4.4265337576	0.0000260411	0.0635515556	0.1669638085	0.0635515556	0.1669638085
Dependent variable: ALOS