Question

Title: ER Operations Manager Used the files attached to answer the following Questions: o Use this Excel file C 3 and C 4 Excel file.xlsx o Use this file to submit your work C4 Part IIdocx Question 2: 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 ting: Monthly Patient Volume. Question 3: Forec Scenario: You are the manager of an ER clinic. You are planning for the month of January and want to know what expected patient daily volume will be. Forecast daily patient volume based on data for the month of January Your IT department provided you data on patient daily volume for the month of January. Prepare a report to share with the owners of the facility that will help you make informed decisions about planning for the next month. Prepare a report that addresses each of these areas 1. Purpose 2. Importance 3. Variables 4. Sample Size 5. Methodology 6. Findings 7. Interpretations/Implications

Answer 1

2)

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

$Ho : \beta_1 = \beta_2 = 0$

Ha: not all coefficients are 0

the model is overall significant as p-value = 0.0000

Age has p-value = 0.0503 > 0.05

hence Age is not statistically significant

whereas GHSS has p-value = 0.000

hence GHSS is statistically significant

sample size = 127