Optimizing Ermergeny Room Staff Statistics Project

Optimizing Ermergeny Room Staff - Statistics Project Example Collected data included age and sex of patient, date and time patient arrived, date and time patient treatment began and triage number, Triage number is a scale used in the ER that identifies the urgency of care, standard waiting time, average length of treatment time and the number of nurses required. See Appendix A. The number of patients was summarized according to a 1-hr time interval of its arrival to the ER. Frequency distribution, time series and regression analysis were created to determine the trend. See Appendix B. The wait time in minutes was summarized according to a 4-hr interval of the patients arrival. See Appendix C. The 4-hr interval is also identified as the 4-hr work shift of nurses. The distribution of average wait time per month was made to identify the volume of patients having a long wait time in the 4-hr work shift. Analysis of variance was conducted to determine if there are any significant differences between them with respect to mean waiting time. The treatment time in minutes was also summarized according to a 4-hr time interval of nurse's work shift. The treatment time is the average time needed by the nurses to care for patients with respect to its urgency according to the triage number. The distribution of total treatment time per month was made to identify the volume of nurses time in the 4-hr work shift. Figure 1 shows the frequency distribution of the number of patients arriving per month on a 1-hr... Figure 2 shows the time series of the patients arriving per day on a 1-hr time interval. There is a seasonal trend identified per day which further confirms the observation from the frequency diagram. A single factor analysis of variance was conducted using Microsoft Excel Add-In. The results in Table 1 show that the F-value is smaller than the F critical and the P-value is relatively large. The null hypothesis stating that all means of patient arrival per month is equal and there is no statistical differences between the monthly data. This concurs that the data of patients per month can be summarized into a 24 hr patient arrival behavior. Table 1. Anova: Single Factor SUMMARY Groups Count Sum Average Variance JUN 24 326 13.5833 60.3406 JUL 24 305 12.7083 56.1286 AUG 24 364 15.1667 69.0145 SEP 24 362 15.0833 92.5145 OCT 24 293 12.2083 55.6504 NOV 24 334 13.9167 53.9058 Source of Variation SS df MS F P-value F crit Between Groups 175.14 5 35.028 0.542 0.744 2.280 Within Groups 8913.75 138 64.592 Total 9088.889 143 Figure 3 shows the best fit line graph of patients arrival from 3:00 am to 22:00 pm. The R-squared value of 0.8839 shows high linearity on the trend. The number of patients increases with time during this period. The coefficient of increase is 0.1148. 2. Wait Time of Patients The frequency distribution of wait time is shown in Figure 4. The mean time to wait is 131.11 minutes with a standard deviation of 87.62 minutes. The confidence level at 95% is 3.85 minutes. The shape of the distribution is skewed to the left. This means that the data may contain outliers with very large waiting time. Figure 5 shows the patient's average time