Question

e. Using Data Analysis in Excel, you obtain the following table. Make a conclusion. Your conclusion should have two parts.
	1) Do you reject or fail to reject the null hypothesis based on your decision rule?

2) Answer the question (Is there a difference in the average number of patients being seen in the emergency room between 2015 and 2016?) based on your decision.

t-Test: Two-Sample Assuming Unequal Variances

		2016	2015
	Mean	5693.75	5155.583333
	Variance	59352.205	63610.44697
	Observations	12	12
	Hypothesized Mean Difference	0
	df	22
	t Stat	5.3164387
p-value-->	P(T<=t) two-tail	2.457E-05
	t Critical two-tail	2.0738731

Answer 1

1)

P-value of two-tail test = 0.00002457

P-value < 0.05 we reject the null hypothesis.

Reject the null hypothesis.

2)

If we reject the null hypothesis then we say that there is a difference in the average number of patients being seen in the emergency room between 2015 and 2016.

Yes, there is a difference in the average number of patients being seen in the emergency room between 2015 and 2016.