What is hppd in nursing

Presentation

Paper details
I have attached several files for instructions

1- Assessment 4 Instructions

2- Vi Health Simulation Dialogue Text

3- HAC Analysis

4- HACReport as refernced in simulation

I just basically need a head start on this assessment. Stats aren\'t my strong suit.

I will complete the Oral part of the assessment

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