Question

Your IT department provided you data on patients that received ER services, their GHHS, and their recovery time. Prepare a report to share with the owners of the facility that will help you make informed decisions about how long you can expect a patients’ recovery time would be based on their GHHS. Based on your findings provide recommendations on your plan moving forward to improve the functioning of your facilities in generating revenue. Prepare a report that addresses each of these areas.

1. Purpose
2. Importance
3. Variables
4. Sample Size
5. Hypothesis
6. Methodology
7. Findings
8. Interpretations/Implications

ID	Recovery Time	GHSS
137	10	1
141	15	1
165	15	2
197	30	10
140	45	11
126	10	12
156	13	13
110	15	13
160	8	14
135	40	14
121	10	15
197	10	15
132	12	16
119	60	16
128	16	16
197	13	19
134	30	22
197	12	23
155	14	24
130	15	25
150	14	25
112	14	26
108	10	26
100	16	26
161	13	27
163	18	34
117	4	36
169	3	36
144	10	36
106	22	36
123	25	36
157	17	44
158	19	45
129	18	46
197	19	46
159	30	48
197	26	48
177	25	49
142	20	49
115	23	55
193	24	55
102	22	55
170	30	55
186	10	55
197	19	55
113	16	56
182	41	57
197	10	59
124	12	61
183	13	63
143	14	66
197	15	66
120	19	67
178	8	73
111	14	73
127	44	74
166	30	77
152	32	77
139	10	77
109	10	77
197	22	78
176	10	79
131	27	79
197	19	79
197	15	79
197	40	79
138	50	79
180	30	86
197	19	86
197	10	86
192	22	88
197	20	88
145	10	88
116	19	88
149	17	88
197	20	88
196	30	89
185	24	89
190	26	89
148	30	89
151	45	89
197	30	89
164	22	89
114	24	90
162	26	90
167	54	93
133	10	93
118	22	94
194	48	98
179	22	98
174	14	99
181	30	99
136	34	99
197	32	99
107	45	99
125	30	99
		57.96875

Answer 1

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.2923
R Square	0.0855
Adjusted R Square	0.0757
Standard Error	11.1635
Observations	96
ANOVA
	df	SS	MS	F	Significance F
Regression	1	1094.7910	1094.7910	8.7848	0.0038
Residual	94	11714.5423	124.6228
Total	95	12809.3333
	Coefficients	Standard Error	t Stat	P-value	Lower 95%
Intercept	15.1881	2.4649	6.1617	0.0000	10.2940
GHSS	0.1118	0.0377	2.9639	0.0038	0.0369

recovery time^ = 15.1881 + 0.1118 GHSS

sample size is 96

Hypothesis

p-value = 0.0038

p-value < alpha

hence we reject the null hypothesis

we conclude that GHSS is significant