FORECASTING TOURIST ARRIVALS IN GUILIN CITY USING STATISTICAL TECHNIQUES

Authors

  • LiJun Wang Faculty of Management, Lampang Rajabhat University
  • Napawan Netpradit Faculty of Management, Lampang Rajabhat University
  • Richeng Huang Faculty of Management, Lampang Rajabhat University

Keywords:

Holt-Winters, tourist arrivals, Guilin

Abstract

            This study forecasts tourist arrivals in Guilin using quarterly data from the Guilin Bureau of Statistics spanning 1999–2024 (n=104). Six univariate time-series techniques were benchmarked—Trend Analysis, Classical Decomposition (additive/multiplicative), Moving Average, Single and Double Exponential Smoothing, and the Holt-Winters method—with model selection based on Mean Absolute Deviation (MAD) and Mean Absolute Percentage Error (MAPE). The series displays a sustained upward trend with pronounced quarterly seasonality. Consistent with the research objective of identifying the most accurate forecasting approach, the Holt-Winters model with multiplicative seasonality achieved the best fit and predictive accuracy (MAPE=17; MAD=216), capturing peak–off-peak patterns and recent dynamics robustly. These findings indicate that incorporating seasonality multiplicatively is crucial for destinations where demand growth amplifies seasonal fluctuations. The selected model provides reliable short-term forecasts to support capacity planning, resource allocation, and targeted marketing in Guilin’s tourism sector, and offers a practical baseline for method selection in destination forecasting.

Author Biographies

LiJun Wang, Faculty of Management, Lampang Rajabhat University

Faculty of Management, Lampang Rajabhat University 

Napawan Netpradit, Faculty of Management, Lampang Rajabhat University

Faculty of Management, Lampang Rajabhat University 

Richeng Huang, Faculty of Management, Lampang Rajabhat University

Faculty of Management, Lampang Rajabhat University 

References

Febrian, D., Al Idrus, S.I., & Nainggolan, D.A.J. (2020). The comparison of double moving average and double exponential smoothing methods in forecasting the number of foreign tourists coming to North Sumatera. Journal of Physics: Conference Series, 1462(1), p. 012046. https://doi:10.1088/1742-6596/1462/1/012046

Guangxi Bureau of Statistics. (2024). Guangxi statistical yearbook 2024 (Table 3-6; Table 17-11). Beijing: China Statistics Press.

Ismail, F., Sha'ari, N.A., Zuhairi, A.I.M., Norshahidi, N.D., & Husin, W.Z.W. (2025). Forecasting International Tourist Arrivals in Malaysia using Holt-Winters Model. Gading Journal for the Social Sciences, 28(2), pp. 69-79. https://doi.org/10.24191/gading.v28 i2.589

Ivanovski, Z., Milenkovski, A., & Narasanov, Z. (2018). Time series forecasting using a moving average model for extrapolation of number of tourists. UTMS Journal of Economics, 9(2), pp. 121–132.

Mahmud, N., Muhammat Pazil, N.S., & Amir Razuan, N.A.Z. (2025). Tourist Arrivals in Malaysia Post-COVID-19: A Comparison Between Holt-Winters and ARIMA Model. ASM Science Journal, 20(2), pp. 1-9. https://doi.org/10.32802/asmscj.2025.1719

Maliberan, R.M.E. (2019). Forecasting tourist arrival in the province of Surigao del sur, Philippines using time series analysis. JOIV: International Journal on Informatics Visualization, 3(3), pp. 255-261. http://dx.doi.org/10.30630/joiv.3.3.268

Paudel, T., Li, W., & Dhakal, T. (2024). Forecasting tourist arrivals in Nepal: A comparative analysis of seasonal models and implications. Journal of Statistical Theory and Applications, 23(3), pp. 206-223. https://doi.org/10.1007/s44199-024-00079-7

Downloads

Published

2025-12-26

Issue

Section

บทความวิจัย