| Literature DB >> 28693579 |
Li Luo1, Le Luo1, Xinli Zhang2, Xiaoli He3.
Abstract
BACKGROUND: Accurate forecasting of hospital outpatient visits is beneficial for the reasonable planning and allocation of healthcare resource to meet the medical demands. In terms of the multiple attributes of daily outpatient visits, such as randomness, cyclicity and trend, time series methods, ARIMA, can be a good choice for outpatient visits forecasting. On the other hand, the hospital outpatient visits are also affected by the doctors' scheduling and the effects are not pure random. Thinking about the impure specialty, this paper presents a new forecasting model that takes cyclicity and the day of the week effect into consideration.Entities:
Keywords: ARIMA; Combinatorial forecasting model; Daily outpatient visits; SES
Mesh:
Year: 2017 PMID: 28693579 PMCID: PMC5504658 DOI: 10.1186/s12913-017-2407-9
Source DB: PubMed Journal: BMC Health Serv Res ISSN: 1472-6963 Impact factor: 2.655
Fig. 1The framework of proposed combinatorial model based on SARIMA and SES models
Fig. 2Daily time-series data of EOV in 2014
Fig. 3Daily time-series data of ROV in 2014
Fig. 4Time series data of EOV
Fig. 5Autocorrelation coefficients of the original time series of EOV
Fig. 6Partial autocorrelation coefficients of the original time series of EOV
Fig. 7Time series data of ROV
Fig. 8Autocorrelation coefficients of the original time series of ROV
Fig. 9Partial autocorrelation coefficients of the original time series of ROV
Parameter estimation and testing of EOV
| Parameter | Estimation | Standard error | t value | Approximate Pr > |t| | Lag |
|---|---|---|---|---|---|
| MA1,1 | 0.45393 | 0.05165 | 8.79 | <.0001 | 2 |
| MA1,2 | 0.25916 | 0.04457 | 5.81 | <.0001 | 3 |
| MA1,3 | −0.14116 | 0.04477 | −3.15 | 0.0018 | 6 |
| MA1,4 | 0.42807 | 0.04878 | 8.78 | <.0001 | 7 |
| AR1,1 | −0.51364 | 0.05550 | −9.25 | <.0001 | 1 |
Parameter estimation and testing of ROV
| Parameter | Estimation | Standard error | t value | Approximate Pr > |t| | Lag |
|---|---|---|---|---|---|
| MA1,1 | 0.30118 | 0.04524 | 6.66 | <.0001 | 2 |
| MA1,2 | 0.36505 | 0.04345 | 8.40 | <.0001 | 3 |
| MA1,3 | −0.14669 | 0.04209 | −3.49 | 0.0006 | 5 |
| MA1,4 | −0.21579 | 0.03792 | −5.69 | <.0001 | 6 |
| MA1,5 | 0.65310 | 0.03797 | 17.20 | <.0001 | 7 |
| AR1,1 | −0.68602 | 0.05706 | −12.02 | <.0001 | 1 |
| AR1,2 | −0.31708 | 0.06558 | −4.83 | <.0001 | 2 |
Fig. 10Fitted and predicted results using ARIMA model in endocrinology department
Fig. 11Fitted and predicted results using ARIMA model in respiratory department
Forecasting performance comparison of two models during the 45th week
| Time series data | Within a single week | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Forecasting performance MAPE |
|---|---|---|---|---|---|---|---|---|---|
| EOV | observed values | 206 | 193 | 182 | 171 | 150 | 86 | 34 | |
| ARIMA model | 194.40 | 189.47 | 194.27 | 248.46 | 197.90 | 66.11 | 41.00 | 19.31% | |
| SES model | 196.76 | 195.68 | 190.00 | 256.56 | 193.76 | 76.33 | 46.28 | 19.55% | |
| ROV | observed values | 173 | 178 | 145 | 161 | 163 | 18 | 11 | |
| ARIMA model | 197.32 | 197.88 | 160.23 | 174.97 | 121.83 | 24.85 | 18.03 | 25.44% | |
| SES model | 186.12 | 196.28 | 177.78 | 185.36 | 126.76 | 27.32 | 13.61 | 21.90% |
Fitting and forecasting performances of combinatorial model in endocrinology department during the 45th week
| Within a single week | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Overall | Workdays | Weekends |
|---|---|---|---|---|---|---|---|---|---|---|
| Combinatorial model fitted | 15.70% | 10.39% | 8.86% | 17.55% | 11.91% | 16.21% | 27.63% | 15.46% | 12.87% | 21.92% |
| Combinatorial model predicted | 5.09% | 0.46% | 5.75% | 47.33% | 30.45% | 15.94% | 29.04% | 19.15% | 17.82% | 22.49% |
| Weighting coefficient l1 | 0.53 | 0.57 | 0.58 | 0.57 | 0.46 | 0.39 | 0.46 | |||
| Weighting coefficient l2 | 0.47 | 0.43 | 0.42 | 0.43 | 0.54 | 0.61 | 0.54 |
Fitting and forecasting performances of combinatorial model in respiratory department during the 45th week
| Within a single week | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Overall | Workdays | Weekends |
|---|---|---|---|---|---|---|---|---|---|---|
| Combinatorial model fitted | 9.85% | 8.86% | 10.60% | 7.73% | 14.20% | 28.69% | 32.15% | 17.14% | 11.82% | 30.37% |
| Combinatorial model predicted | 10.96% | 10.77% | 16.37% | 11.93% | 23.69% | 47.87% | 38.05% | 22.81% | 14.74% | 42.99% |
| Weighting coefficient l1 | 0.52 | 0.55 | 0.51 | 0.50 | 0.48 | 0.28 | 0.36 | |||
| Weighting coefficient l2 | 0.48 | 0.45 | 0.49 | 0.50 | 0.52 | 0.72 | 0.64 |
Residuals comparison between ARIMA, SES and combinatorial model in the 45th week
| Time series data | Model | ARIMA | SES | Combinatorial |
|---|---|---|---|---|
| EOV | Mean of residual | 0.2358 | −0.6678 | −0.1994 |
| Standard deviation of residual | 27.2980 | 30.9600 | 27.1130 | |
| ROV | Mean of residual | −1.8806 | −0.7896 | −1.2008 |
| Standard deviation of residual | 20.4810 | 20.9640 | 19.4588 |
Fitting and forecasting performances comparison of three models in two departments during 8 weeks (I)
| Time series data | Fitted performance(MAPE) | Predicted performance(MAPE) | ||||
|---|---|---|---|---|---|---|
| ARIMA | SES | Combinatorial | ARIMA | SES | Combinatorial | |
| EOV | 15.97% | 16.72% | 14.47% | 11.77% | 13.25% | 10.61% |
| ROV | 23.48% | 16.55% | 16.95% | 15.26% | 13.60% | 13.49% |
Fitting and forecasting performances comparison of three models in two departments during 8 weeks (II)
| Time series data | Prediction performance | Overall | Workdays | Weekends |
|---|---|---|---|---|
| EOV | ARIMA | 11.77% | 11.23% | 13.13% |
| SES | 13.25% | 12.57% | 14.95% | |
| combinatorial | 10.61% | 10.19% | 11.68% | |
| ROV | ARIMA | 15.26% | 9.59% | 28.49% |
| SES | 13.60% | 9.78% | 23.15% | |
| combinatorial | 13.49% | 9.51% | 23.44% |
Residuals comparison between three models during 8 weeks
| Time series data | Residuals comparison | ARIMA | SES | Combinatorial |
|---|---|---|---|---|
| EOV | Mean of residual | 0.6625 | 0.4801 | 0.0504 |
| Standard deviation of residual | 26.9557 | 30.1864 | 26.6696 | |
| ROV | Mean of residual | −1.5736 | 0.4905 | −0.8760 |
| Standard deviation of residual | 24.7444 | 24.5082 | 22.5943 |
Weighting coefficient comparison between three models during 8 weeks
| Time series data | weighting coefficient | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Overall | Workdays | Weekends |
|---|---|---|---|---|---|---|---|---|---|---|---|
| EOV | l1 | 0.52 | 0.57 | 0.57 | 0.57 | 0.47 | 0.38 | 0.45 | 0.51 | 0.54 | 0.42 |
| l2 | 0.48 | 0.43 | 0.43 | 0.43 | 0.53 | 0.62 | 0.55 | 0.49 | 0.46 | 0.58 | |
| ROV | l1 | 0.51 | 0.56 | 0.51 | 0.48 | 0.47 | 0.33 | 0.36 | 0.46 | 0.51 | 0.35 |
| l2 | 0.49 | 0.44 | 0.49 | 0.52 | 0.53 | 0.67 | 0.64 | 0.54 | 0.49 | 0.65 |