From the ICU data, the group was able to determine the exact patients who stayed in the ICU, these patients' arrival date into the ICU, and their departure date from the ICU. The group was able to calculate the duration of each patient’s ICU stay by calculating the difference between the departure and arrival dates. Each patient’s ICU stay duration was used to calculate the average number of days a patient spends in the ICU.
However, the data provided included people that stay in an ICU bed upon arrival and also people who will transfer to an ICU bed from a regular bed. After sorting the data set by date-time, the group was able to determine the order of beds the patient stayed in (regular vs ICU) and what the next event would be for them based on the calculated probability. Therefore, we have two data sets for the ICU service time depending on the path the patient took between the ICU and regular beds. Following that logic, we have two distributions for ICU bed service time shown below using Arena.
Distribution: Lognormal
Expression: 0.5 + LOGN(13.2, 30.4)
Square Error: 0.006599
Table 1. Arena service time for patients who stay in an ICU bed first (ICU queue)
Distribution: Exponential
Expression: 0.999 + EXPO(13.8)
Square Error: 0.005205
Table 2. Arena service time for patients who move from a RB to ICU bed (transfer queue)
From the hospitalziation dataset, the group determined the number of days that a patient spends in the system by observing the hospital admission time and the end date. This was considered the amount of time that a patient stays in a regular hospital bed. Moreover, similar to the logic of the ICU bed above, we can also create two different distributions of service time depending on the order the patient stays in the ICU beds or regular beds. These distributions were found using Arena software.
Distribution: Lognormal
Expression: 0.5 + LOGN(7.82, 8.32)
Square Error: 0.000663
Table 3. Arena service time for patients stay in RB first (RB queue)
Distribution: Lognormal
Expression: 0.5 + LOGN(8.87, 13.3)
Square Error: 0.004928
Table 4. Arena service time for patients that move from an ICU bed to RB (transfer queue)
After the initial distributions were collected from Arena, this gave the group an idea of which distributions to use for parameter estimation. Originally, the group planned on using moment matching for parameter estimation, however this was discovered to be too complicated as the lognormal distribution requires complex mathematics to solve the equations for the parameters. Instead, the MLE (Most Likely Estimator) process was used as shown in the calculations below.
Figure 4. Parameter estimation for service time for patients who stay in an ICU bed first (ICU queue) using MLE
Figure 5. Parameter estimation for service time for patients who move from a RB to ICU bed (transfer queue) using MLE
Figure 6. Parameter estimation for service time for patients stay in RB first (RB queue) using MLE
Figure 7. Parameter estimation for service time for patients that move from an ICU bed to RB (transfer queue) using MLE
Figures 2, 4, and 5 all were calculated with the lognormal distribution, while Figure 3 was calculated using the gamma distribution. After the parameters for the respective distributions were calculated, the data was bootstrapped in order to gain more accurate results.