Question

Problem #2 - In excel

In stroke patient care, “Time is brain” is a popular phrase to emphasize that the early medical treatment is associated with increased positive therapeutic effects. One of the most important patient care performance indicators for stroke care is the “Door-to-Needle (DTN)” time (i.e., the number of minutes elapsed between patient’s arrival at the emergency department of a hospital and the infusion of a necessary medication.

The stroke program manager of a hospital wants to determine if the DTN time for patients who came to the hospital with an EMS (emergency medical service) provider is shorter than the DTN time for patients who used a private transportation (e.g., personal car, taxi, etc.).

The DTN time data for the two patient arrival modes are listed in column A and column B of this data sheet. Use a 0.01 significance level and fill out each of the following blank cells to reach your conclusion. Use the Excel "Data Analysis" Toolpak to calculate the necessary statistics.

Data:

EMS	Private
27	93
45	65
39	50
41	60
61	47
29	54
56	60
33	69
25	62
67	28
67	43
45	51
27	51
39	58
40	43
53	14
31	50
59	47
27	93
27	38
56	34
20	35
55	67
24	32
35	34
52	70
31	40
15	25
29	25
24	54
46	44
45	50
26	101
19	50
29	83
37
53

Question:

Step 1	Develop Hypotheses
	H0:
	Ha:
Step 2	Specify the Significance Level (a)
	a=
Step 3	Compute the Test Statistic
	Test Statistic =
Step 4	Determine the Critical Value
	Critical Value =
Step 5	Compute the p-value
	p-value
Step 6	Make your decision whether to reject H0 or not
	p-value vs. a
	Test statistic vs. Critical value
	Decision
Step 7	Interpret the statistical conclusion

Answer 1