Homework SourseThe enclosed data is results of patient satisfaction from 2
The enclosed data is results of patient satisfaction from 2 different hospitals in your healthcare system related to patient experience in the Emergency Department (ED). One hundred patients from each hospital took a survey related to their satisfaction after being treated in the ED. The survey results were calculated on a scale from 0 to 10, with 10 indicating complete satisfaction. Hospitals are titled Hospital A and Hospital B. You want to know if patient satisfaction in the ED was the same or different based on the hospital.
#1. What is your null hypothesis (H0) for this research topic? (Select either A or B from below.)
a. ED patient satisfaction is dependent on which hospital treatment was recieved from.
b. There is no difference in patient satisfaction related to the ED experience in Hospital A or Hospital B.
#2. Calculate the mean of the patient satisfaction score for each hospital.
a. ______ Hospital A patient satistfaction
b. ______ Hospital B patient satisfaction
#3. Perform the appropriate statistical test to test for significance between the the two groups. Note, you can use the \"data analysis toolpak\" to get your result. Based on your results:
a. What p-value did you find and is this significant?
b. Would you accept or reject the null hypothesis?
| Hospital A | Hospital B |
| 9.1 | 9.9 |
| 7.8 | 6.1 |
| 1.1 | 6.8 |
| 8.8 | 8.3 |
| 3.3 | 3.0 |
| 5.6 | 0.9 |
| 1.4 | 9.9 |
| 9.1 | 3.8 |
| 3.4 | 6.1 |
| 7.6 | 9.3 |
| 5.8 | 3.4 |
| 1.0 | 7.2 |
| 8.5 | 5.3 |
| 7.7 | 6.9 |
| 3.7 | 9.0 |
| 4.6 | 2.5 |
| 7.8 | 5.5 |
| 0.9 | 3.9 |
| 8.3 | 8.6 |
| 1.1 | 4.5 |
| 4.0 | 3.0 |
| 3.2 | 5.2 |
| 8.8 | 0.2 |
| 0.2 | 0.7 |
| 8.0 | 2.6 |
| 1.7 | 8.0 |
| 3.2 | 7.0 |
| 8.9 | 5.9 |
| 4.5 | 1.1 |
| 2.8 | 8.8 |
| 8.8 | 6.3 |
| 7.9 | 3.7 |
| 1.5 | 4.3 |
| 9.2 | 9.0 |
| 7.2 | 8.2 |
| 3.9 | 7.4 |
| 7.5 | 8.3 |
| 3.2 | 7.6 |
| 3.8 | 2.7 |
| 1.8 | 3.2 |
| 3.6 | 4.1 |
| 4.8 | 9.2 |
| 7.2 | 9.9 |
| 7.1 | 7.4 |
| 4.3 | 6.6 |
| 2.8 | 8.2 |
| 4.6 | 7.6 |
| 7.2 | 7.5 |
| 8.0 | 9.2 |
| 2.8 | 3.7 |
| 5.8 | 8.1 |
| 5.1 | 9.5 |
| 9.2 | 7.9 |
| 7.1 | 6.5 |
| 1.4 | 6.9 |
| 5.2 | 3.9 |
| 9.8 | 3.8 |
| 5.3 | 9.3 |
| 3.2 | 6.3 |
| 3.6 | 8.9 |
| 8.0 | 10.0 |
| 5.2 | 8.7 |
| 5.1 | 9.7 |
| 9.6 | 8.6 |
| 9.9 | 6.2 |
| 5.8 | 8.3 |
| 6.7 | 7.2 |
| 0.6 | 7.0 |
| 9.3 | 3.8 |
| 1.6 | 4.5 |
| 0.2 | 3.7 |
| 5.5 | 4.5 |
| 1.7 | 7.6 |
| 4.5 | 10.0 |
| 8.4 | 7.1 |
| 9.3 | 9.5 |
| 1.9 | 3.1 |
| 8.1 | 7.9 |
| 9.2 | 8.8 |
| 8.9 | 1.2 |
| 2.6 | 8.9 |
| 7.1 | 7.7 |
| 8.1 | 6.5 |
| 0.9 | 8.9 |
| 1.0 | 6.8 |
| 9.3 | 9.0 |
| 7.2 | 7.0 |
| 7.5 | 9.4 |
| 5.6 | 9.0 |
| 8.4 | 7.7 |
| 9.4 | 2.7 |
| 1.1 | 5.9 |
| 0.6 | 8.5 |
| 9.8 | 7.6 |
| 2.0 | 5.0 |
| 7.7 | 8.1 |
| 0.7 | 6.6 |
| 0.7 | 5.3 |
| 8.3 | 10.0 |
| 6.7 | 7.5 |
Solution
