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?

I WANT THE ANSWER IN EXCEL USING THE DATA ANALYSIS....DO NOT PROVIDE A HAND WRITTEN ANSWER...I'm trying to understand the functions in excel

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