A Model for Forecasting the Export Quantity of Fresh or Frozen Pineapples in Thailand


  • Warangkhana Riansut รองศาสตราจารย์ สาขาวิชาคณิตศาสตร์และสถิติ คณะวิทยาศาสตร์ มหาวิทยาลัยทักษิณ


Pineapple, Box-Jenkins, Exponential smoothing


The objective of this study is to construct the appropriate forecasting model for the export quantity of fresh or frozen pineapples in Thailand via the use of statistical methods. The monthly average data, which were gathered from the website of the Office of Agricultural Economics during January 2011 to August 2021 of 128 months were divided into 2 datasets. The first dataset, which consisted of 120 months from January 2011 to December 2020 was used for constructing the forecasting models via the use of 7 statistical methods, namely, Box-Jenkins method, Holt’s exponential smoothing method, Brown’s exponential smoothing method, damped trend exponential smoothing method, simple seasonal exponential smoothing method, Winters’ additive exponential smoothing method, and Winters’ multiplicative exponential smoothing method. The second dataset, which consisted of 8 months from January to August 2021 was used for comparing the accuracy of the forecasting model via the lowest mean absolute percentage error. The results indicated that the most accurate method was the Box-Jenkins method.


Luangtong N, Kantanantha N. Selection of the appropriate agricultural yield forecasting models. Thai Science and Technology Journal. 2016; 24(3): 370-381. Thai.

Office of Agricultural Economics. Export statistics of fresh or frozen pineapples from 2011 to 2021 [Internet]. 2021 [update 2021 Oct 20; cited 2021 Oct 20]. Available from: http://impexp.oae.go.th/service/export.php?S_YEAR=2554&E_YEAR=2564&PRODUCT_GROUP=5252&PRODUCT_ID=5001&wf_search=&WF_SEARCH=Y

Romprasert S. Forecasting trend on Thailand’s pineapple juice export value. Journal of Business Administration. 2013; 2(1): 16-24. Thai.

Eabsirimatee P, Suthikarnnarunai N, Janpong S. Thailand’s canned pineapple forecasting using multiple regression model and artificial neural network. Journal of Nakhonratchasima College. 2016; 10(2): 9-21. Thai.

Riansut W. Forecasting of factory pineapple prices with Box-Jenkins method. Thai Journal of Science and Technology. 2019; 8(2): 105-115. Thai.

Box GEP, Jenkins GM, Reinsel GC. Time series analysis: forecasting and control. 3rd ed. New Jersey: Prentice Hall; 1994.

Ket-iam S. Forecasting technique. 2nd ed. Songkhla: Thaksin University Book Center; 2005. Thai.

Manmin M. Time series and forecasting. Bangkok: Foreprinting; 2006. Thai.