Question

Use the given data that represent the waiting time of a randomly selected group of people at an urgent-care clinic and a randomly selected group of people at an emergency clinic.

a. Rearrange the data so that they can be analyzed using regression, and add an independent variable that is 1 for Emergency and 0 Urgent care.

b. Test the hypothesis that waiting time is equal for both groups (against the alternative that they are not equal) using regression and t-test. Then, interpret this results.

Urgent	Emergency
29	33
30	43
32	26
31	46
22	31
26	40
30	34
38	4
29	30
28	24
29	40
38	32
30	36
43	31
23	45
32	20
25	31
32	42
30	29
32	40
35	34
34	44
29	9
21	25
29	29
31	34
36	28
14	37
31	18
36	38
	29
	48
	36
	49
	28
	39
	34
	37
	34
	42

Answer 1

Note that the regression cant be performed on the given data as the sample sizes are different for both urgent and emergency groups

also , note that we can perform a t test independent sample test with unequal variance in excel as shown below

we enter the data and then goto data > data analysis tab and select t test

as the p value is not less than 0.05 , hence we fail to reject the null hypothesis and conclude that the mean values for the 2 groups are not signficantly different