Write a 2–4-page executive summary to accompany the PowerPoint presentation that provides additional context to the results of data analysis.

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.799	1
Skill_Mix	-0.305	0.462	1
ALOS	0.417	-0.312	-0.133	1

Descriptive Statistics

	HAC_Rate	Nursing_HPPD	Skill_Mix	ALOS
Mean	117.16	3.94	59.93	6.67
Standard Error	0.50	0.10	0.10	0.14
Median	118.00	4.01	59.99	6.68
Mode	119.00	4.01	60.26	5.81
Standard Deviation	4.89	0.98	0.97	1.35
Sample Variance	23.94	0.97	0.94	1.83
Kurtosis	-0.31	0.06	-0.14	-0.49
Skewness	-0.57	-0.01	0.27	0.03
Range	20	5.091	4.46	5.611
Minimum	106	1.628	58.07	4.017
Maximum	126	6.719	62.53	9.628
Sum	11130	374.602	5693.34	633.602
Count	95	95	95	95
Confidence Level(95.0%)	1.00	0.20	0.20	0.28

Histogram HAC_Rates

Bin	Frequency
106.0	2
108.2	5
110.4	5
112.7	6
114.9	7
117.1	14
119.3	22
121.6	18
123.8	16

Histogram of HAC_Rate

106 108.22222222222223 110.44444444444444 112.66666666666667 114.88888888888889 117.11111111111111 119.33333333333333 121.55555555555556 123.77777777777777 2 5 5 6 7 14 22 18 16

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.913	20.5637205276	5.2963715592	0.0000008014	68.0717805885	149.7544285195	68.0717805885	149.7544285195
Nursing_HPPD	-4.164	0.3486841011	-11.9419573259	2.10040323342678E-20	-4.8564873771	-3.471453933	-4.8564873771	-3.471453933
Skill_Mix	0.412	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

1

2

3

4

A

B

C

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