Question

A hospital conducted a study of the waiting time in its emergency room. The hospital has a main campus and three satellite locations. Management has a business objective of reducing waiting time for emergency room cases that do not require immediate attention. To study this, a random sample of 15 emergency room cases that did not require immediate attention at each location were selected on a particular day, and the waiting time (measured from 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 a difference in the mean waiting times in the four locations?

b. Does the result in (a) give you statistical permission to probe for individual differences between hospital locations?

Please help me do this in excel using data analysis tab

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

Answer 1

Answer:

THANK YOU