A hospital conducted a study of the waiting time in itsemergency room. The hospital has a main campus and three satellitelocations. Management has a business objective of reducing waitingtime for emergency room cases that do not require immediateattention. To study this, a random sample of 15 emergency roomcases that did not require immediate attention at each locationwere selected on a particular day, and the waiting time (measuredfrom check-in to when the patient was called into the clinic area)were collected and stored in ER.
a. At the 0.05 level of significance, is there evidence of adifference in the mean waiting times in the four locations?
b. Does the result in (a) give you statistical permission toprobe for individual differences between hospital locations?
I WANT THE ANSWER IN EXCEL USING THE DATAANALYSIS....DO NOT PROVIDE A HAND WRITTENANSWER...I'm trying to understand the functions inexcel
| Main | Satellite 1 | Satellite 2 | Satellite 3 |
| 120.08 | 30.75 | 75.86 | 54.05 |
| 81.90 | 61.83 | 37.88 | 38.82 |
| 78.79 | 26.40 | 68.73 | 36.85 |
| 63.83 | 53.84 | 51.08 | 32.83 |
| 79.77 | 72.30 | 50.21 | 52.94 |
| 47.94 | 53.09 | 58.47 | 34.13 |
| 79.88 | 27.67 | 86.29 | 69.37 |
| 48.63 | 52.46 | 62.90 | 78.52 |
| 55.43 | 10.64 | 44.84 | 55.95 |
| 64.06 | 53.50 | 64.17 | 49.61 |
| 64.99 | 37.28 | 50.68 | 66.40 |
| 53.82 | 34.31 | 47.97 | 76.06 |
| 62.43 | 66.00 | 60.57 | 11.37 |
| 65.07 | 8.99 | 58.37 | 83.51 |
| 81.02 | 29.75 | 30.40 | 39.17 |
