Answer this questions. and how to prepare the excel file. And how to get the answers. please explain step by step. For questions 1) - 3), you will provide a research hypothesis, null hypothesis, and appropriate variables. The HAD 518 Inferential Statistics Information Guide may be of assistance to you.

1)

Given the data you have and the belief that a difference exists in the average wait time to register before and after implementation of the Patient Concierge program, you could use a paired t-test to explore the relationship between two variables.

1. state an appropriate null and alternative hypothesis (3 pts. each)

H₀:

H_A:

1. what are the variables you would use from the data file? (3 pts. each)

IV =

DV =

2)

Given the data you have and the belief that a difference exists in the average wait time from registration to time called for a test based on department, you could use a one-way ANOVA test to explore the relationship between two variables.

1. state an appropriate null and alternative hypothesis (3 pts. each)

H₀:

H_A:

1. what are the variables you would use from the data file? (3 pts. each)

IV =

DV =

3)

Given the data you have and the belief that the average wait time to register without the implementation of the Patient Concierge program is different than the average wait time to register with the implementation of the Patient Concierge program, you could use an independent t-test (sometimes called a two-sample t-test) to explore the relationship between two variables.

1. state an appropriate null and alternative hypothesis (3 pts. each)

H₀:

H_A:

1. what are the variables you would use from the data file? (3 pts. each)

IV =

DV =

				Time to	Register to	Total
Month	Year	Concierge	Dept.	Register	Test	Wait
7	2015	Y	Lab	15	15	30
11	2014	N	MRI	19	12	31
12	2015	Y	Lab	22	7	29
3	2015	Y	X-ray	23	9	32
8	2012	N	X-ray	36	4	40
4	2013	N	MRI	30	3	33
10	2014	N	MRI	29	9	38
11	2014	N	X-ray	32	12	44
9	2016	Y	X-ray	18	7	25
4	2016	Y	Lab	19	14	33
12	2011	N	Lab	18	3	21
7	2015	Y	X-ray	21	12	33
8	2011	N	X-ray	37	10	47
10	2013	N	X-ray	27	15	42
2	2014	N	CT Scan	23	8	31
11	2014	N	Lab	26	1	27
7	2016	Y	CT Scan	16	8	24
8	2016	Y	MRI	5	5	10
4	2016	Y	CT Scan	24	13	37
10	2012	N	Lab	39	14	53
8	2013	N	MRI	22	7	29
12	2011	N	CT Scan	29	6	35
1	2014	N	CT Scan	24	11	35
1	2013	N	CT Scan	30	3	33
8	2016	Y	X-ray	22	4	26
2	2014	N	Lab	25	10	35
1	2012	N	CT Scan	37	7	44
6	2011	N	CT Scan	32	1	33
1	2014	N	CT Scan	25	2	27
4	2015	Y	X-ray	4	13	17
2	2016	Y	Lab	12	2	14
8	2016	Y	Lab	25	4	29
1	2015	Y	Lab	23	15	38
12	2015	Y	Lab	15	11	26
2	2015	Y	X-ray	22	3	25