Compute Using: Data provided in the problem to the left and the Data Analysis Toolpak, Anova Single Factor

You have worked with numerous hospitals on performance improvement initiatives to enhance

organizational efficiency and effectiveness. You have a hospital client who contacted you to assist them

with emergency room efficiency. The hospital conducted a study of the waiting time in its emergency

room. The hospital has a main campus and three satellite locations. The hospital executive managers have

established a business objective of reducing waiting time for emergency room cases that do not require

immediate attention. To study these cases, 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) was measured.

1. At the 0.05 level of significance, is there evidence of a difference in the mean waiting times in the

four locations?

A. State the null hypothesis

B. State the alternative hypothesis

C. State the decision rule

D. Report the results and findings of your data analysis. Insert a copy of the output table in your report to the client

2. Provide your client with your interpretation of the organizational problem. Based your assessment

on the initial organizational diagnostic and assessment data. What additional information do you

need in order to complete the organizational diagnosis and make a recommendation for an

organizational improvement project? Why is this important to the success of the improvement

initiative?

Data from ERWaiting
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