Excel For Decision Science

ExcelHW2_XieChengyong.xlsx

Home >Applied Sciences homework help >Excel For Decision Science

Problem 1

Hospital A	Hospital B
81	89
77	64
75	85
74	78
86	89
90	85
62	87
73	77
91	82
98	79
81	69
85	78	Step 1	Develop Hypotheses	Put the data analysis output here (H14)
77	65	H0:	z-Test: Two Sample for Means
78	71	Ha:
83	77
90	88	Step 2	Specify the Significance Level (a)
78	73	a=	0.05
76	68
71	75
80	80	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

Problem #1 A healthcare consultant wants to compare the patient satisfaction ratings of two hospitals. The consultant collects ratings from 20 patients for each of the hospitals as listed in column A and column B of this data sheet. The consultant wants determine whether there is a difference in the patient ratings between the hospitals. The population standard deviations for the ratings are known to be 8 for Hospital A and 10 for Hospital B. Use a 0.05 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.

Problem 2

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	Put the data analysis output here (H17)
53	14	Step 1	Develop Hypotheses
31	50	H0:
59	47	Ha:
27	93
27	38	Step 2	Specify the Significance Level (a)
56	34	a=
20	35
55	67
24	32	Step 3	Compute the Test Statistic
35	34	Test Statistic =
52	70
31	40
15	25	Step 4	Determine the Critical Value
29	25	Critical Value =
24	54
46	44
45	50	Step 5	Compute the p-value
26	101	p-value
19	50
29	83
37	Step 6	Make your decision whether to reject H0 or not
53	p-value vs. a
Test statistic vs. Critical value
Decision
Step 7	Interpret the statistical conclusion

Problem #2 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.