Question

Organization: Freestanding ER Services

Title: ER Operations Manager

Outline:

1. Multiple Regression: Effect of Age and General Health Status Score on Total ER Cost.
   1. Purpose
   2. Importance
   3. Variables
   4. Sample Size
   5. Hypothesis
   6. Methodology
   7. Findings
   8. Interpretations/Implications

Description of each Section

Purpose: Identify the purpose of the analysis in this section. What questions do you hope to answer?

Importance: State and explain the importance of this analysis to the department/organization. How will the findings be used?

Variables: List all variables, explain how they will be measured, and how they will be collected.

Sample Size: State your sample size and when data is collected.

Hypothesis: What are your null and alternate hypothesis?

Methodology: State the statistical method used in this section.

Findings: Copy and Paste all relevant output from Excel into this section. State your major findings from the included tables/charts.

Interpretaions/Implications: Discuss what the department/organization needs to do based on the findings.

ID	Insurance	Location	Wait Time	Age	GHSS	Cost
126	Uninsured	Moore	60	11	12	$12,000
107	Uninsured	Moore	25	13	99	$7,800
110	Uninsured	Moore	45	16	13	$478
141	Uninsured	West	34	31	1	$135
160	Insurance	Moore	2	47	14	$1,200
128	Uninsured	Moore	22	47	16	$4,600
166	Insurance	Moore	12	49	77	$4,400
121	Insurance	Moore	25	52	15	$4,500
120	Insurance	West	15	56	67	$4,450
124	Insurance	Moore	22	57	61	$1,200
132	Insurance	Moore	54	59	16	$1,200
130	Insurance	Moore	55	60	25	$1,200
108	Uninsured	Moore	10	60	26	$1,365
161	Insurance	Moore	56	62	27	$1,200
115	Government	Moore	15	63	66	$13,000
163	Insurance	Moore	61	66	34	$1,400
158	Uninsured	Moore	56	71	45	$1,300
138	Uninsured	Moore	15	74	79	$4,900
113	Government	Moore	25	78	56	$13,000
139	Uninsured	West	13	78	77	$4,850
180	Government	Moore	33	79	86	$12,000
182	Government	Moore	34	80	57	$900
176	Government	Moore	55	85	79	$1,245
177	Government	Moore	60	87	49	$678
178	Government	Moore	45	89	73	$450
133	Uninsured	West	45	89	93	$9,850
149	Uninsured	Moore	14	90	88	$4,500
193	Government	Moore	34	90	99	$8,700
114	Government	Moore	44	91	90	$5,000
102	Government	Pelican	20	5	1	$680
165	Uninsured	Pelican	11	5	2	$899
109	Uninsured	Pelican	89	6	77	$12,000
152	Insurance	Pelican	15	6	77	$14,000
140	Insurance	Pelican	20	7	11	$9,000
192	Government	West	20	7	13	$450
174	Government	Pelican	20	7	15	$6,785
155	Insurance	Pelican	20	7	24	$850
112	Government	West	22	8	26	$450
169	Insurance	Pelican	20	8	36	$960
137	Insurance	Pelican	25	9	1	$6,000
194	Government	West	22	9	11	$450
156	Insurance	West	25	10	13	$11,000
197	Government	Pelican	23	12	18	$195
143	Insurance	Pelican	26	14	66	$650
164	Uninsured	West	22	14	89	$4,500
170	Government	West	24	15	99	$4,630
135	Insurance	Pelican	31	16	14	$9,000
119	Insurance	Pelican	34	17	16	$1,200
196	Government	Pelican	24	18	19	$1,645
150	Uninsured	Pelican	23	18	25	$879
134	Insurance	Pelican	36	19	22	$950
185	Government	Pelican	26	19	26	$1,200
145	Government	West	28	19	88	$13,000
179	Government	West	28	22	1	$456
157	Insurance	West	36	22	44	$980
181	Government	Pelican	29	24	13	$7,100
144	Insurance	Pelican	44	24	36	$1,300
100	Uninsured	Pelican	45	27	26	$1,500
159	Insurance	Pelican	44	27	48	$15,000
131	Insurance	Pelican	45	30	79	$1,500
125	Uninsured	Pelican	56	30	99	$12,000
186	Government	West	36	34	13	$156
136	Insurance	Pelican	45	34	99	$4,500
116	Government	West	36	36	16	$4,900
148	Insurance	West	48	36	89	$14,800
106	Insurance	West	55	38	36	$1,356
129	Insurance	Pelican	55	43	46	$4,500
190	Government	Pelican	36	44	16	$1,200
123	Insurance	Pelican	56	44	36	$1,630
142	Uninsured	Pelican	61	45	49	$4,680
117	Government	Pelican	39	46	36	$4,950
104	Government	Pelican	43	47	12	$4,977
154	Government	Pelican	44	48	24	$1,200
103	Government	West	46	50	56	$5,500
184	Government	Pelican	24	51	57	$5,500
189	Government	Pelican	46	55	23	$1,300
122	Government	West	49	56	66	$1,230
153	Government	West	15	56	99	$5,600
191	Government	West	15	57	68	$1,340
183	Uninsured	Pelican	9	58	63	$1,345
101	Government	Pelican	18	59	89	$8,800
151	Insurance	Pelican	14	64	89	$5,600
173	Government	Pelican	13	66	23	$2,300
172	Government	Pelican	55	67	69	$678
146	Government	Pelican	14	67	88	$6,600
175	Government	Pelican	24	74	37	$1,300
105	Government	Pelican	15	74	88	$8,890
188	Government	Pelican	4	76	36	$134
187	Government	Pelican	3	78	69	$7,400
162	Insurance	Pelican	14	88	90	$2,000
147	Government	Pelican	13	88	99	$9,450
168	Government	Pelican	13	91	73	$8,700
118	Insurance	Pelican	13	91	94	$10,000
167	Insurance	Pelican	13	93	93	$8,999
127	Insurance	Pelican	14	94	74	$550
171	Government	Pelican	14	98	74	$15,000
111	Insurance	Pelican	12	99	73	$900
197	Uninsured	West	55	80	59	$780
197	Government	West	21	19	26	$1,450
197	Uninsured	West	14	29	88	$8,900
197	Government	West	19	36	44	$1,200
197	Uninsured	West	15	36	55	$1,300
197	Government	West	17	43	99	$900
197	Uninsured	West	16	44	46	$4,400
197	Government	West	35	45	78	$7,780
197	Uninsured	Pelican	19	45	86	$4,465
197	Uninsured	West	60	47	23	$1,200
197	Government	Pelican	47	48	22	$1,430
197	Government	Pelican	14	55	88	$12,800
197	Insured	Pelican	10	65	10	$1,200
197	Government	West	46	67	67	$650
197	Insured	Pelican	21	69	79	$4,458
197	Insured	West	22	70	15	$1,200
197	Insured	Pelican	27	73	66	$4,600
197	Insured	Pelican	28	74	78	$7,748
197	Insured	Pelican	36	76	19	$1,200
197	Insured	Pelican	25	77	48	$1,400
197	Government	Pelican	13	77	79	$12,000
197	Insured	Pelican	44	78	79	$9,900
197	Government	Pelican	25	78	99	$1,800
197	Insured	Pelican	76	81	89	$4,500
197	Insured	Pelican	38	82	79	$5,000
197	Government	Pelican	19	89	44	$3,000
197	Government	Moore	55	89	96	$5,750
197	Insured	Moore	37	89	99	$12,000
197	Government	Moore	56	90	79	$10,000
197	Insured	Moore	44	94	86	$55
				51.18898	53.24409	4486.15

Answer 1

Using Excel

data -> data analysis-> regression

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.4689
R Square	0.2199
Adjusted R Square	0.2073
Standard Error	3732.5434
Observations	127
ANOVA
	df	SS	MS	F	Significance F
Regression	2	486961883.1374	243480941.5687	17.4765	0.0000
Residual	124	1727553135.0201	13931880.1211
Total	126	2214515018.1575
	Coefficients	Standard Error	t Stat	P-value	Lower 95%
Intercept	2070.5160	752.3254	2.7522	0.0068	581.4533
Age	-26.9953	13.6582	-1.9765	0.0503	-54.0286
GHSS	71.3223	12.2760	5.8099	0.0000	47.0247

y^ = 2070.5160 -26.9953 Age +71.3223 GHSS

the model is overall significant as p-value = 0.0000 < alpha

when Age increases by 1 year, on averege ER cost decrease by 27

when GHSS increases by 1 unit, on average ER cost increase by 71.3223